public static SqlConnection connStr = new SqlConnection("Server=D96B85DD938A465.;uid=sa;pwd=change;database=TCPDB");
public static SqlDataReader SqlReader(string sql, SqlConnection connstr)
{
SqlDataReader sqldr = null;
SqlCommand cmd = new SqlCommand(sql, connstr);
if (cmd.Connection.State.ToString() == "Closed") cmd.Connection.Open();
try
{
sqldr = cmd.ExecuteReader();
}
catch (Exception e)
{
if (e != null) sqldr = null;
}
return sqldr;
}
//数据库操作连接
public static string SqlCmd(string sql, SqlConnection connstr)
{
string errorstr = null;
SqlCommand sqlcmd = new SqlCommand(sql, connstr);
if (sqlcmd.Connection.State.ToString() == "Open") sqlcmd.Connection.Close();
sqlcmd.Connection.Open();
try
{
sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
if (e != null) errorstr = e.ToString();
}
sqlcmd.Connection.Close();
return errorstr;
}
在UserData.CS的基础上，主程序可以更方便地实现数据库连接操作，对数据库进行读写和更新，在此不再详述。
2656895362
work85
