Data Base Connection C#

public class DbConnection

{

//string cs = @"Data Source=xxx.xxx.xx.xx; Network Library=DBMSSOCN;

//Initial Catalog=xxxxx;user id=x;password=xxxxx";

string cs = @"Data Source=.; Initial Catalog=xxx;Integrated

Security=SSPI;";

//string cs1 = ConfigurationManager.ConnectionStrings["DBCS"].

//ConnectionString;

public DataSet GetMultipalTable(string sql)

{

DataTable dt;

DataSet dset = new DataSet(); //Creating instance of DataSet

try

{

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter(sql, con);

//da.Fill(dset, "student_detail");

// Filling the DataSet with the records returned by SQL

// statemetns written in sqldataadapter

da.Fill(dset);

// Filling the DataSet with the records returned by SQL

// statemetns written in sqldataadapter

//dataGridView1.DataSource = dset.Tables["student_detail"];

// Binding the datagridview

//dt = new DataTable();

//da.Fill(dt);

}

}

catch (Exception ex)

{

dset = null;

}

return dset;

}

public DataTable GetTable(string sql)

{

DataTable dt;

try

{

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter(sql, con);

dt = new DataTable();

da.Fill(dt);

}

}

catch (Exception ex)

{

dt = null;

}

return dt;

}

public SqlDataReader GetSqlDateReader(string sql)

{

SqlDataReader dr;

try

{

SqlConnection con = new SqlConnection(cs);

con.Open();

SqlCommand cmd = new SqlCommand(sql, con);

dr = cmd.ExecuteReader();

}

catch (Exception ex)

{

dr = null;

}

return dr;

}

public int CURDtData(string sql)

{

int result = 0;

try

{

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

SqlCommand cmd = new SqlCommand(sql, con);

result = cmd.ExecuteNonQuery();

con.Close();

}

}

catch (Exception ex) { }

return result;

}

public int insertData(string sql)

{

return CURDtData(sql);

}

public int updateData(string sql)

{

return CURDtData(sql);

}

public int DeleteData(string sql)

{

return CURDtData(sql);

}

//-----------------------------------

public DataTable GetTable(string sql, List<SqlParameter> prm)

{

DataTable dt;

try

{

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

using (SqlDataAdapter da = new SqlDataAdapter(sql, con))

{

da.SelectCommand.Parameters.AddRange(prm.ToArray());

dt = new DataTable();

da.Fill(dt);

da.SelectCommand.Parameters.Clear();

}

con.Close();

}

}

catch (Exception ex) { dt = null; }

return dt;

}

public SqlDataReader GetSqlDateReader(string sql, List<SqlParameter> prm)

{

SqlDataReader dr;

try

{

SqlConnection con = new SqlConnection(cs);

con.Open();

using (SqlCommand cmd = new SqlCommand(sql, con))

{

cmd.Parameters.AddRange(prm.ToArray<SqlParameter>());

dr = cmd.ExecuteReader();

cmd.Parameters.Clear();

}

con.Close();

}

catch (Exception ex) { dr = null; }

return dr;

}

public int CURDtData(string sql, List<SqlParameter> prm)

{

int result = 0;

try

{

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

using (SqlCommand cmd = new SqlCommand(sql, con))

{

cmd.Parameters.AddRange(prm.ToArray<SqlParameter>());

result = cmd.ExecuteNonQuery();

return result;

cmd.Parameters.Clear();

}

con.Close();

}

}

catch (Exception ex) { return 0; }

}

public int InsertData(string sql, List<SqlParameter> prm) {

return CURDtData(sql, prm); }

public int UpdateData(string sql, List<SqlParameter> prm) {

return CURDtData(sql, prm); }

public int DeleteData(string sql, List<SqlParameter> prm) {

return CURDtData(sql, prm); }

}