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