sql connection class library

Question

How to create sql connection class library in C#.NET. Please explain about it.

Iftikar Hussain · Answer

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