| Author: dineshbabu 28 Apr 2008 | Member Level: Silver Points : 2 |
Source:
SelectCommand="SELECT * FROM [exe1]" DeleteCommand="DELETE FROM [exe1] WHERE [id] = @original_id AND [Name] = @original_Name AND [Salary] = @original_Salary" ConflictDetection="CompareAllValues" InsertCommand="INSERT INTO [exe1] ([id], [Name], [Salary]) VALUES (@id, @Name, @Salary)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [exe1] SET [Name] = @Name, [Salary] = @Salary WHERE [id] = @original_id AND [Name] = @original_Name AND [Salary] = @original_Salary">
Codebhind:
protected void btnDelete_Click(object sender, EventArgs e)
{
foreach(GridViewRow row in GridView1.Rows )
{
CheckBox cb=(CheckBox)row.FindControl ("chkgv");
if(cb.Checked)
{
int id = Convert.ToInt32 (GridView1.DataKeys[row.RowIndex].Value);
SqlDataSource1.DeleteParameters["id"].DefaultValue = id.ToString();
SqlDataSource1.Delete();
}
}
}
|
| Author: sanmu 01 May 2008 | Member Level: Bronze Points : 2 |
protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)
{
string autoid = GridView1.DataKeys[e.RowIndex].Value.ToString();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ToString());
SqlCommand dCmd = new SqlCommand();
try
{
conn.Open();
dCmd.CommandText = "spDeleteData";
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.Add("@AutoID", SqlDbType.Int).Value = Int32.Parse(autoid);
dCmd.Connection = conn;
dCmd.ExecuteNonQuery();
lblMessage.Text = "Record Deleted successfully.";
// Refresh the data
BindData();
}
catch (SqlException ee)
{
lblMessage.Text = ee.Message;
}
finally
{
dCmd.Dispose();
conn.Close();
conn.Dispose();
}
}
|