469,934 Members | 1,965 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Databinding editable GridView with SqlDataSource on button click

This seems like it should be simple to do but for some reason I have
been unable to make it work.

I would like to databind a SqlDataSource to a GridView during the
click event of a button. This sounds easy but the next requirement is
that the GridView is editable. So I have included the SelectCommand
and the UpdateCommand on the SqlDataSource to allow the GridView to be
editable. I have now been able to get the GridView to display data on
the button click using the following code. As you can see I've tried
three different ways of doing this and each causes a different
problem. Now I am stuck and could use some help.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class EditableGridView2 : System.Web.UI.Page
{
// 3. Displays data but the row edit button causes the data to
dissapear.
protected SqlDataSource dataSource = new SqlDataSource();

protected void Page_Load(object sender, EventArgs e)
{
this.gridView.RowEditing += new
GridViewEditEventHandler(gridView_RowEditing);
this.gridView.RowUpdating += new
GridViewUpdateEventHandler(gridView_RowUpdating);
this.gridView.RowUpdated += new
GridViewUpdatedEventHandler(gridView_RowUpdated);
this.getData.Click += new EventHandler(getData_Click);

// 3. Displays data but the row edit button causes the data to
dissapear.
dataSource.ID = "SqlDataSource1";
dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();
this.Controls.Add(dataSource);
this.gridView.DataSourceID = dataSource.ID;
}

void getData_Click(object sender, EventArgs e)
{
// 1. and 2.
//SqlDataSource dataSource = new SqlDataSource();
//dataSource.ID = "SqlDataSource1";
//dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();

dataSource.SelectCommand = "SELECT [appID], [status], [clientName]
FROM [Applications] WHERE ([status] = @status)";
dataSource.UpdateCommand = "UPDATE [MemberApplications] SET [status]
= @status, [clientName] = @clientName WHERE [appID] = @appID";
dataSource.SelectParameters.Add("status", "Pending");
dataSource.UpdateParameters.Add(new Parameter("status"));
dataSource.UpdateParameters.Add(new Parameter("clientName"));
dataSource.UpdateParameters.Add(new Parameter("appID"));

// 1. Displays data but clicking the row edit causes the exception
"The DataSourceID of 'gridView' must be the ID of a control of type
IDataSource. A control with ID 'SqlDataSource1' could not be found."
//this.Controls.Add(dataSource);
//this.gridView.DataSourceID = dataSource.ID;

// 2. Displays data but the row edit button does not work.
//this.gridView.DataSource = dataSource;
//this.gridView.DataBind();
}

void gridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.message.Text = e.AffectedRows.ToString();
}

void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//
}

void gridView_RowEditing(object sender, GridViewEditEventArgs e)
{
//
}
}
Dec 18 '07 #1
4 9524
On Dec 18, 11:13 am, "mohaa...@gmail.com" <mohaa...@gmail.comwrote:
This seems like it should be simple to do but for some reason I have
been unable to make it work.

I would like to databind a SqlDataSource to a GridView during the
click event of a button. This sounds easy but the next requirement is
that the GridView is editable. So I have included the SelectCommand
and the UpdateCommand on the SqlDataSource to allow the GridView to be
editable. I have now been able to get the GridView to display data on
the button click using the following code. As you can see I've tried
three different ways of doing this and each causes a different
problem. Now I am stuck and could use some help.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class EditableGridView2 : System.Web.UI.Page
{
// 3. Displays data but the row edit button causes the data to
dissapear.
protected SqlDataSource dataSource = new SqlDataSource();

protected void Page_Load(object sender, EventArgs e)
{
this.gridView.RowEditing += new
GridViewEditEventHandler(gridView_RowEditing);
this.gridView.RowUpdating += new
GridViewUpdateEventHandler(gridView_RowUpdating);
this.gridView.RowUpdated += new
GridViewUpdatedEventHandler(gridView_RowUpdated);
this.getData.Click += new EventHandler(getData_Click);

// 3. Displays data but the row edit button causes the data to
dissapear.
dataSource.ID = "SqlDataSource1";
dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();
this.Controls.Add(dataSource);
this.gridView.DataSourceID = dataSource.ID;
}

void getData_Click(object sender, EventArgs e)
{
// 1. and 2.
//SqlDataSource dataSource = new SqlDataSource();
//dataSource.ID = "SqlDataSource1";
//dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();

dataSource.SelectCommand = "SELECT [appID], [status], [clientName]
FROM [Applications] WHERE ([status] = @status)";
dataSource.UpdateCommand = "UPDATE [MemberApplications] SET [status]
= @status, [clientName] = @clientName WHERE [appID] = @appID";
dataSource.SelectParameters.Add("status", "Pending");
dataSource.UpdateParameters.Add(new Parameter("status"));
dataSource.UpdateParameters.Add(new Parameter("clientName"));
dataSource.UpdateParameters.Add(new Parameter("appID"));

// 1. Displays data but clicking the row edit causes the exception
"The DataSourceID of 'gridView' must be the ID of a control of type
IDataSource. A control with ID 'SqlDataSource1' could not be found."
//this.Controls.Add(dataSource);
//this.gridView.DataSourceID = dataSource.ID;

// 2. Displays data but the row edit button does not work.
//this.gridView.DataSource = dataSource;
//this.gridView.DataBind();
}

void gridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.message.Text = e.AffectedRows.ToString();
}

void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//
}

void gridView_RowEditing(object sender, GridViewEditEventArgs e)
{
//
}

}
Shouldn't the tablename be same in both select and update commands?

dataSource.SelectCommand = "SELECT [appID], [status], [clientName]
FROM
[Applications]
WHERE ([status] = @status)";
dataSource.UpdateCommand = "UPDATE
[MemberApplications]
SET [status]
= @status, [clientName] = @clientName WHERE [appID] = @appID";
Dec 18 '07 #2
Yes, the table name should be the same in both commands. Sorry about
the bad pasting job. The code really is the same in both places. So,
just assume that the table name is the same. The code still doesn't
work.

Thanks for the heads up.

On Dec 18, 2:22 pm, Latish Sehgal <latish.seh...@gmail.comwrote:
On Dec 18, 11:13 am, "mohaa...@gmail.com" <mohaa...@gmail.comwrote:


This seems like it should be simple to do but for some reason I have
been unable to make it work.
I would like to databind a SqlDataSource to a GridView during the
click event of a button. This sounds easy but the next requirement is
that the GridView is editable. So I have included the SelectCommand
and the UpdateCommand on the SqlDataSource to allow the GridView to be
editable. I have now been able to get the GridView to display data on
the button click using the following code. As you can see I've tried
three different ways of doing this and each causes a different
problem. Now I am stuck and could use some help.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class EditableGridView2 : System.Web.UI.Page
{
// 3. Displays data but the row edit button causes the data to
dissapear.
protected SqlDataSource dataSource = new SqlDataSource();
protected void Page_Load(object sender, EventArgs e)
{
this.gridView.RowEditing += new
GridViewEditEventHandler(gridView_RowEditing);
this.gridView.RowUpdating += new
GridViewUpdateEventHandler(gridView_RowUpdating);
this.gridView.RowUpdated += new
GridViewUpdatedEventHandler(gridView_RowUpdated);
this.getData.Click += new EventHandler(getData_Click);
// 3. Displays data but the row edit button causes the data to
dissapear.
dataSource.ID = "SqlDataSource1";
dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToStri-ng();
this.Controls.Add(dataSource);
this.gridView.DataSourceID = dataSource.ID;
}
void getData_Click(object sender, EventArgs e)
{
// 1. and 2.
//SqlDataSource dataSource = new SqlDataSource();
//dataSource.ID = "SqlDataSource1";
//dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToStri-ng();
dataSource.SelectCommand = "SELECT [appID], [status], [clientName]
FROM [Applications] WHERE ([status] = @status)";
dataSource.UpdateCommand = "UPDATE [MemberApplications] SET [status]
= @status, [clientName] = @clientName WHERE [appID] = @appID";
dataSource.SelectParameters.Add("status", "Pending");
dataSource.UpdateParameters.Add(new Parameter("status"));
dataSource.UpdateParameters.Add(new Parameter("clientName"));
dataSource.UpdateParameters.Add(new Parameter("appID"));
// 1. Displays data but clicking the row edit causes the exception
"The DataSourceID of 'gridView' must be the ID of a control of type
IDataSource. A control with ID 'SqlDataSource1' could not be found."
//this.Controls.Add(dataSource);
//this.gridView.DataSourceID = dataSource.ID;
// 2. Displays data but the row edit button does not work.
//this.gridView.DataSource = dataSource;
//this.gridView.DataBind();
}
void gridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.message.Text = e.AffectedRows.ToString();
}
void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//
}
void gridView_RowEditing(object sender, GridViewEditEventArgs e)
{
//
}
}

Shouldn't the tablename be same in both select and update commands?

dataSource.SelectCommand = "SELECT [appID], [status], [clientName]
FROM
[Applications]
WHERE ([status] = @status)";
dataSource.UpdateCommand = "UPDATE
[MemberApplications]
SET [status]
= @status, [clientName] = @clientName WHERE [appID] = @appID";- Hide quoted text -

- Show quoted text -
Dec 18 '07 #3
Ok. I am able to get the Edit thing to work, the issue here is that
when you click Edit, the page reloads and since you have defined your
select and update commands in the button handler (which does not
execute on page reload), the datasource has incomplete information for
the edit to work. Debug and watch the datasource to check this out.
Also, since you do not want to include this information in the page
load event, i have added this to the Row_Edit event. It looks
something like

void gridView_RowEditing(object sender, GridViewEditEventArgs
e)
{
//
dataSource.SelectCommand = "SELECT [CustomerID],
[CompanyName], [Phone] FROM [Customers]";
dataSource.UpdateCommand = "UPDATE [Customers] SET
[CompanyName] = @CompanyName, [Phone] = @Phone WHERE [CustomerID] =
@CustomerID";

dataSource.UpdateParameters.Add(new
Parameter("CompanyName"));
dataSource.UpdateParameters.Add(new Parameter("Phone"));
dataSource.UpdateParameters.Add(new
Parameter("CustomerID"));

gridView.DataSource = dataSource;

gridView.EditIndex = e.NewEditIndex;
gridView.DataBind();

}

I think you might need to define some implementation in your other
events also, but hopefully this should give you a start.

-Latish Sehgal
http://www.dotnetsurfers.com/
Dec 19 '07 #4
Hello Latish,

I'm back at it again. Trying to solve this problem and implement what
you have given me. What I have now is the following code which almost
works but doesn't. In the end this worked up to the point where the
update is being made. The code excutes as far as the
gridView_RowUpdating event but then the gridView_RowUpdated event is
never called. So the update is never done. Can you or anyone else who
wants to look at this and see what I might be able to change to make
this work.

<code>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class EditableGridView : System.Web.UI.Page
{
void gridView_RowEditing(object sender, GridViewEditEventArgs e)
{
// Re-create the SqlDataSource here for row edits.

// The SqlDataSource already exists so there isn't a reason to set
the following values again.
//this.dataSource.ID = "SqlDataSource1";
//this.dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();
//this.Controls.Add(this.dataSource);
this.gridView.DataSource = this.dataSource;

this.dataSource.SelectCommand = "SELECT [appID], [status],
[clientName] FROM [MemberApplications] WHERE ([status] = @status) AND
dssgDelete = 'no'";
this.dataSource.UpdateCommand = "UPDATE [MemberApplications] SET
[status] = @status, [clientName] = @clientName WHERE [appID] =
@appID";
// Adding this parameter here causes a "Parameter already added"
exception.
//this.dataSource.SelectParameters.Add("status", "Pending");
this.dataSource.UpdateParameters.Add(new Parameter("status"));
this.dataSource.UpdateParameters.Add(new Parameter("clientName"));
this.dataSource.UpdateParameters.Add(new Parameter("appID"));

this.gridView.EditIndex = e.NewEditIndex;
this.gridView.DataBind();
}

void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int rowIndex = e.RowIndex;
}

void gridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.message.Text = e.AffectedRows.ToString();
}

protected SqlDataSource dataSource = new SqlDataSource();

protected void Page_Load(object sender, EventArgs e)
{
this.gridView.RowEditing += new
GridViewEditEventHandler(gridView_RowEditing);
this.gridView.RowUpdating += new
GridViewUpdateEventHandler(gridView_RowUpdating);
this.gridView.RowUpdated += new
GridViewUpdatedEventHandler(gridView_RowUpdated);
this.getData.Click += new EventHandler(getData_Click);

this.dataSource.ID = "SqlDataSource1";
this.dataSource.ConnectionString =
ConfigurationManager.ConnectionStrings["MembershipConnectionString"].ToString();
this.Controls.Add(this.dataSource);
}

void getData_Click(object sender, EventArgs e)
{
this.dataSource.SelectCommand = "SELECT [appID], [status],
[clientName] FROM [MemberApplications] WHERE ([status] = @status) AND
dssgDelete = 'no'";
this.dataSource.UpdateCommand = "UPDATE [MemberApplications] SET
[status] = @status, [clientName] = @clientName WHERE [appID] =
@appID";
this.dataSource.SelectParameters.Add("status", "Pending");
this.dataSource.UpdateParameters.Add(new Parameter("status"));
this.dataSource.UpdateParameters.Add(new Parameter("clientName"));
this.dataSource.UpdateParameters.Add(new Parameter("appID"));

this.gridView.DataSource = this.dataSource;
this.gridView.DataBind();
}
}
</code>

Regards,

Aaron

On Dec 19 2007, 10:47 am, Latish Sehgal <latish.seh...@gmail.com>
wrote:
Ok. I am able to get the Edit thing to work, the issue here is that
when you click Edit, the page reloads and since you have defined your
select and update commands in the button handler (which does not
execute on page reload), the datasource has incomplete information for
the edit to work. Debug and watch the datasource to check this out.
Also, since you do not want to include this information in the page
load event, i have added this to the Row_Edit event. It looks
something like

void gridView_RowEditing(object sender, GridViewEditEventArgs
e)
{
//
dataSource.SelectCommand = "SELECT [CustomerID],
[CompanyName], [Phone] FROM [Customers]";
dataSource.UpdateCommand = "UPDATE [Customers] SET
[CompanyName] = @CompanyName, [Phone] = @Phone WHERE [CustomerID] =
@CustomerID";

dataSource.UpdateParameters.Add(new
Parameter("CompanyName"));
dataSource.UpdateParameters.Add(new Parameter("Phone"));
dataSource.UpdateParameters.Add(new
Parameter("CustomerID"));

gridView.DataSource = dataSource;

gridView.EditIndex = e.NewEditIndex;
gridView.DataBind();

}

I think you might need to define some implementation in your other
events also, but hopefully this should give you a start.

-Latish Sehgalhttp://www.dotnetsurfers.com/
On Dec 19 2007, 10:47*am, Latish Sehgal <latish.seh...@gmail.com>
wrote:
Ok. I am able to get the Edit thing to work, the issue here is that
when you click Edit, the page reloads and since you have defined your
select and update commands in the button handler (which does not
execute on page reload), the datasource has incomplete information for
the edit to work. Debug and watch the datasource to check this out.
*Also, since you do not want to include this information in the page
load event, i have added this to the Row_Edit event. It looks
something like

* * * * void gridView_RowEditing(object sender, GridViewEditEventArgs
e)
* * * * {
* * * * * * * * //
* * * * * * dataSource.SelectCommand = "SELECT [CustomerID],
[CompanyName], [Phone] FROM [Customers]";
* * * * * * dataSource.UpdateCommand = "UPDATE [Customers] SET
[CompanyName] = @CompanyName, [Phone] = @Phone WHERE [CustomerID] =
@CustomerID";

* * * * * * dataSource.UpdateParameters.Add(new
Parameter("CompanyName"));
* * * * * * dataSource.UpdateParameters.Add(new Parameter("Phone"));
* * * * * * dataSource.UpdateParameters.Add(new
Parameter("CustomerID"));

* * * * * * gridView.DataSource = dataSource;

* * * * * * gridView.EditIndex = e.NewEditIndex;
* * * * * * gridView.DataBind();

* * * * }

I think you might need to define some implementation in your other
events also, but hopefully this should give you a start.

-Latish Sehgalhttp://www.dotnetsurfers.com/
Jan 10 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by dba56 | last post: by
reply views Thread by Frank | last post: by
2 posts views Thread by Hrvoje Vrbanc | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.