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();
}
可以凭借Baiduhi提醒我
有时间能够处理你所遇到的工作
相近的要求也能够提醒我
求一个asp.net(C#)的简单学生信息管理**，只需要有添加...
ES:\\BDE6B4CCD4AA2B9600858A2477165130
你加个dateview就可以 系统自带增删该茶
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024