传奇三半兽人任务:.net代码,没语法错误,但无法显示数据,为什么?

来源:百度文库 编辑:神马品牌网 时间:2024/05/03 09:59:50
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Data.SqlClient.SqlConnection sqlConnection1;
protected System.Data.SqlClient.SqlCommand cmd;
protected System.Data.SqlClient.SqlDataAdapter sda;
protected System.Web.UI.WebControls.Label Label1;

private void Page_Load(object sender, System.EventArgs e)
{
sqlConnection1=new SqlConnection("server=.;database=northwind;uid=sa;pwd=sa;") ;

cmd=new SqlCommand("select * from Customers",sqlConnection1);
sda=new SqlDataAdapter(cmd,sqlConnection1);
sqlConnection1.Open();
DataSet ds = new DataSet();
sda.Fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();

sqlConnection1.Close();
// 在此处放置用户代码以初始化页面
}