在ASP.NET中使用ADO.NET删除行的一种常见方法是使用SQL语句来执行删除操作。以下是一个使用ADO.NET和ASP.NET的示例代码:
首先,确保已经在项目中添加了对System.Data.SqlClient和System.Configuration的引用。
在Web.config文件中添加数据库连接字符串:
using System;
using System.Data.SqlClient;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
protected void BindGridView()
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "SELECT * FROM YourTable";
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
GridView1.DataSource = reader;
GridView1.DataBind();
}
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowId = e.RowIndex;
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "DELETE FROM YourTable WHERE ID = @ID";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@ID", GridView1.DataKeys[rowId].Value);
connection.Open();
command.ExecuteNonQuery();
}
}
BindGridView(); // 删除后重新绑定GridView
}
在上面的示例中,首先在Page_Load事件中调用BindGridView方法来显示数据。然后,在GridView1_RowDeleting事件中获取要删除的行的索引,并使用SqlCommand执行DELETE语句来删除该行。最后,重新绑定GridView以显示更新后的数据。
请根据您的实际情况修改数据库连接字符串、查询和删除语句,以及GridView的ID和数据源。