public Boolean executeNonQueryS(string quary)
{
Boolean flag = false;
SqlConnection con = null;
SqlCommand com = null;
try
{
con = new SqlConnection(DBEstablish.makeConnection());
con.Open();
com = new SqlCommand(quary, con);
com.ExecuteNonQuery();
flag = true;
}
catch (Exception ex)
{
flag = false;
}
finally
{
com.Dispose();
con.Close();
}
return(flag);
}
public SqlDataReader executeQueryS(string quary)
{
SqlConnection con = null;
SqlCommand com = null;
try
{
con = new SqlConnection(DBEstablish.makeConnection());
con.Open();
com = new SqlCommand(quary, con);
return(com.ExecuteReader(CommandBehavior.CloseConnection));
}
catch
{
com.Dispose();
con.Close();
throw;
}
}