How to Connect Database and Retrieve it with the use of C#?

**CheckMeNot** · 19-11-2009

Hi friends I am a student of BSC.I.T. and wanted to know how to connect and retrieve database with the help of C#. We don't have that much in syllabus and want to know how to do it? If anyone has knowledge please help me. I am waiting for your reply. Just provide me steps or code so I can understand it.

**Praetor** · 19-11-2009

Hi, you can use following code to connect database in c#

Code:

public void ConnectToAccess()
{
System.Data.OleDb.OleDbConnection conn = new
System.Data.OleDb.OleDbConnection();
database. conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data source= @"path \AccessFile.mdb";
try
{
conn.Open();
// Just insert here your code to process data
catch (Exception caught)
{
MessageBox.Show(caught.Message);
}
finally
{
conn.Close();
}
}

**Katty** · 19-11-2009

Hi friend, I am also facing same problem as you, I have tried to search this on net, but not get anything regarding this. If you find something regarding this then suggest me also. I am waiting for you to reply me. I will search for this and if find something then I will give it to you. Just give me if you got earlier that me. Just post on this forum. I will take it as I am always using this forum for my queries.

**kelfro** · 19-11-2009

Hi, Just use following for your making connection as a code, I think this would help you.

Code:

database. conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=AccessFile.mdb";

If you want to connect in other languages then use following code:

Visual Basic:

Code:

Public Sub CreateSqlConnection()
Dim myConnection As New SqlConnection()
myConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30"
myConnection.Open()
End Sub 'CreateSqlConnection

C#:

Code:

public void CreateSqlConnection()
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30";
myConnection.Open();
}

C++:

Code:

public:
void CreateSqlConnection()
{
SqlConnection* myConnection = new SqlConnection();
myConnection->ConnectionString = S"Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30";
myConnection->Open();
}