Question

c#中sda.Fill(ds)中提示错误对象名 'z_GoodsInfo' 无效

int id = int.Parse(this.TextBox1.Text);
string sql = string.Format("select * from z_GoodsInfo where Goods_ID ={0}", id);
using (SqlConnection conn = new SqlConnection(dbhelper.connetString))
{
conn.Open();

SqlCommand selectcommand = new SqlCommand(sql, conn);
SqlDataAdapter sda = new SqlDataAdapter(selectcommand);
DataSet ds = new DataSet();
sda.Fill(ds);//这里提示 错误对象名 'z_GoodsInfo' 无效
GridView1.DataSource = ds;
GridView1.DataBind();

Answer 1

z_GoodsInfo 这是你的表名 是不是拼写错误 把你的sql语句 select * from z_GoodsInfo where Goods_ID = XXX
放查询分析器里看看 是不是出错了