C#链接数据库操作2

连接数据库的过程：
1.首先定义一个连接字符串
string connstring="Server=.;uid=sa;pwd=sa;database=pubs";

2.构建连接对象
SqlConnection conn=new SqlConnection(connstring);

3.打开连接对象
conn.Open();

SqlCommand cmd=new SqlCommand("SQL语句",conn);
cmd.ExecuteNonQuery()；
执行操作

#endregion ExecuteReader

#region ExecuteScalar

public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText)
{
//pass through the call providing null for the set of OracleParameters
return ExecuteScalar(connectionString, commandType, commandText, (OracleParameter[])null);
}

public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
//create & open an OracleConnection, and dispose of it a