public static bool MyExecuteQuery(string sql, byte[] image)
{
MyConnect.Connect();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
try
{
if (image == null)
{
cmd.Parameters.Add("@image", SqlDbType.Image).Value = DBNull.Value;
}
else
{
cmd.Parameters.AddWithValue("@image", image);
}
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
MyConnect.Disconncet();
cmd.Dispose();
}
return(true);
}
}
public static SqlDataReader getReader(string sql)
{
MyConnect.Connect();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
return(reader);
}
public static string MyExecuteScalar(string sql)
{
MyConnect.Connect();
SqlCommand cmd = new SqlCommand(sql, con);
string s = cmd.ExecuteScalar().ToString();
MyConnect.Disconncet();
cmd.Dispose();
return(s);
}
public static DataTable getTable(string strSelect)
{
DataTable table = new DataTable();
MyConnect.Connect();
SqlDataAdapter adapter = new SqlDataAdapter(strSelect, con);
adapter.Fill(table);
MyConnect.Disconncet();
adapter.Dispose();
return(table);
}
public static string getString(string sql)
{
string s = null;
MyConnect.Connect();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
s = reader[0].ToString();
}
MyConnect.Disconncet();
cmd.Dispose();
reader.Close();
return(s);
}
}
}
public static bool MyExecuteQuery(string sql)
{
MyConnect.Connect();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
MyConnect.Disconncet();
cmd.Dispose();
}
return(true);
}
}
