private void getUserInfo()
{
conn = new SqlConnection("Data Source=ASDF;Initial Catalog=123;Integrated Security=True");
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from user",conn);
ds = new DataSet();
try
{
conn.Open();
da.Fill(ds,"userinfo");
conn.Close();
}
catch (SqlException e1)
{
Response.Write(e1.ToString());
} }
提示是 da.Fill(ds,"userinfo");这行出错了,请帮忙解决
{
conn = new SqlConnection("Data Source=ASDF;Initial Catalog=123;Integrated Security=True");
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from user",conn);
ds = new DataSet();
try
{
conn.Open();
da.Fill(ds,"userinfo");
conn.Close();
}
catch (SqlException e1)
{
Response.Write(e1.ToString());
} }
提示是 da.Fill(ds,"userinfo");这行出错了,请帮忙解决
da = new SqlDataAdapter();
conn.Open();
da.SelectCommand = new SqlCommand("select * from user",conn);
去掉try有这样的提示:Incorrect syntax near the keyword 'user'.user 是表的名称,没错啊。
要用记录和架构(如果必要)填充的 DataSet。 srcTable
用于表映射的源表的名称。 =========================================== da.SelectCommand = new SqlCommand("select * from user",conn);
da.Fill(ds,"userinfo");
知道怎么回事的吗??