Re: Datagrid on Webform - How to update? Help

abacnet_at_hotmail.com
Date: 07/25/03


Date: Thu, 24 Jul 2003 19:21:25 -0400


Nice rule from experience :
1-If you are used with stored procedures use them or learn to use them --
otherwise you will lose time by using the wizard to generate dataadapters (I
wish someone told me that before)
2-Put functionality to get data and bind grid in a procedure and call it
after update is cuccessful (also here if you want to save time use stored
procedure to save)
In the meantime you can check if the dataadapter's Update command is well
configured in design mode...

"Ash" <aliasgerj@hotmail.com> wrote in message
news:O$yCaHjUDHA.736@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I'm using Vb.NET webform, connecting to sql server database on the local
> machine. I used datagrid propery builder to add the edit, update and
cancel
> colum. On the code, i have:
>
> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Load
> SqlDataAdapter1.Fill(DataSet11)
> DataGrid1.DataBind()
> End Sub
>
> When i run the page, i can see the content on the browser, but when i
click
> on update, nothing happens.
> Any tips/ideas how i can do the update?
>
> Thanks,
> Ash
>
>



Relevant Pages

  • Re: Stored Procedure creation in vb.net
    ... 'use these stored procedures ... 'this creates table with single column: [RecNum] int NOT NULL ... Private Sub udp_CreateTable(ByVal DataBaseNameForNewTable As String, ...
    (microsoft.public.dotnet.languages.vb)
  • VSS Sql Server Integration using VS.NET 2003
    ... mouse click on the Stored Procedures node, ... to Add the Stored Procedures to Sourcesafe does not appear. ... I was connecting to, that I am connecting to a SQL Server database using an ...
    (microsoft.public.sqlserver.programming)
  • existing SQL database into adp
    ... All i'm doing is creating a new Access .adp and then connecting it to an ... existing SQL Server Database. ... tables and views but does not bring in all of the stored procedures. ...
    (microsoft.public.access.adp.sqlserver)
  • Raising SQL errors
    ... I am building an asp.net website which uses a SQL Server database. ... do data validation in the stored procedures and triggers, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Stored Procedure Slow Down Report Performance
    ... > It is also much more efficient for connecting different types of data ... > as mixing tables with stored procedures. ... Briscobar AT gmail DOT com ...
    (microsoft.public.vb.crystal)