ASP.NET

10-Jan-10 21:46

Hi all,

I have a Gridview that I populate with values from textboxes. These populated values doesn't have any ID. I can edit and update records but I don't know how to delete records. Please advice on how I can achieve this.

P.S: These records are NOT being saved on the database, only on the Gridview.

I'll appreciate any help I can get.

Thanks.

Dinesh Mani10-Jan-10 22:14

10-Jan-10 22:14

What is the datastore that you use to populate the gridview. If you can share the logic that you use for edit then we can avoid reinventing the wheel.

Nopo10-Jan-10 22:36

10-Jan-10 22:36

I'm using dataTable as staorage and then I save it in a Session. Here is the code.

private void DataBindGrid()
{
try
{

string checkflag;

//Create DataTable.
DataTable dt = (DataTable)Session["dtInfoProfile"];

if (dt == null)
{
//Create DataTable.
dt = new DataTable();

//Assign Columns to it.
dt.Columns.Add(new DataColumn("Full Names"));
dt.Columns.Add(new DataColumn("Type"));
dt.Columns.Add(new DataColumn("Identifying Number"));
dt.Columns.Add(new DataColumn("Passport Number"));
}

//Create a DataRow by dt.NewRow().
DataRow dr = dt.NewRow();

if (rdbIndividual.Checked)
{
//Fill that row and add it to datatable.
checkflag = rdbIndividual.Text;
dr["Full Names"] = IndividualDetailsControl.FirstName + " " + IndividualDetailsControl.LastName;
dr["Type"] = checkflag;
dr["Identifying Number"] = IndividualDetailsControl.IdentityNo;
dr["Passport Number"] = IndividualDetailsControl.PassportNo;
dt.Rows.Add(dr);
}
else if (rdbTrust.Checked)
{
checkflag = rdbTrust.Text;
//Fill that row and add it to datatable.
dr["Full Names"] = EntityDetailsControl.Name;
dr["Type"] = checkflag;
dr["Identifying Number"] = EntityDetailsControl.RegistrationNo;
dt.Rows.Add(dr);
}
else
{
checkflag = rdbEntity.Text;
//Fill that row and add it to datatable.
dr["Full Names"] = EntityDetailsControl.Name;
dr["Type"] = checkflag;
dr["Identifying Number"] = EntityDetailsControl.RegistrationNo;
dt.Rows.Add(dr);

}

Session["dtInfoProfile"] = dt;

//Bind GridView Here with this Table
this.BindData();

//Rename the button
btnAdd.Text = "Add New";

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

private void BindData()
{
dgInfoProfile.DataSource = Session["dtInfoProfile"];
dgInfoProfile.DataBind();
}

For Edit and Update:

//Edit
protected void dgInfoProfile_RowEditing(object sender, GridViewEditEventArgs e)
{
//Set the edit index.
dgInfoProfile.EditIndex = e.NewEditIndex;
//Bind data to the GridView control.
this.BindData();
}

//Update
protected void dgInfoProfile_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Retrieve the table from the session object.
DataTable dt = (DataTable)Session["dtInfoProfile"];

//Update the values.
GridViewRow row = dgInfoProfile.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex]["Full Names"] = ((TextBox)(row.Cells[1].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Type"] = ((TextBox)(row.Cells[2].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Identifying Number"] = ((TextBox)(row.Cells[3].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Passport Number"] = ((TextBox)(row.Cells[4].Controls[0])).Text;

//Reset the edit index.
dgInfoProfile.EditIndex = -1;

//Bind data to the GridView control.
this.BindData();
}

Dinesh Mani10-Jan-10 22:50

10-Jan-10 22:50

I didn't have the time to experiment, but I think GridViewDeleteEventArgs e is available on the Row Delete event and you can use it to retrieve the row id.

If that is not possible, how about altering the code to add one more value as an identifier and setting the value as the command value for a command button and delete the row corresponding to the command value?

HTH!

Nopo10-Jan-10 22:59

10-Jan-10 22:59

yes, the GridViewDeleteEventArgs e is available but i don't understand where I can get the value of an index, or of an Id if I add another Id column?

Dinesh Mani10-Jan-10 23:05

10-Jan-10 23:05

I assume GridViewDeleteEventArgs e has a row index just like the Update event arg. So, you can use it to get the gridview row and use it to get the datatable row just like what you have done for edit.

I've just got these out of the original code that you posted and modified it slightly -

GridViewRow row = dgInfoProfile.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex].Remove();

Try on these lines and I'm sure you must be able to get it to work!

Nopo10-Jan-10 23:23

10-Jan-10 23:23

Thanks. There are two event for delete, one is RowDeleting and the other is RowDelete. I tried with RowDeleting. they both don't have Remove() method, thereforre i tried Delete().

GridViewRow row = dgSendFeedbackTo.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex].Delete();

I get the following error when debugging:
"There is no row at position 1."

Dinesh Mani10-Jan-10 23:32

10-Jan-10 23:32

I'm sorry Nopo, I don't have access to VS at this point it time so I cannot help you out on the error message.

But, going by the looks of it try reducing the value of DataItemIndex. May be it might work.

Nopo11-Jan-10 2:51

11-Jan-10 2:51

Hi Dinesh,

I've got it right. Wink | ;)

protected void dgSendFeedbackTo_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = (DataTable)Session["dtFeedback"];
dt.Rows[e.RowIndex].Delete();
this.BindData();
}

Thanks a lot for all your help.

Dinesh Mani11-Jan-10 18:35