回复 14楼jian.du的帖子
对于你提出的需求,可以使用DataSource绑定到sql数据库。
代码参考:
- SqlConnection dataBaseCon = new SqlConnection("Data Source=10.32.1.52\\sqlexpress;Initial Catalog=bbs;User ID=sa;Password=xA123456");
- //configure sqlstatement
- string sqlStr = "select * from [dbo].[Customer]";
- //instance SqlDataAdapter sql dataadapter
- SqlDataAdapter da = new SqlDataAdapter(sqlStr, dataBaseCon);
- //instance DataSet
- DataSet data = new DataSet();
- //fill data
- da.Fill(data, "Customer");
- this.Customers.DataKeyNames = new string[] { "ID" };
- C1.Web.Wijmo.Controls.C1GridView.C1BoundField field = new C1.Web.Wijmo.Controls.C1GridView.C1BoundField();
- field.DataField = "Name";
- field.HeaderText = "Name";
- field.SortExpression = "Name";
- this.Customers.Columns.Add(field);
- field = new C1.Web.Wijmo.Controls.C1GridView.C1BoundField();
- field.DataField = "Company";
- field.HeaderText = "Company";
- field.SortExpression = "Company";
- this.Customers.Columns.Add(field);
- //binding
- this.Customers.DataSource = data;
- this.Customers.DataBind();
复制代码 |