Suggest good links for working with insert delete update create in SQL Server using C#

I cannot remember the site, but I showed parameter add etc where we could add the name of parameters instead of forming the whole query as a single statement

Please suggest some good links having coding info for working with SQL Server tables using C# website, following needed most

• create table
• insert data
• delete data
• declare primary key
• declare for开发者_开发技巧eign key

Try these:

• The C# station ADO.NET Tutorial
• Using ADO.NET for beginners

David Hayden has a great long list on various free tutorials - amongst them a long list of ADO.NET tutorials, too. C# Corner also sports such a long list of articles, blog posts, and tutorials on ADO.NET.

Microsoft's Data Access Application Block is useful:

http://msdn.microsoft.com/en-us/library/ff649538.aspx

However, I can't think of an example of a time that I would want to create tables or keys from a website. Just a thought.

http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx

Go through this link.You will get idea how to access the storep.

You can also go to www.w3schools.com.

Here you will find everything you need. Well I suggest you to use the stored procedures instead of SQL queries, because of SQL injection. Moreover stored procedures are fast to execute.