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