我真的是无语了,怎么回有错误呢?大虾帮帮忙!
系统说这里出了错:
myCommand.Fill(ds,"t_table");
到底是为什么呢?
string Table;
Table=Request.QueryString["Table"];
string SearchId,SearchTitle;
switch(Table)
{
case "t_links":
SearchId="link_id";
SearchTitle="link_title";
break;
case "t_info":
SearchId="info_id";
SearchTitle="info_title";
break;
}
//连接数据库
SqlConnection myConnection;
myConnection = new SqlConnection
("server=(local);database=graduate_student;user id=sa;password=sql");
SqlDataAdapter myCommand = new SqlDataAdapter
("select SearchId,SearchTitle from Table",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds,"t_table");
MyDataGrid.DataSource=ds.Tables["t_table"].DefaultView;
MyDataGrid.DataBind();