lamont Posted June 20, 2015 Share Posted June 20, 2015 Datatable ile Sanal Tablolalrı Okutuyorum Ama Çok Geç Geliyor Bilgiler Lakin Properties datasource Baglayınca Daha Hızlı Sebebi Nedir Kodları Ekliyorum private void Urun_Duzenle_Sil_Load(object sender, EventArgs e) { SqlDataAdapter oku = new SqlDataAdapter("select * from urunler", connet.bag()); { DataTable dt = new DataTable(); oku.Fill(dt); dataGridView1.DataSource = dt; //dataGridView1 Kolonlarındaki dataGridView1.Columns[0].HeaderText = "KOD NO"; dataGridView1.Columns[1].HeaderText = "SERİ NO"; dataGridView1.Columns[2].HeaderText = "ADI"; dataGridView1.Columns[3].HeaderText = "CİNSİ"; dataGridView1.Columns[4].HeaderText = "MEVCUT"; dataGridView1.Columns[5].HeaderText = "SATIŞ FİYATI"; dataGridView1.Columns[6].HeaderText = "PARA BİRİMİ"; dataGridView1.Columns[7].HeaderText = "KDV"; dataGridView1.Columns[8].HeaderText = "KDV ORANI %"; dataGridView1.Columns[9].HeaderText = "MUTFAK"; } } Quote Link to comment Share on other sites More sharing options...
muratboy31 Posted June 29, 2015 Share Posted June 29, 2015 sql tarafında stored procedure kullan... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.