我的获取数据库是这样的:
SqlDataAdapter comm = new SqlDataAdapter("select * from manage_student_info where 年度=@niandu order by 学号", conn);
comm.SelectCommand.Parameters.AddWithValue("@niandu", (string)Session["Xuenian"]);
conn.Open();
DataSet ds = new DataSet();
comm.Fill(ds);
conn.Close();
______
怎么加到下面去?:
public DataTable GetList(string strWhere)
{//需要using system.Text
StringBuilder strSql=new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM student");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
data sqldata=new data();
return sqldata.GetTable(strSql.ToString());//这块换成自己的数据库操作对象
}