Open();

cmd.ExecuteNonQuery();

cmd.Connection.Close();



this.TextBox1.Text="";

this.TextBox2.Text="";

this.TextBox3.Text="";

this.TextBox4.Text="";

this.TextBox5.Text="";



this.BindGrid();

}



private void BindGrid()

{

SqlConnection con=new SqlConnection("server=accp-lzh;uid=sa;pwd=sasa;database=pubs");

SqlDataAdapter mysqlcom=new SqlDataAdapter("select * from publishers where pub_id like '99%'",con);

DataSet myds=new DataSet();

mysqlcom.Fill(myds,"publishers");

this.DataGrid1.DataSource=myds.Tables["publishers"].DefaultView ;

this.DataGrid1.DataBind();

}



/// <summary>

/// 点击编辑时触发事件

/// </summary>

/// <param name="source"></param>

/// <param name="e"></param>

private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

this.DataGrid1.EditItemIndex=(int)e.Item.ItemIndex;

this.BindGrid();

}



/// <summary>

/// 点击取消时触发该事件。

/// </summary>

/// <param name="source"></param>

/// <param name="e"></param>

private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

this.DataGrid1.Columns[0].HeaderText="已取消";

this.DataGrid1.EditItemIndex=-1;

this.BindGrid();

}



private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)

{



}



/// <summary>

/// 点击更新时触发该事件。

/// </summary>

/// <param name="source"></param>

/// <param name="e"></param>

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

SqlConnection con=new SqlConnection("server=accp-lzh;uid=sa;pwd=sasa;database=pubs");

SqlCommand selectCmd=con.CreateCommand();

selectCmd.CommandType=CommandType.Text;

selectCmd.CommandText="select * from publishers where pub_id like '99%'";

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页

在google里搜索更多(ASP.NET)修改和删除DataGrid行——数据库访问

	Web www.51ec.org

上一篇信息学院： .Net的Outofmemory异常及大内存使用

下一篇信息学院： ASP.NET中使用Server.Transfer()方法在页间传值