public bool Execute(string sql)
{
bool falg = false;
SqlConnection con = dllCon.getConnection();
try
{
con.Open();
SqlCommand sda = new SqlCommand(sql, con);
int count=(int)sda.ExecuteNonQuery();
if (count>0)
{
falg = true;
} }
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return falg;
}
{
bool falg = false;
SqlConnection con = dllCon.getConnection();
try
{
con.Open();
SqlCommand sda = new SqlCommand(sql, con);
int count=(int)sda.ExecuteNonQuery();
if (count>0)
{
falg = true;
} }
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return falg;
}
如果执行有错的话程序会自动转到catch语句块里面执行的。
楼主可以在catch语句块里面写return fasle; public bool Execute(string sql)
{
bool falg = false;
SqlConnection con = dllCon.getConnection();
try
{
con.Open();
SqlCommand sda = new SqlCommand(sql, con);
sda.ContainerExecuteNonQuery();
{
falg = true;
} }
catch (Exception ex)
{
flag = flase;
}
finally
{
con.Close();
}
return falg;
}建议楼主参考一下我共享的SQL操作通用类,或许对你有帮助http://download.csdn.net/source/501984