有人吗,wuwuwu
百度一大把,百度一大把,百度一大把
private static string connectionString="Data Source=127.0.0.1;Database=MyDB;UID=sa;pwd=123456;";
/// <summary>
/// 执行SQL语句,返回影响的记录数
/// </summary>
/// <param name="sqlString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string sqlString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(sqlString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (SqlException ex)
{
connection.Close();
return 0;
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
}