Loading

Got some error

Tan Kai Kai

13y1.4k.NET

LinkButton lnkRemove = (LinkButton)sender;

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "delete from Catwhere " +

"ID=@ID;" +

"select * from Cat";

cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value

= lnkRemove.CommandArgument;

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

I can can delete any thing buy no error come out, I want to delete item from gridview that the user click

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
After delete call the gridview bind method . so it will not show the deleted item in grid.
0
Iftikar Hussain13y ago
Hi,
try like this

SqlConnection conn = new SqlConnection(constring);
LinkButton lnkRemove = (LinkButton)sender;
SqlCommand cmd = new SqlCommand("delete from Cat where ID=@ID",conn);
cmd.Parameters.AddWithValue("@ID", lnkRemove.CommandArgument);
conn.Open();
cmd.ExecuteNonQuery();
cmd = new SqlCommand("select * from Cat",conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
GridView1.DataSource = ds.Tables[0];
da.Fill(ds);
GridView1.DataBind();

Regards,
Iftikar
0