private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string loginName = ((TextBox)e.Item.Cells[0].Controls[0]).Text;
string userName = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
string ConnStr="server=192.168.0.1;database=db1;uid=sa;pwd=ggg";
SqlConnection connUpdate = new SqlConnection(ConnStr);
connUpdate.Open();
String sql_edit = "UPDATE user1 SET loginName = '" + loginName+ "',userName = '" + userName + "' WHERE loginName = '" + userName + "'";
SqlCommand sqlCommandUpdate = new SqlCommand(sql_edit,connUpdate);
sqlCommandUpdate.ExecuteNonQuery();
connUpdate.Close();
BindGrid();
}
{
string loginName = ((TextBox)e.Item.Cells[0].Controls[0]).Text;
string userName = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
string ConnStr="server=192.168.0.1;database=db1;uid=sa;pwd=ggg";
SqlConnection connUpdate = new SqlConnection(ConnStr);
connUpdate.Open();
String sql_edit = "UPDATE user1 SET loginName = '" + loginName+ "',userName = '" + userName + "' WHERE loginName = '" + userName + "'";
SqlCommand sqlCommandUpdate = new SqlCommand(sql_edit,connUpdate);
sqlCommandUpdate.ExecuteNonQuery();
connUpdate.Close();
BindGrid();
}
{
chkUserName();
if (!IsPostBack) BindGrid();
} private void BindGrid()
{
ConnStr="server=192.168.0.1;database=db1;uid=sa;pwd=ggg";
SqlConnection connUpdate = new SqlConnection(ConnStr);
StrCon.Open();
string StrSql="select * from userinfo order by id desc";
SqlDataAdapter da=new SqlDataAdapter(StrSql,StrCon);
DataSet ds = new DataSet();
da.Fill(ds,"info");
DataGrid1.DataSource=ds.Tables["info"].DefaultView;
DataGrid1.DataBind();
}
string StrSql="select * from userinfo order by id desc";
应该为
string StrSql="select * from user1 order by id desc";
MSDN WebCast 讲座下载(Datagrid高级使用技巧)