Gridview Control in ASP.NET 2.0 Not updating.

Discussion in 'ASP .Net' started by Guest, Oct 18, 2005.

  1. Guest

    Guest 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
     
    Guest, Oct 18, 2005
    #1
    1. Advertisements

  2. 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: <>
    | From: <>
    | 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: <>
    | 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
    |
    |
    |
     
    Steven Cheng[MSFT], Oct 19, 2005
    #2
    1. Advertisements

  3. Guest

    Guest 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.
     
    Guest, Oct 19, 2005
    #3
  4. 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: <>
    | From: <>
    | References: <>
    <>
    | 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: <>
    | 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: <>
    | > | From: <>
    | > | 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: <>
    | > | 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
    | > |
    | > |
    | > |
    | >
    |
    |
    |
     
    Steven Cheng[MSFT], Oct 19, 2005
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.