帮看一下哪出问题了

[sll8369]

public static DataTable databind(int newstype,string tablename)
{SqlConnection con=DB.createcon();
con.Open();
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=new SqlCommand("select * from tablename",con);
DataSet ds=new DataSet();
sda.Fill(ds,"tablename");
return ds.Tables["tablename"];
}


对象名 'tablename' 无效。
sda.Fill(ds,"tablename");

[noway8881]

public static DataTable databind(int newstype,string tablename)
{SqlConnection con=DB.createcon();
con.Open();
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=new SqlCommand("select * from " + tablename,con);
DataSet ds=new DataSet();
sda.Fill(ds,tablename);
return ds.Tables[tablename];
}

[sll8369]

改成上面的还有问题啊

第 1 行: 'fromliuyan' 附近有语法错误
System.Data.SqlClient.SqlException: 第 1 行: 'fromliuyan' 附近有语法错误。

源错误:

sda.Fill(ds,tablename);

[sll8369]

谢谢大侠 我弄明白了 你说得很对