I have a webpart where a gridview is defined programmatically. Editing etc. works, but when I try to delete a row in the gridview, the row is never deleted. It enters the RowDeleting event, but not the RowDeleted event.

I need some help here, and hope some of you guys can give me a helping hand. :-)

Code:

public class DocumentReport : WebPart
{
GridView gvDocuments;
SqlDataSource gvDataSource;
string _guid;

public DocumentReport()
{
gvDataSource = new SqlDataSource();
gvDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["DBServer"].ConnectionString;
gvDataSource.ProviderName = ConfigurationManager.ConnectionStrings["DBServer"].ProviderName;
gvDataSource.SelectCommand = DatabaseQueries.DocumentReports_Select;
gvDataSource.DeleteCommand = DatabaseQueries.DocumentReports_Delete;

this.AllowClose = false;
this.AllowEdit = false;
this.AllowHide = false;
this.AllowMinimize = false;
this.Title = Resources.AirOnline.DocumentReport_Title;
}

protected override void CreateChildControls()
{
gvDocuments = new GridView();
gvDocuments.DataKeyNames = new string[] { "AODR_GUID" };
gvDocuments.AutoGenerateColumns = false;
gvDocuments.AutoGenerateSelectButton = false;
gvDocuments.AutoGenerateDeleteButton = true;
gvDocuments.AutoGenerateEditButton = false;
gvDocuments.RowCommand += new GridViewCommandEventHandler(gvDocuments_RowCommand);
gvDocuments.RowDeleting += new GridViewDeleteEventHandler(gvDocuments_RowDeleting);
gvDocuments.RowDeleted += new GridViewDeletedEventHandler(gvDocuments_RowDeleted);

BoundField bfTitle = new BoundField();
bfTitle.DataField = "AODR_Title";

ButtonField btnEdit = new ButtonField();
btnEdit.Text = "Edit";
btnEdit.CommandName = "EditRow";

gvDocuments.Columns.Add(bfTitle);
gvDocuments.Columns.Add(btnEdit);

this.Controls.Add(gvDocuments);
gvDocuments.DataSource = gvDataSource;
gvDocuments.DataBind();
}

void gvDocuments_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
string sdf = "";
}

void gvDocuments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DBHandler dbManager = (DBHandler)this.Page.Application["DBManager"];
DataSet dsReport = null;
// Delete the file connected to the row being deleted
dsReport = dbManager.ExecuteDataSet(null, DatabaseQueries.DocumentReports_SelectChosenReport, new OracleParameter(":AODR_GUID", gvDocuments.DataKeys[e.RowIndex]["AODR_GUID"].ToString()));

try
{
if (dsReport != null)
{
string filepath = @Page.Server.MapPath("~") + ConfigurationManager.AppSettings["fileUploadReports"] + dsReport.Tables[0].Rows[0]["AODR_FILENAME"].ToString();
File.Delete(filepath);
}
}
catch (Exception ex)
{ }
}

void gvDocuments_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
gvDocuments.SelectedIndex = Convert.ToInt32(e.CommandArgument);
this.WebPartManager.DisplayMode = WebPartManager.EditDisplayMode;
this.WebPartManager.BeginWebPartEditing(this);
}
}

public override EditorPartCollection CreateEditorParts()
{
DocumentReportEditorPart edit = new DocumentReportEditorPart();
edit.ID = "DocumentEditor";

DocumentTypeEditorPart doctype = new DocumentTypeEditorPart();
doctype.ID = "DocumentTypeEditor";

DocumentStatusEditorPart docStatus = new DocumentStatusEditorPart();
docStatus.ID = "DocumentStatusEditor";

ArrayList editorArray = new ArrayList();
editorArray.Add(edit);
editorArray.Add(doctype);
editorArray.Add(docStatus);
EditorPartCollection editorParts = new EditorPartCollection(editorArray);
return editorParts;
}

public override WebPartVerbCollection Verbs
{
get
{
WebPartVerb NewVerb = new WebPartVerb("New", new WebPartEventHandler( this.AddNewDocument));
NewVerb.Text = Resources.AirOnline.DocumentReport_MenuAddNew;
NewVerb.Description = Resources.AirOnline.DocumentReport_MenuAddNew;

WebPartVerb[] verbs = new WebPartVerb[] { NewVerb };
return new WebPartVerbCollection(verbs);
}
}

public void AddNewDocument(object sender, WebPartEventArgs e)
{
gvDocuments.SelectedIndex = -1;
this.WebPartManager.DisplayMode = WebPartManager.EditDisplayMode;
this.WebPartManager.BeginWebPartEditing(this);
}

public GridView DataContainer
{
get { return gvDocuments; }
}

[Personalizable()]
public string guid
{
get { return _guid; }
set { _guid = value; }
}
}

---

Girl Power ! ;-P

Hi again Haridasi-

The reason your GridView never gets to the RowDeleted event is because you are binding the SqlDataSource control to the GridView via the GridView's DataSource property instead of its DataSourceID property.  Even though the SqlDataSource is a data source control, when you bind it to the GridView via the DataSource property, the GridView can't take advantage of automatic data updates, deletes, inserts, or sorting.

To take advantage of the SqlDataSource's capabilities and have the GridView automatically update, delete, sort, etc., you need to add the SqlDataSource to the page and use the GridView's DataSourceID property to bind to it. 

If you prefer to bind through the DataSource property, you will have to call Delete on the SqlDataSource or its view directly in your handler for RowDeleting.

---

Polita Paulus


This posting is provided "AS IS" with no warranties, and confers no rights.

Hey phuff,

It's so great there's a female .net expert on the team :-)

Thanks for the tip, I was hoping I could get away with not doing it "manually", but a girl's gotta do what a girl's gotta do. :-)

---

Girl Power ! ;-P