protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)//页面第依次显示时，执行数据绑定
databind();
}
protected void databind()
{
SqlConnection sqlcon = new SqlConnection("Data Source=KEN;Initial Catalog=aspnettest;Persist Security Info=True;User ID=hyslove;Password=hyslove");
SqlCommand sqlcom = new SqlCommand("select * from UserTable", sqlcon);
sqlcon.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlcom);
DataSet ds = new DataSet();
da.Fill(ds, "UserTable");
GridView1.DataSource = ds.Tables["UserTable"].DefaultView;
GridView1.DataBind();
sqlcon.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
databind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
string username = GridView1.DataKeys[GridView1.EditIndex][0].ToString();
//这个是根据前面的Datekeynames设置而得到的。
//如果多个键值，那么用GridView1.DataKeys[GridView1.EditIndex].Value三[0];
string passwordnew = ((TextBox)(GridView1.Rows[GridView1.EditIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sql = "update UserTable set Password='"+passwordnew+
"' where Username='" + username + "'";
SqlConnection sqlcon = new SqlConnection("Data Source=KEN;Initial Catalog=aspnettest;Persist Security Info=True;User ID=hyslove;Password=hyslove");
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;//返回正常状态
databind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
databind();
}
|
