110,566
社区成员
发帖
与我相关
我的任务
分享
public class Date
{
string constr = string.Format("Data Source= ;Initial Catalog= ;User Id= ;Password= ;");
///执行数据库操作
#region
/// <summary>
/// 执行一般SQL操作
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>影响行数</returns>
public bool ExecuteSql(string sql)
{
try
{
SqlConnection sqlcon = new SqlConnection(constr);
SqlCommand command = new SqlCommand(sql, sqlcon);
sqlcon.Open();
int resulr = command.ExecuteNonQuery();
sqlcon.Close();
sqlcon.Dispose();
if (resulr > 0)
return true;
else
return false;
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 执行获取数据集的操作
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>数据集</returns>
public DataSet GetData(string sql)
{
try
{
SqlConnection sqlcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(sql, sqlcon);
sqlcon.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Table");
sqlcon.Close();
sqlcon.Dispose();
return ds;
}
catch (System.Exception ex)
{
throw ex;
}
}
}