Posted by Omar Abid on 08/12/07 10:34

On Aug 10, 5:36 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
> > but now i want to save the changes in the table (after making
> > modifications in the dgv)
> > i use : dta.update(dt)
> > but that don't work !!!!!!
>
> You need to set the SqlDataAdapter.UpdateCommand property. The UPDATE
> command (as well as INSERT and DELETE) can be auto-generated if primary key
> information can be derived from the SelectCommand and you use a
> SqlCommandBuilder. See the VS documentation for details and examples.
>
> Also, I suggest you consider using stored procedures for data access and
> modification. Procs are more secure and promote execution plan re-use.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Omar Abid" <omar.abid2...@gmail.com> wrote in message
>
> news:1186747639.036460.260430@m37g2000prh.googlegroups.com...
>
> > Hi,
> > I'm using the following code to open a data base and show it's content
> > in a Data Grid View
> > ----
> > Code
> > -----
> > Imports System.Data.SqlClient
>
> > Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
> > System.EventArgs) Handles MyBase.Load
>
> > Dim conn As New SqlConnection("Data
> > Source=./wideserver;Path="c:/cct.mdf";User
> > Id=username;Password=Password;")
> > Using (conn)
> > conn.Open()
> > Dim com As SqlCommand = conn.CreateCommand()
> > Using (com)
> > com.CommandType = CommandType.Text
>
> > com.CommandText = "Select * From users"
> > Dim da As New SqlDataAdapter(com)
> > Using (da)
> > Dim dt As New DataTable("usertable")
> > Using (dt)
> > da.Fill(dt)
> > Dim dgv As New DataGridView()
> > dgv.Dock = DockStyle.Fill
> > dgv.DataSource = dt
> > Me.Controls.Add(dgv)
> > End Using
> > End Using
> > End Using
> > End Using
> > End Sub
> > -----
> > end code
> > -----
>
> > The following code allow me to see the table data in a Data Grid View
> > but now i want to save the changes in the table (after making
> > modifications in the dgv)
> > i use : dta.update(dt)
> > but that don't work !!!!!!
> > Any Help and thanks a lot
> > Omar Abid
> >www.omarabid.uni.cc

Hi,
Thanks I know that i must use an Update command.
But i'm programming in compiling time, i can't use the VS data base
tool to generate update command
Omar Abid
www.omarabid.uni.cc

[Back to original message]