Well, I spent about 45 minutes trying to find a simple example that shows
how to add records to a SQL database from C# code.

All I can find is databound stuff, or examples working with Access and who
knows what.

How hard can it be? I want to write some code that adds records to an
existing table. No controls will be involved (bound or otherwise).

Can anyone show me how, or point me in the right direction?

Thanks!

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

In short, to get you started...

// namespace
using System.Data.SqlClient;

// Database Connection
SqlConnection conn = new SqlConnection(
"Data Source=(local);Initial Catalog=Northwind;Integrated
Security=SSPI");

// Execute SQL Statement
SqlCommand cmd = new SqlCommand("select * from Customers", conn);

--------------------
taken from -
http://www.csharp-station.com/Tutori.../Lesson01.aspx

TAJ


"Jonathan Wood" <jwood (AT) softcircuits (DOT) com> wrote

Jonathan,

I know that they are hard to find a full configured DataAdapter for that
where you have used do one by one the deletes, the updates and the the
insert.

However if your insert/update/delete is a simple one, then you can use the
Commandbuilder.

http://www.vb-tips.com/SQLServerUpdate.aspx

There are more tips on our website using the commandbuilder and only few to
use full written updates. Those needs a lot of code and are therefore not so
well to use as tip.

Cor

Thanks, but that code doesn't add any records. Moreover, I couldn't see
where the list of articles at the link you provided does either.

?

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"TAJ" <thomasajenkins (AT) msn (DOT) com> wrote

I'll be adding hundreds of rows and I'm not sure the CommandBuilder would be
the most efficient. I'd really like to know how to add records to a database
from code.

I can't yet tell if the code at that link does what I need or not. I'll
check it out.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Cor Ligthert[MVP]" <notmyfirstname (AT) planet (DOT) nl> wrote

Replace the select with your sql insert command

http://www.w3schools.com/sql/sql_insert.asp



"Jonathan Wood" <jwood (AT) softcircuits (DOT) com> wrote

Yes, TDS is "tabular data stream". It's the low-level protocol I discuss in
Chapter 2. It's the only interface exposed by SQL Server to the outside
world. All of the data access interfaces like ADO, ADO.NET and the rest use
to communicate with the server. The BCP operators bypass much of the
overhead involved in adding rows.

Ah, did you try this:
http://www.google.com/search?hl=en&q=sqlbulkcopy

Here is a VB.NET example drawn from the book--I hope it will suffice:
It opens a delimited text file and imports the data to SQL Server using the
SqlBulkCopy class.

Imports System.Data.Sqlclient
Imports System.Data.odbc
Public Class Form1
Dim WithEvents bc As SqlBulkCopy
Dim dr As Odbc.OdbcDataReader
Dim cn As SqlConnection
Dim cn2 As OdbcConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Try
cn = New SqlConnection("data source=betav7;integrated
security=sspi;database=biblio")
cn.Open()
cn2 = New
OdbcConnection("DSN=TextFile;DATABASE=c:\MSFTStock .TXT;Extensions=asc,csv,tab,txt")
cn2.Open()
Dim cmd As New OdbcCommand("SELECT * FROM MSFTStock.TXT", cn2)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
bc = New SqlBulkCopy(cn)
With bc
.BatchSize = 10
.DestinationTableName = "StockData"
.NotifyAfter = 5
.WriteToServer(dr)
End With
Catch exIO As InvalidOperationException
Debug.Print(exIO.ToString)
Catch ex As Exception
MsgBox(ex.ToString)
Finally
Dim cmd2 As New SqlCommand("SELECT Count(*) FROM StockData", cn)
Dim strRows As String
strRows = cmd2.ExecuteScalar().ToString
lblRowsInTable.Text = strRows
cn.Close()
cn2.Close()
End Try

End Sub

Private Sub bc_SqlRowsCopied(ByVal sender As Object, ByVal e As
System.Data.SqlClient.SqlRowsCopiedEventArgs) Handles bc.SqlRowsCopied
lblRowsCopied.Text = e.RowsCopied.ToString
lblRowsCopied.Refresh()
End Sub

End Class


----- Original Message -----
From: "Jonathan Wood" <jwood (AT) softcircuits (DOT) com>
Newsgroups: microsoft.public.dotnet.framework.adonet
Sent: Monday, November 05, 2007 12:42 PM
Subject: Re: Importing Data


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jonathan Wood" <jwood (AT) softcircuits (DOT) com> wrote