Question

ASP.NET C# 连接数据库代码怎么写 我忘记了只要连接数据库就成

我是本地连接 数据库 叫cuiwei 用户sa
知道的写一下

Answer 1

/// <summary>
/// 数据库连接字段
/// </summary>
private static string STR_CON = @".\sql2005;database = cuiwei; integrated security =sspi";

/// <summary>
/// 根据给定命令获得信息
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static SqlDataReader GetAllMap(string sql)
{
SqlConnection con = new SqlConnection(STR_CON);

SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
try
{
con.Open();
SqlDataReader red = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return red;
}
catch ( Exception e )
{
con.Close();
throw new Exception(e.Message);
}
}