private bool Kasa_Kayit(string UserName, string UserPassword, int FirmNo)

        {

            bool isOk = false;

            try

            {

                UnityApplicationClass app = new UnityApplicationClass();

                app.Login(UserName, UserPassword, FirmNo);

                if (!app.LoggedIn)

                {

                    if (app.Login(UserName, UserPassword, FirmNo) == false)

                    {

                        string r = app.GetLastError().ToString() + ":" + app.GetLastErrorString();

                        app = null;

                        MessageBox.Show("Logo bağlantı hatası! " + r);

                    }

                }

                UnityObjects.Data Kasa = app.NewDataObject(DataObjectType.doSafeDepositTrans);

                DateTime now = DateTime.Now;

                TimeSpan ts = DateTime.Now.TimeOfDay;

                object Saat = new object();

                Kasa.New();

private bool Kasa_Kayit(string UserName, string UserPassword, int FirmNo)

        {

            bool isOk = false;

            try

            {

                UnityApplicationClass app = new UnityApplicationClass();

                app.Login(UserName, UserPassword, FirmNo);

                if (!app.LoggedIn)

                {

                    if (app.Login(UserName, UserPassword, FirmNo) == false)

                    {

                        string r = app.GetLastError().ToString() + ":" + app.GetLastErrorString();

                        app = null;

                        MessageBox.Show("Logo bağlantı hatası! " + r);

                    }

                }

                UnityObjects.Data Kasa = app.NewDataObject(DataObjectType.doSafeDepositTrans);

                DateTime now = DateTime.Now;

                TimeSpan ts = DateTime.Now.TimeOfDay;

                object Saat = new object();

                Kasa.New();

            filepath = String.Concat(filepath, "xls");

            filepath = String.Concat(filepath, "xls");

        private void btnStart_Click(object sender, EventArgs e)

        {

            Start();

        }

        private void Start()//Sayaç başlasın (program start)

        {

            SaniyeSayac = 0;

            tmrSayac.Start();

            tmrWebOrder.Interval = int.Parse(txtInterval.Text); //kaç saniyede bir çalışmasını istiyorsak onu yazıyoruz

            tmrWebOrder.Start();

            btnStart.Enabled = false;

            btnStop.Enabled = true;

        }

        private void btnStart_Click(object sender, EventArgs e)

        {

            Start();

        }

        private void Start()//Sayaç başlasın (program start)

        {

            SaniyeSayac = 0;

            tmrSayac.Start();

            tmrWebOrder.Interval = int.Parse(txtInterval.Text); //kaç saniyede bir çalışmasını istiyorsak onu yazıyoruz

            tmrWebOrder.Start();

            btnStart.Enabled = false;

            btnStop.Enabled = true;

        }

        {

            DeleteSelectedRows(gridControl1, gridView1, "LOGID");

        }

        private void DeleteSelectedRows(GridControl gvControl, GridView gv, string column)

        {

        {

            DeleteSelectedRows(gridControl1, gridView1, "LOGID");

        }

        private void DeleteSelectedRows(GridControl gvControl, GridView gv, string column)

        {

LookUpEdit Controlünde program çalışma esnasında kullanacağımız fakat ekran da görünmesini istemediğimiz sütün başlıklarını gizleme örnegi

LookUpEdit Controlünde program çalışma esnasında kullanacağımız fakat ekran da görünmesini istemediğimiz sütün başlıklarını gizleme örnegi

#region Image'yi Byte evir ==> Database'e yazmak iin

public byte[] imageToByteArray(System.Drawing.Image imageIn)

{

          MemoryStream ms = new MemoryStream();

          imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

          return ms.ToArray();

}

#endregion

#region Image'yi Byte evir ==> Database'e yazmak iin

public byte[] imageToByteArray(System.Drawing.Image imageIn)

{

          MemoryStream ms = new MemoryStream();

          imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

          return ms.ToArray();

}

#endregion

Bu örnekte excelden grid controle veri bağlama incelenecektir. bu kod ile excel ortamından veri alıp grid türü bir kontrole bağladıktan sonra bir döngü ile veriyi SQL Server'de bir tabloya veri yazılabilir. 

Bu örnekte excelden grid controle veri bağlama incelenecektir. bu kod ile excel ortamından veri alıp grid türü bir kontrole bağladıktan sonra bir döngü ile veriyi SQL Server'de bir tabloya veri yazılabilir. 

                        {

                            ILines SL_DETAILS = _invoiceLines[_invoiceLines.Count - 1].FieldByName("SL_DETAILS").Lines;

                            for (int i = 0; i < dtSeriNoList.Rows.Count; i++)

                            {

                                if (_FSatirlari.MASTER_CODE.ToString()==dtSeriNoList.Rows[i][0].ToString())

                                {

                                    if (SL_DETAILS.AppendLine())

                                    {

                                        SL_DETAILS[0].FieldByName("SOURCE_MT_REFERENCE").Value = dtSeriNoList.Rows[i]["SOURCE_MT_REFERENCE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_SLT_REFERENCE").Value = dtSeriNoList.Rows[i]["SOURCE_SLT_REFERENCE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("IOCODE").Value = dtSeriNoList.Rows[i]["IOCODE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_WH").Value = dtSeriNoList.Rows[i]["SOURCE_WH"].ToString();

                                        SL_DETAILS[0].FieldByName("SL_TYPE").Value = "2";

                                        SL_DETAILS[0].FieldByName("SL_CODE").Value = dtSeriNoList.Rows[i]["SL_CODE"].ToString();

                                        SL_DETAILS[0].FieldByName("MU_QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("UNIT_CODE").Value = dtSeriNoList.Rows[i]["UNIT_CODE"].ToString();

                                        SL_DETAILS[0].FieldByName("QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("UNIT_CONV1").Value = dtSeriNoList.Rows[i]["UNIT_CONV1"].ToString();

                                        SL_DETAILS[0].FieldByName("UNIT_CONV2").Value = dtSeriNoList.Rows[i]["UNIT_CONV2"].ToString();

                                        SL_DETAILS[0].FieldByName("DATE_EXPIRED").Value = dtSeriNoList.Rows[i]["DATE_EXPIRED"].ToString().Substring(0, 10);

                                        SL_DETAILS[0].FieldByName("ORGLINKREF").Value = 0;

                                        //sCount += 1;

                                    }

                                }

                            }

                        }

                        #endregion

                        {

                            ILines SL_DETAILS = _invoiceLines[_invoiceLines.Count - 1].FieldByName("SL_DETAILS").Lines;

                            for (int i = 0; i < dtSeriNoList.Rows.Count; i++)

                            {

                                if (_FSatirlari.MASTER_CODE.ToString()==dtSeriNoList.Rows[i][0].ToString())

                                {

                                    if (SL_DETAILS.AppendLine())

                                    {

                                        SL_DETAILS[0].FieldByName("SOURCE_MT_REFERENCE").Value = dtSeriNoList.Rows[i]["SOURCE_MT_REFERENCE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_SLT_REFERENCE").Value = dtSeriNoList.Rows[i]["SOURCE_SLT_REFERENCE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("IOCODE").Value = dtSeriNoList.Rows[i]["IOCODE"].ToString();

                                        SL_DETAILS[0].FieldByName("SOURCE_WH").Value = dtSeriNoList.Rows[i]["SOURCE_WH"].ToString();

                                        SL_DETAILS[0].FieldByName("SL_TYPE").Value = "2";

                                        SL_DETAILS[0].FieldByName("SL_CODE").Value = dtSeriNoList.Rows[i]["SL_CODE"].ToString();

                                        SL_DETAILS[0].FieldByName("MU_QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("UNIT_CODE").Value = dtSeriNoList.Rows[i]["UNIT_CODE"].ToString();

                                        SL_DETAILS[0].FieldByName("QUANTITY").Value = "1";

                                        SL_DETAILS[0].FieldByName("UNIT_CONV1").Value = dtSeriNoList.Rows[i]["UNIT_CONV1"].ToString();

                                        SL_DETAILS[0].FieldByName("UNIT_CONV2").Value = dtSeriNoList.Rows[i]["UNIT_CONV2"].ToString();

                                        SL_DETAILS[0].FieldByName("DATE_EXPIRED").Value = dtSeriNoList.Rows[i]["DATE_EXPIRED"].ToString().Substring(0, 10);

                                        SL_DETAILS[0].FieldByName("ORGLINKREF").Value = 0;

                                        //sCount += 1;

                                    }

                                }

                            }

                        }

                        #endregion