同学让我帮他做一个《计算机组成原理》学习交流网站,这个是会员注册的代码,帮我看看行不行,有没有更加简洁的代码。
public partial class huiyuanzhuce_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql;
sql = "select * from huiyuanzhuce order by id desc";
getdata(sql);
}
}
private void getdata(string sql)
{
DataSet result = new DataSet();
result = new Class1().hsggetdata(sql);
if (result != null)
{
if (result.Tables[0].Rows.Count > 0)
{
DataGrid1.DataSource = result.Tables[0];
DataGrid1.DataBind();
Label1.Text = "以上数据中共" + result.Tables[0].Rows.Count;
}
else
{
DataGrid1.DataSource = null;
DataGrid1.DataBind();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql;
sql = "select * from huiyuanzhuce where 1=1";
if (bh.Text.ToString().Trim() != "")
{
sql = sql + " and yonghuming like '%" + bh.Text.ToString().Trim() + "%'";
}
if (mc.Text.ToString().Trim() != "")
{
sql = sql + " and xingming like '%" + mc.Text.ToString().Trim() + "%'";
}
sql = sql + " order by id desc";
getdata(sql);
}
}
|
|