DataBind() DataGrid.DataSourve = dataSet.Tablename;DataGrid.DataBind(); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public DataSet query_2(string t1, string t2){SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=jk;uid=sa");SqlCommand mySqlCommand = new SqlCommand("query1",mySqlConnection);mySqlCommand.CommandType = CommandType.StoredProcedure;SqlParameter t1_1 = new SqlParameter("@t1",SqlDbType.Char,7);t1_1.Value = t1;mySqlCommand.Parameters.Add(t1_1);SqlParameter t2_1 = new SqlParameter("@t2",SqlDbType.Char,4);t2_1.Value = t2;mySqlCommand.Parameters.Add(t2_1);return ds;System.Data.OleDb.OleDbDataAdapter da=new System.Data.OleDb.OleDbDataAdapter();da.SelectCommand=mySqlCommand;mySqlConnection.Open();da.Fill(ds,"deptname");mySqlConnection.Close();return ds;} SqlDataAdapter sda = new SqlDataAdapter(sqlCommand1);sda.Fill(dataSet,"表名"); mySqlConnection.Open();SqlDataAdapter sda = new SqlDataAdapter(sqlCommand1);sda.Fill(dataSet,"表名");DataGrid.DataSourve = dataSet.Tablename;DataGrid.DataBind();mySqlConnection.Close(); DataGrid1.DataSourve = dataSet.["Tablename"];DataGrid1.DataBind(); 你多表联查也有一个基表三!你就用那个基表的名称就可以了!你需要在DataSet里面对这张表进行预先设定,这样就可以直接绑定了! 如何通过Aspose.Words合并两个word文档?? How the method SqlDataReader.Read() work? 请问在DATASET的表中筛选数据应该怎么写? 谁有XML文档压缩和解压 代码的!!! 代码重用的问题 C#中怎样进行模糊查询 Form1和Form2转换问题??? 请问 孟子E章博客内容的延深,请求解答一下!!! 求一份资料,显示类似{0,c}的各参数及相应说明. c#中怎么将图片存放到SQL中!!!!!!!!!!!!!!!!!! 在datagrid中如何实现查找功能?
{SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=jk;uid=sa");
SqlCommand mySqlCommand = new SqlCommand("query1",mySqlConnection);
mySqlCommand.CommandType = CommandType.StoredProcedure;SqlParameter t1_1 = new SqlParameter("@t1",SqlDbType.Char,7);
t1_1.Value = t1;
mySqlCommand.Parameters.Add(t1_1);SqlParameter t2_1 = new SqlParameter("@t2",SqlDbType.Char,4);
t2_1.Value = t2;
mySqlCommand.Parameters.Add(t2_1);return ds;
System.Data.OleDb.OleDbDataAdapter da=new System.Data.OleDb.OleDbDataAdapter();
da.SelectCommand=mySqlCommand;mySqlConnection.Open();
da.Fill(ds,"deptname");
mySqlConnection.Close();return ds;
}
sda.Fill(dataSet,"表名");
SqlDataAdapter sda = new SqlDataAdapter(sqlCommand1);
sda.Fill(dataSet,"表名");
DataGrid.DataSourve = dataSet.Tablename;
DataGrid.DataBind();
mySqlConnection.Close();
DataGrid1.DataBind();