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

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.abid2006 (AT) gmail (DOT) com> wrote

On Aug 10, 5:36 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
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

You can create your own UpdateCommand manually. Be sure to specify all
columns that were returned by the SelectCommand.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Omar Abid" <omar.abid2006 (AT) gmail (DOT) com> wrote

On Aug 13, 4:38 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
Hi,
Thanks for your reply. I'm new to SQL and just learning. Do you direct
links (that contain specific thing that i need)
If so post those links
Thanks for understanding
Omar Abid
www.omarabid.uni.cc

Omar Abid (omar.abid2006 (AT) gmail (DOT) com) writes:
If you are to work with ADO .Net, you need to learn to with MSDN Library,
either on disk or on the web.

The link for the .UpdateCommand property in MSDN Library is
ms-
help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref10/html/P_Syste
m_Data_SqlClient_SqlDataAdapter_UpdateCommand.htm

If you are new to ADO .Net in general and want a head start, I recommend
David Sceppa's "ADO .Net Core Reference".


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Aug 14, 2:29 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Hi Erland Sommarskog,
I see thanks very much for your interest
Omar Abid
www.omarabid.uni.cc