link sql with c#

Question

I want easy code to linke the sql server 2008 with c#
I want any one please to explain what prameter the function need ,
I tried this but it doesnot work

Dim connect As New SqlConnection( _
"Server=mycomp;UID=jeff;password=yeah;database=Dummies")
connect.Open()

Sam Hobbs · Answer

There are many articles in this web site that can help you. I think there are more articles here than in the DBTalks.com site. I saw a question like this in the DBTalks.com site; was it yours? For an easy way to make a program to view and modify a table look at my article Database Table Update in a DataGridView without Writing Code but note that there are many other useful articles too. Also there are many good books that will help you.

Ankit Nandekar · Answer

Ado.net Provides various Class which can be used for datasource Communication under the following namespaces: System.Data System.Data.SqlClient System.Data.OleDb System.Data.Odbc System.Data: collections of type use to holding and managing data on client machine. System.Data.OleDb: collections of type use to communicate with any Datasource. System.Data.SqlClient: collections of type use to Communicate only with SqlServer System.Data.Odbc: collections of type use to communicate with traditional odbc drivers. above namspaces contain set of class as following ConnectionCommandDataReaderDataAdapterCommandBuilder etc. Note :Each Class Reffered By Prefexing With Namwspace Name Like: oledbConnectionSqlConnection etc this is the Sample Example in this example we r fetching Data from Database and showing into Combobox. Design Form Take one Combobox with name cmbcolumn write following code. Imports System.Data.SqlClient; Public Class Form1 Dim cn As SqlConnection Dim cmd As SqlCommand Private Sub Form1_Load(ByVal sender As System.Object ByVal e As System.EventArgs) Handles MyBase.Load Try cn=New SqlConnection(Server=[Servername where ur databse store];database=[Databasename];uid=sa;pwd=[password]); cmd = New SqlCommand() cmd.Connection = cn cmd.CommandText = Select [columnname] from [Tablename] cn.Open() 'perform any operation which u want with data like Dim dr As SqlDataReader = cmd.ExecuteReader() While dr.Read() cmbcolumn.Items.Add(dr(0)) 'here cmbcolumn is a comboBox End While cn.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub End Class If this information is useful for u plz mark as accepted answer

Soft Corner · Answer

Hi The code which you have used is in VB.Net for connecting sql server thro' C#  Code: 1. Add reference using System.data.sqlclient 2. Create Connection object SqlConnection conn = new SqlConnection( Data Source=DatabaseServer;Initial Catalog=Northwind;User ID=YourUserID;Password=YourPassword); Connection String Parameter Name Description Data Source Identifies the server. Could be local machine machine domain name or IP Address. Initial Catalog Database name. Integrated Security Set to SSPI to make connection with user's Windows login User ID Name of user configured in SQL Server. Password Password matching SQL Server User ID. 3. Open & Close Connection using above created connection object you can open & close the connection : conn.Open(); //do something conn.Close(); Check with attachment for sample code.