SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 Insert a record in C# 2003
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

haibec
Yak Posting Veteran

54 Posts

Posted - 01/17/2008 :  12:32:26  Show Profile  Reply with Quote
Hi all!
I have a table customer: ID,Name,Age. Please help me scirpt (Full) insert a new record into my table

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 01/17/2008 :  12:38:20  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03.aspx


- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

SNK111
Starting Member

Bangladesh
1 Posts

Posted - 09/02/2010 :  01:07:45  Show Profile  Reply with Quote
To connect to SQL Server, you need to create a connection string such as below:

private SqlConnection connection;
private string connectionString =
@"Server=(local);Database=Embedding_SQL_Test;User ID=sa;Password=123";
connection = new SqlConnection( connectionString );

Next, you use the SqlConnection object created above to create a 'SqlCommand', as shown below:
SqlCommand cmd = new SqlCommand( "select * from Customer where CustomerID = @Cid", connection);

The SQL query shown here can be replaced by a SELECT, INSERT, UPDATE queries etc.

Next to execute the SQL queries in the database, you use the following methods:
ExecuteReader - to execute SELECT queries
ExecuteNonQuery - to execute INSERT, DELETE, UPDATE, and SET statements.

This is a very short description of how to connect to SQL Server database from C# and execute SQL queries in the database.
For details about the connection string, the methods and their parameters check the following link: ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html )
Here you will also find details about how to pass parameters to the SQL queries as well as calling stored procedures and much more.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000