我使用dataset系結的sql server的表，想添加編輯，洗掉等按鈕，發現所有的方法都得自己寫，那這幾個功能該怎么實作呢？
這是前臺
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowEditing="GridView1_RowEditing" OnRowDeleting="GridView1_RowDeleting" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:BoundField DataField="sid" HeaderText="學號" ReadOnly="true" />
<asp:BoundField DataField="password" HeaderText="密碼" />
<asp:BoundField DataField="name" HeaderText="姓名" />
<asp:BoundField DataField="cid" HeaderText="班級號" />
<asp:CommandField ButtonType="Button" ShowEditButton="true" ShowHeader="true" HeaderText="編輯" />
<asp:CommandField ButtonType="Button" HeaderText="洗掉" ShowDeleteButton="true" ShowHeader="true" />
</Columns>
</asp:GridView>
這是后臺已完成
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
SqlConnection myconn = new SqlConnection("Data Source=LAPTOP-I5R4GJL7;Integrated Security=true;Initial Catalog=test");
myconn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = myconn;
DataSet myds = new DataSet();
SqlDataAdapter myda = new SqlDataAdapter("select * from student", myconn);
myda.Fill(myds, "student");
GridView1.DataSource = myds.Tables["student"];
GridView1.DataKeyNames = new string[] { "sid" };
GridView1.DataBind();
myconn.Close();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string mno = GridView1.DataKeys[e.RowIndex].Value.ToString();
SqlConnection myconn = new SqlConnection("Data Source=LAPTOP-I5R4GJL7;Integrated Security=true;Initial Catalog=test");
myconn.Open();
SqlCommand comm = new SqlCommand("delete from student where sid='" + mno + "'", myconn);
comm.ExecuteNonQuery();
myconn.Close();
Response.Redirect("stuManagement.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myconn = new SqlConnection("Data Source=LAPTOP-I5R4GJL7;Integrated Security=true;Initial Catalog=test");
myconn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = myconn;
DataSet myds = new DataSet();
SqlDataAdapter myda = new SqlDataAdapter("select * from student where sid='"+TextBox1.Text+ "' or name='" + TextBox1.Text + "'" , myconn);
myda.Fill(myds, "student");
GridView1.DataSource = myds.Tables["student"];
GridView1.DataKeyNames = new string[] { "sid" };
GridView1.DataBind();
myconn.Close();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Response.Redirect("stuManagement.aspx");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
}
uj5u.com熱心網友回復：
https://www.cnblogs.com/a121984376/archive/2008/07/18/1245906.htmluj5u.com熱心網友回復：
可以用sqldatasource系結，設定增加、洗掉、修改的陳述句及引數即可
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/44603.html
標籤：ASP.NET
下一篇：VS2019打包