sql connection class library

Hi,
You can create a separate class and put connection like this

class ClassConnectionString

{

public SqlConnection conConnect;

public void connectionString()

{

//Sample connection string using Northwind Db

conConnect = new SqlConnection("Data Source= (local); Database = Northwind; Integrated Security = True");

}

in your form

public partial class Form1 : Form

{

//initialize connection string

ClassConnectionString _con = new ClassConnectionString();

public Form1()

{

InitializeComponent();

loadNorthwindEmplTable();

}

private void loadNorthwindEmplTable()

{

_con.connectionString();

try

{

string sqlStr = "Select * From Employees ";

SqlDataAdapter dAdapter = new SqlDataAdapter(sqlStr, _con.conConnect);

DataTable dt = new DataTable();

dAdapter.Fill(dt);

this.dataGridView1.DataSource = dt;

}

catch

{

}

Regards,
Iftikar

1 Reply

Know the answer? Post it — somebody with the same question will find it here.