Gridview Control in ASP.NET 2.0 Not updating.

G

Guest

Hello,

I have created an ASP.NET 2.0 application that utilized a Gridview Control
to display and update/delete data.

The problem I am having is that the gridview control is displaying the data
correctly but it is not updating or deleting the rows. What I did was, in
design view, added a gridview control and added an sqldatasource control. I
configured the data source to update and delete. In the gridview tasks I
selected enable edit checkbox so that it automatically adds the edit link to
each row. When the link is selected it goes into edit mode and when the row
is edited I click the update link and nothing updates. This happens when I
try to delete the row as well.

Is there some settings that I need to add to the SQL database?

Incidently I have tried this a few other times with the gridview and other
data from the same database and it doesn't work as well.

Any ideas?

Thanks in advance,

washoetech
 
S

Steven Cheng[MSFT]

Hi Washoetech,

Welcome to ASPNET newsgroup.
Regarding on the GridView Edit/Deleting problem you mentioned, I think it
may be caused by something with the DataSource's configuration. What's the
2.0 version you're using currently, beta2 or RC?

If convenient, would you please paste your GridView, DataSource control's
declaration template in the aspx page here so that we can have a look at
them? Also, I'd suggest you testing through a simple table, (eg. the
Categories table in NorthWind database)

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


--------------------
| Reply-To: <[email protected]>
| From: <[email protected]>
| Subject: Gridview Control in ASP.NET 2.0 Not updating.
| Date: Tue, 18 Oct 2005 03:13:26 -0700
| Lines: 26
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: ip-206.159.118.137.hdiss.net 206.159.118.137
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:132045
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Hello,
|
| I have created an ASP.NET 2.0 application that utilized a Gridview
Control
| to display and update/delete data.
|
| The problem I am having is that the gridview control is displaying the
data
| correctly but it is not updating or deleting the rows. What I did was,
in
| design view, added a gridview control and added an sqldatasource control.
I
| configured the data source to update and delete. In the gridview tasks I
| selected enable edit checkbox so that it automatically adds the edit link
to
| each row. When the link is selected it goes into edit mode and when the
row
| is edited I click the update link and nothing updates. This happens when
I
| try to delete the row as well.
|
| Is there some settings that I need to add to the SQL database?
|
| Incidently I have tried this a few other times with the gridview and
other
| data from the same database and it doesn't work as well.
|
| Any ideas?
|
| Thanks in advance,
|
| washoetech
|
|
|
 
G

Guest

Steven,

I just figured it out. When the data source automatically sets up it writes
the SQL script strange and puts brackets around everything. I fixed it so
that there are no brackets. Also, the html that is automatically generated
by the gridview control was missing the paremeters required to update or
delete.

Thanks for your reply,

Washoetech.
 
S

Steven Cheng[MSFT]

Thanks for your prompt response.

Glad that you've figured it out. If there are anything we can help in the
furture, please feel free to post here.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| Reply-To: <[email protected]>
| From: <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: Re: Gridview Control in ASP.NET 2.0 Not updating.
| Date: Tue, 18 Oct 2005 21:46:14 -0700
| Lines: 98
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: ip-206.159.118.137.hdiss.net 206.159.118.137
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:132325
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven,
|
| I just figured it out. When the data source automatically sets up it
writes
| the SQL script strange and puts brackets around everything. I fixed it
so
| that there are no brackets. Also, the html that is automatically
generated
| by the gridview control was missing the paremeters required to update or
| delete.
|
| Thanks for your reply,
|
| Washoetech.
|
| | > Hi Washoetech,
| >
| > Welcome to ASPNET newsgroup.
| > Regarding on the GridView Edit/Deleting problem you mentioned, I think
it
| > may be caused by something with the DataSource's configuration. What's
| > the
| > 2.0 version you're using currently, beta2 or RC?
| >
| > If convenient, would you please paste your GridView, DataSource
control's
| > declaration template in the aspx page here so that we can have a look at
| > them? Also, I'd suggest you testing through a simple table, (eg. the
| > Categories table in NorthWind database)
| >
| > Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| > --------------------
| > | Reply-To: <[email protected]>
| > | From: <[email protected]>
| > | Subject: Gridview Control in ASP.NET 2.0 Not updating.
| > | Date: Tue, 18 Oct 2005 03:13:26 -0700
| > | Lines: 26
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | NNTP-Posting-Host: ip-206.159.118.137.hdiss.net 206.159.118.137
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.dotnet.framework.aspnet:132045
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > |
| > | Hello,
| > |
| > | I have created an ASP.NET 2.0 application that utilized a Gridview
| > Control
| > | to display and update/delete data.
| > |
| > | The problem I am having is that the gridview control is displaying the
| > data
| > | correctly but it is not updating or deleting the rows. What I did
was,
| > in
| > | design view, added a gridview control and added an sqldatasource
| > control.
| > I
| > | configured the data source to update and delete. In the gridview
tasks
| > I
| > | selected enable edit checkbox so that it automatically adds the edit
| > link
| > to
| > | each row. When the link is selected it goes into edit mode and when
the
| > row
| > | is edited I click the update link and nothing updates. This happens
| > when
| > I
| > | try to delete the row as well.
| > |
| > | Is there some settings that I need to add to the SQL database?
| > |
| > | Incidently I have tried this a few other times with the gridview and
| > other
| > | data from the same database and it doesn't work as well.
| > |
| > | Any ideas?
| > |
| > | Thanks in advance,
| > |
| > | washoetech
| > |
| > |
| > |
| >
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,226
Members
46,815
Latest member
treekmostly22

Latest Threads

Top