SQL

Question

HOW TO CONNECT SQL SERVER TO C#...Pls give me in points

Rahul Prajapat · Answer

Hello @viswa First you need to use namespace System.Data.SqlClient for sqlconnection and System.Data for data table or data set. Then create your connection. Try this code ; using System.Data; using System.Data.SqlClient; SqlConnection con = new SqlConnection ("data source= Your data source Name ;initial catalog= DataBase Name ;integrated security=true;");

Munesh Sharma · Answer

SqlConnection con = new SqlConnection("server = MUNESH\SQL2008R2;Database=datastore;UID=sa;Password=123;"); fatch value like SqlCommand cmd = new SqlCommand("Select * from login where username = '" + this.textBox1.Text + "' and password = '" + this.textBox2.Text + "'", con);

Vaikesh K P · Answer

Hi, Check this article : http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Karthikeyan K · Answer

Hi sir, Try this one sir It may be useful 1. http://www.homeandlearn.co.uk/csharp/csharp_s12p5.html 2. http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Arjunan Selvam · Answer

In order to connect sql server with c#,you have to use a framework like Ado.net or Entity Framework. Please visit following links. Ado.Net Tutorial: 1. http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET 2. http://www.csharp-station.com/Tutorial/AdoDotNet Entity Framework 1. http://www.codeproject.com/Articles/739164/Entity-Framework-Tutorial-for-Beginners

Upendra Pratap Shahi · Answer

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm http://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program http://www.c-sharpcorner.com/UploadFile/77a82c/bind-data-in-listview-controls-using-database-in-Asp-Net/

Raja T · Answer

Hi viswa, check out bellow points 1. Declare bellow namespaces using System.Data; using System.Data.SqlClient; 2. Declare Connection String like SqlConnection con = new SqlConnection ("sever=localhost;user id=sa; pwd=abc; database=test"); 3. If you want check connection string correct or not checkout like try { SqlConnection con = new SqlConnection ("sever=localhost;user id=sa; pwd=abc; database=test"); con.Open(); //here if connection is correct fetch data from db Response.Write(" Connection was Success "); con.Close(); } catch { //error } This are points connect the sqlserver steps.

Rajeesh Menoth · Answer

Hi, Ref this articles : http://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

SQL

Answers (8)