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)
{
Console.WriteLine("{0}" + ex.Message);
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 (SqlException ex)
{
if (com != null)
{
com.Dispose();
}
if (con != null)
{
con.Close();
}
Console.WriteLine(ex.Message);
throw;
}
catch
{
if (com != null)
{
com.Dispose();
}
if (con != null)
{
con.Close();
}
throw;
}
finally
{
if (com != null)
{
com.Dispose();
}
}
}