<connectionStrings>
<add name= "Strcon" connectionstring= "Data source=.;i Nitial Catalog=datamanager; User Id=sa; Passwoed=lifatshit "/>
</connectionStrings>
Package table
public static DataTable executedatetable (String sql, params sqlparameter[] param)
{
DataTable dt = null;
using (SqlConnection con=new SqlConnection (Strcon))
{
SqlCommand cmd = new SqlCommand (sql, con);
Cmd. Parameters.addrange (param);
Using (SqlDataAdapter adapter=new SqlDataAdapter (CMD))
{
DT = new DataTable ();
Adapter. Fill (DT);
}
}
return DT;
}
Perform additions and deletions to return the number of rows affected
public static int ExecuteNonQuery (String sql, params sqlparameter[] param)
{
int n =-1;
using (SqlConnection con = new SqlConnection (Strcon))
{
using (SqlCommand cmd = new SqlCommand (sql, con))
{
Con. Open ();
Cmd. Parameters.addrange (param);
n = cmd. ExecuteNonQuery ();
}
}
return n;
}
Execute query is responsible for returning first row column
public static Object Executedcalar (String sql, params sqlparameter[] param)
{
Object o = null;
using (SqlConnection con=new SqlConnection (Strcon))
{
using (SqlCommand cmd=new SqlCommand (Sql,con))
{
Con. Open ();
Cmd. Parameters.addrange (param);
o = cmd. ExecuteScalar ();
}
}
return o;
}
Read database
public static SqlDataReader ExecuteReader (string sql,params sqlparameter[] param)
{
SqlDataReader reader = null;
using (SqlConnection con = new SqlConnection (Strcon))
{
using (SqlCommand cmd = new SqlCommand (sql, con))
{
Con. Open ();
Cmd. Parameters.addrange (param);
reader = cmd. ExecuteReader ();
}
}
return reader;
}
Encapsulating the database Profile app configuration file