一个DataTable错误请教
SqlConnection conn=new SqlConnection("Data Source=(local);Integrated Security=SSPI;database=MSPetShop");
conn.Open();
DataSet dt=new DataSet();
string ssql="select * from account";
SqlDataAdapter sad=new SqlDataAdapter(ssql,conn);
sad.Fill(dt);
DataTable d=new DataTable();
d=dt.Tables["Account"];
for(int i=0;i<=d.Rows.Count-1;i++)
{
Response.Write("名称"+d.Rows[i]["UserId"].ToString() +"<p>");
}
运行总出错,提示未能引用到实例,请各位指教,谢谢~!
问题点数:0、回复次数:2Top
1 楼timmy3310(Tim)回复于 2003-04-02 10:56:26 得分 0
sad.Fill(dt);
->
sad.Fill(dt,"Account");Top
2 楼zwp315(城市大嫖客)回复于 2003-04-02 11:58:06 得分 0
sad.Fill(dt,"table名字");
Top




