绑定数据：
1、绑定模式
2、代码模式
举例如下：
-
private void Form1_Load(object sender, EventArgs e)
-
{
-
// TODO: 这行代码将数据加载到表“companyDataSet.clerk”中。您可以根据需要移动或删除它。
-
//this.clerkTableAdapter.Fill(this.companyDataSet.clerk);
-
dataGridView1.DataSource=BindModeSource().Tables[0];
-
dataGridView2.DataSource = NonBindSource();
-
}
-
private DataSet BindModeSource()
-
{
-
string constr = @"server=(localdb)\Projects;integrated security=sspi;database=company";
-
SqlConnection sqlcon = new SqlConnection(constr);
-
DataSet dataSet = new DataSet();
-
try
-
{
-
sqlcon.Open();
-
string sql = "select name,gender from clerk";
-
SqlDataAdapter sqladp = new SqlDataAdapter(sql,sqlcon);
-
sqladp.Fill(dataSet,"clerk");
-
}
-
catch(Exception ex)
-
{
-
MessageBox.Show(ex.Message);
-
}
-
finally
-
{
-
sqlcon.Close();
-
}
-
return dataSet;
-
}
-
private DataTable NonBindSource()
-
{
-
DataTable table = new DataTable();
-
//添加表头
-
table.Columns.Add("name", Type.GetType("System.String"));
-
table.Columns.Add("gender", Type.GetType("System.String"));
-
string[,] strs = { {
"张三","男"},{
"李四","男"},{
"王五","男"},{
"张三","男"},{
"张三","男"}};
-
//添加行记录
-
for (int i = 0; i < strs.Length / 2; i++)
-
{
-
DataRow row = table.NewRow();
-
row[0] = strs[i, 0];
-
row[1] = strs[i, 1];
-
table.Rows.Add(row);
-
-
}
-
return table;
-
}
