Question

求一个asp.net(C#)的简单学生信息管理系统，只需要有添加，删除，查询功能

Answer 1

public void SetBind()
{
DataTable dt = new DataTable();
dt = GetLgList();
GridView1.DataSource = dt;
GridView1.DataBind();
}
public DataTable GetLgList()
{
string strconn=System.Configuration.ConfigurationSettings.AppSettings["xs"];
SqlConnection sqlconn = new SqlConnection(strconn);
string sqlstr = "select * from user_table where 1=1";
sqlstr += "and user_name like '%"+usernameTXT.Text+"%'";
SqlDataAdapter sqlda=new SqlDataAdapter(sqlstr,sqlconn);
DataTable dt =new DataTable();
sqlda.Fill(dt);
return dt;
}
private void delete()
{
string strconn=System.Configuration.ConfigurationSettings.AppSettings["xs"];
SqlConnection sqlconn = new SqlConnection(strconn);
sqlconn.Open();
string strcmd = "delete from user_table where user_name='"+username+"'";
SqlCommand sqlcmd = new SqlCommand(strcmd,sqlconn);
sqlcmd.ExecuteNonQuery();
sqlconn.Close();
SetBind();
}

Answer 2

可以凭借Baiduhi提醒我
有时间能够处理你所遇到的工作
相近的要求也能够提醒我
求一个asp.net(C#)的简单学生信息管理**，只需要有添加...
ES:\\BDE6B4CCD4AA2B9600858A2477165130

Answer 3

你加个dateview就可以 系统自带增删该茶