Question

ASP.NET查询的代码怎么写

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

protected void Page_Load(object sender, EventArgs e)
{
new1 db = new new1();
string type = Request["Type"];

string sqlstr = "select * from News where CategoryType=" + type; //sql查询语句
DataSet ds = db.re(sqlstr);
DataList1.DataSource = ds;
DataList1.DataBind();

Answer 2

//查询
public static DataTable ExeQuery(string sql, List<SqlParameter> plist, bool isProc)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(strCon))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
//判断是否执行存储过程
if (isProc)
{
cmd.CommandType = CommandType.StoredProcedure;
}
//判断SQL命令是否含有命令参数
if (plist != null)
{
cmd.Parameters.AddRange(plist.ToArray());
}
try
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
}
catch
{
return null;
}
return dt;
}
}
}