帮忙给看看这段代码。删除的效果没有实现，应该怎么改啊？
private void btn(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
switch(((Button)e.CommandSource).CommandName)
{
case "shanchu":
int strid=Convert.ToInt32(e.Item.ItemIndex);
SqlConnection conn=new SqlConnection("server=localhost; database=wkm001; uid=sa; pwd=");
conn.Open();
SqlCommand com=new SqlCommand("delete_and_select", conn);
com.Parameters.Add(
new SqlParameter("@strid ", SqlDbType.Int)).Value=strid;
com.CommandType=CommandType.StoredProcedure;
SqlDataReader dr=com.ExecuteReader();
if(dr.Read())
{
DataGrid DG=new DataGrid();
this.DG.DataSource=dr;
this.DG.DataBind();
dr.Close();
com.Dispose();
conn.Close();
}
break;
存储过程：
CREATE PROCEDURE [dbo].[delete_and_select]
@strid int
AS
begin
delete from person where person.id=@strid
end
begin
select * from person
end
GO

SqlConnection conn=new SqlConnection("server=localhost; database=wkm001; uid=sa; pwd=");
SqlDataAdapter da=new SqlDataAdapter("delete from table where table.id='"+ strid+"'" , conn);
DataSet ds=new DataSet();
da.Fill(ds);
删除完不是应该重新填充dataset。然后绑定dataGrid 吗！关键是删除之后的代码该怎么写了！
救命啊！！！

解决了。
谢啦，楼上的！