742
ASP.NET實現GridView刪除功能
public partial class _Default : System.Web.UI.Page
{
SqlDataAdapter sda = null;
private void Bind()
{
string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";
SqlConnection conn = new SqlConnection(strConnectionString);
conn.Open();
string strSql = "select ID, Name as '留言者姓名', Content as '留言的信息', Time as '留言日期'" +
" from msgboard";
sda = new SqlDataAdapter(strSql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
conn.Close();
gvMsg.DataKeyNames = new System.String[] { "ID" };
gvMsg.DataSource = dt;
gvMsg.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Bind();
}
protected void sqlDS_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
}
protected void gvMsg_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strSql = "delete from msgboard where ID = " + gvMsg.DataKeys[e.RowIndex].Value.ToString();
string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";
SqlConnection conn = new SqlConnection(strConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.ExecuteNonQuery();
conn.Close();
Bind();
}
protected void gvMsg_RowCommand(object sender, GridViewCommandEventArgs e)
{
}
protected void btnOk_Click(object sender, EventArgs e)
{
string strSql = string.Format("insert into msgboard(Name, Content, Time) values('{0}', '{1}', {2})",
txtName.Text.Trim(), txtContent.Text.Trim(), DateTime.Now.ToShortDateString());
//Response.Write(strSql);
string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";
SqlConnection conn = new SqlConnection(strConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.ExecuteNonQuery();
Bind();
}
protected void gvMsg_RowEditing(object sender, GridViewEditEventArgs e)
{
gvMsg.EditIndex = e.NewEditIndex;
}
最後更新：2017-04-04 07:03:07