C# DBHelper问题

来源：百度知道 编辑：UC知道 时间：2024/07/03 10:55:09
Public static User AddUser(User user)
{
string sql = "INSERT Users (LoginId)" + "VALUES(@LoginId)";
sql +="; SELECT @@IDENTITY";
SqlParamerter[] para = new SqlParameter[]
{
new SqlParameter("@LoginId",user.LoginId);
};
int newId = DBHelper.GetScalar(sql,para);
return newId;
}

我想要 DBHelper.GetScalar(sql,para); 的全部代码
很急还是 谁来帮帮我.....

public class DBHelper
{
//属性:数据库链接对象
private static SqlConnection conn;
public static SqlConnection Conn
{
get
{
string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
if (conn == null)
conn = new SqlConnection(connstr);
if (conn.State == ConnectionState.Closed)
conn.Open();
if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
return conn;
}
}

//方法:查询,DataReader
public static SqlDataReader GetReader(string SqlStr)
{
SqlCommand cmd = new SqlCommand(SqlStr, Conn);
return cmd.ExecuteReader();<