472,337 Members | 1,215 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,337 software developers and data experts.

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 9649
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: P | last post by:
Hello, I am having a difficult time updating a record via a stored procedure using the gridview and sqldatasource. I cannot seem to be able to...
8
by: Mike Kelly | last post by:
I've chosen to implement the "optimistic concurrency" model in my application. To assist in that, I've added a ROWVERSION (TIMESTAMP) column to my...
2
by: dba56 | last post by:
In an ASP.Net 2.0 page using SQL Server 2K, I have a editable gridview that is bound to a SQLDataSource using stored procedures for its select and...
0
by: Frank | last post by:
Hello All, I am working with VS.NET 2005 and I have an editable GridView whose HTML markup is shown below. In short, when the user clicks on...
0
by: Frank | last post by:
Hello All, I am working with VS.NET 2005 and I have an editable GridView whose HTML markup is shown below. In short, when the user clicks on...
2
by: beish1 | last post by:
Hi I have a page which displays a Gridview containing on each row a checkbox and 3 fields/cells (title, longitude, latitude). On the same page I...
2
by: Hrvoje Vrbanc | last post by:
Hello all! As I have only recently started to use native ASP.NET 2.0 data access controls (and found them to be very powerful), I have one...
6
by: dipalichavan82 | last post by:
i want editable gridview in C# vs2005.i want a column get added to gridview with edit button. once i click on edit button at runtime,all cells shud...
0
by: ADN | last post by:
Hi, I am currently extending the GridView control and would like to add a button to the GridView so that it will automatically render one button...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.