DataGridView绑定 [英] DataGridView Binding

查看:72
本文介绍了DataGridView绑定的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

请。帮我在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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆