DataGridView绑定 [英] DataGridView Binding
问题描述
请。帮我在datagridview绑定列明智。我正在尝试这种方式,但事情并没有成功。
Pls. help me in datagridview binding column wise. I am trying this way but things are not working out.
Pls建议我,如果你有其他方法来获取记录并将其绑定到datagridview列。
Pls Suggest me if you have some other way of fetching records and binding it to the datagridview column wise.
da.SelectCommand =
da.SelectCommand =
new
SqlCommand ( " SELECT
ItmBsdOn,ScmBdySeq,ItmCod,MinSaleQty,FreeItm,AltItm, FreeQty,Disnt,BraDtls,CustDtls,Disbl FROM dbo.ScmVW ORDER BY ScmBdySeq" ,GCls.Connection);
new SqlCommand("SELECT ItmBsdOn,ScmBdySeq,ItmCod,MinSaleQty,FreeItm,AltItm,FreeQty,Disnt,BraDtls,CustDtls,Disbl FROM dbo.ScmVW ORDER BY ScmBdySeq", GCls.Connection);
ds.Clear();
ds.Clear();
da.Fill(ds);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables [0];
dataGridView1.DataSource=ds.Tables[0];
BindingSource tblNamesBs =
new
BindingSource ();
BindingSource tblNamesBs = new BindingSource();
tblNamesBs.DataSource = ds.Tables [0];
tblNamesBs.DataSource = ds.Tables[0];
optItmGrp .Checked =
optItmGrp.Checked =
true ;
true;
dataGridView1.AutoGenerateColumns =
dataGridView1.AutoGenerateColumns =
false ;
false;
dataGridView1.DataSource = ds.Tables [0] .DefaultView;
dataGridView1.DataSource = ds.Tables[0].DefaultView;
dataGridView1.Columns [0] .DataPropertyName =
dataGridView1.Columns[0].DataPropertyName =
" ScmBdySeq" ;
"ScmBdySeq";
dataGridView1.Columns [1] .DataPropertyName =
dataGridView1.Columns[1].DataPropertyName =
" ItmCod" ;
"ItmCod";
dataGridView1.Columns [2] .DataPropertyName =
dataGridView1.Columns[2].DataPropertyName =
" MinSaleQty" ;
"MinSaleQty";
dataGridView1.Columns [3] .DataPropertyName =
dataGridView1.Columns[3].DataPropertyName =
" FreeItm" ;
"FreeItm";
dataGridView1.Columns [4] .DataPropertyName =
dataGridView1.Columns[4].DataPropertyName =
" AltItm" ;
"AltItm";
dataGridView1.Columns [5] .DataPropertyName =
dataGridView1.Columns[5].DataPropertyName =
" FreeQty" ;
"FreeQty";
dataGridView1.Columns [6] .DataPropertyName =
dataGridView1.Columns[6].DataPropertyName =
" Disnt" ;
"Disnt";
dataGridView1.Columns [7] .DataPropertyName =
dataGridView1.Columns[7].DataPropertyName =
"" ;
"";
dataGridView1.Columns [8] .DataPropertyName =
dataGridView1.Columns[8].DataPropertyName =
"" ;
"";
dataGridView1.Columns [9] .DataPropertyName =
dataGridView1.Columns[9].DataPropertyName =
" BraDtls" ;
"BraDtls";
dataGridView1.Columns [10] .DataPropertyName =
dataGridView1.Columns[10].DataPropertyName =
" CustDtls" ;
"CustDtls";
dataGridView1.Columns [11] .DataPropertyName =
dataGridView1.Columns[11].DataPropertyName =
" Disbl" ;
提前致谢.......
Thanks in Advance.......
Yasser
推荐答案
你好,
感谢您的发布!我建议您将问题发布在其中一个位于
的" Windows窗体数据控件和数据绑定"中: ( http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads )。
Thank you for your post! I would suggest posting your question in one of the "Windows Forms Data Controls and Databinding" located here: (http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads).
祝你有美好的一天!
Ashawani
第2层应用程序支持
服务器和工具在线工程实时服务团队
这篇关于DataGridView绑定的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!