sqlStr = "select * from A where b=@c";
SqlDataAdapter adapter = new SqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "aNewTable");DataGrid1.DataView = ds.Tables["aNewTable"];
DataGrid1.DataBind();
SqlDataAdapter adapter = new SqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "aNewTable");DataGrid1.DataView = ds.Tables["aNewTable"];
DataGrid1.DataBind();
----DataGrid1.DataView = ds.Tables["aNewTable"];
为什么不用DataGrid1.DataSource=ds.Tables["aNewTable"];
呢?这两种用法有什么不同吗?
sqlSelectCommand1.CommandText="select * from A where b=@c";
sqlDataAdapter1.Fill(dataSet11,"A");
DataGrid1.DataSource=dataSet11.Tables["A"];
DataGrid1.DataBind();
if textbox1.text<> "" then
dt = New Data.DataSet()
sql = "select * from A where b=@c"
ca = New SqlClient.SqlDataAdapter(sql, cn)
ca.SelectCommand.Parameters.Add(New SqlClient.SqlParameter("@c", SqlDbType.Int)).Value = TextBox1.Text
ca.Fill(dt, "A")
DataGrid1.DataSource = dt.Tables("A").DefaultView
DataGrid1.DataBind()
else
.....
end if