Kategori: C#

Umut Yazılım - Logo Ürünlerinde ve Yazılımda 20 yıllık tecrübe..

gridView Satırları silme

for (int i = 0; i < gridView1.RowCount;)gridView1.DeleteRow(i);

GridView Sıralama

GridView gridView = gridControl1.FocusedView as GridView;gridView.BeginSort();try {gridView.ClearSorting();gridView.Columns[“Country”].SortOrder = ColumnSortOrder.Ascending;gridView.Columns[“City”].SortOrder = ColumnSortOrder.Descending;}finally {gridView.EndSort();}

XtraMessageBox Kullanımı

XtraMessageBox.Show(ex.ToString(), “Information..”, MessageBoxButtons.OK, MessageBoxIcon.Error);

Devexpress Grid Layout save and restore

private void btndizaynkatdet_Click(object sender, EventArgs e){string yol = Application.StartupPath;string fileName = yol + “\gridlayout\MarkaBazliSatislar.xml”;pivotGridControl1.SaveLayoutToXml(fileName);// …} private void btnmarkabazlisatis_Click(object sender, EventArgs e) { string yol = Application.StartupPath; string fileName = yol + “\\gridlayout\\MarkaBazliSatislar.xml”; try { pivotGridControl1.RestoreLayoutFromXml(fileName); } catch (Exception) { } } Registry ye yazma okuma

C# Dosya yolu ile açma

string yol = Application.StartupPath;string fileName = yol + “\gridlayout\maliyettablo.xml”; string uygulamayolu = “DbAyar.EXE”;System.Diagnostics.Process.Start(uygulamayolu);

DataReader Kullanımı

baglanti.Open();komut = new OleDbCommand(“Select * From Urunler Where UrunID=” + urunID, baglanti);OleDbDataReader oku = komut.ExecuteReader();while (oku.Read()){textEdit1.Text = oku[“UrunID”].ToString();textEdit2.Text = oku[“UrunAd”].ToString();textEdit3.Text = oku[“KategoriAd”].ToString();textEdit4.Text = oku[“UrunAdet”].ToString();textEdit5.Text = oku[“UrunBirim”].ToString();textEdit6.Text = oku[“UrunFiyat”].ToString();memoEdit1.Text = oku[“UrunAciklama”].ToString();}baglanti.Close();

SaveFileDialog Kullanımı

SaveFileDialog save = new SaveFileDialog();if (save.ShowDialog() == DialogResult.OK) //Pencerede kayıt düğmesine basıldıysa{gridControl2.ExportToXlsx(save.FileName + “.xlsx”);DialogResult basilan = DevExpress.XtraEditors.XtraMessageBox.Show(“Excel Sayfası Açılsın mı?????”, “Uyarı”, MessageBoxButtons.YesNo, MessageBoxIcon.Question);if (basilan == DialogResult.Yes){System.Diagnostics.Process.Start(save.FileName + “.xlsx”);}}

SplashScreenManager Kullanımı

SplashScreenManager.ShowForm(typeof(Bekleyiniz));DataGetir();SplashScreenManager.CloseForm();

Gridview koşullu biçimlendirme

private void gridView1_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e){GridView View = sender as GridView;if (e.RowHandle >= 0){string okunma = View.GetRowCellDisplayText(e.RowHandle, View.Columns[“AKTIF”]);if (okunma == “0”){e.Appearance.BackColor = Color.Red; private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e){//Hücre içinGridView View = sender as GridView;// if (e.Column.FieldName == “FIRM” || e.Column.FieldName == “PROJE”)if (e.Column.FieldName == “ENVANTER_DEGERI”){string category = View.GetRowCellDisplayText(e.RowHandle, View.Columns[“ENVANTER_DEGERI”]);if (category == “0” || category…
Devamı