数据访问机制

public static DataSet ExecuteSqlForDataSet(string strSQL string SqlConnString,dataset mydataset)

{
SqlConnection MyConn = new SqlConnection(SqlConnString);

MyConn.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSQL,MyConn);

MyAdapter.Fill(mydataset);
MyConn.Close();
return mydataset;
}

public DataSet SelectSqlSrvRows(DataSet dataset,string connection,string query)
{
    SqlConnection conn = new SqlConnection(connection);//定义连接
    SqlDataAdapter adapter = new SqlDataAdapter();//定义适配器
    adapter.SelectCommand = new SqlCommand(query, conn);//定义并运行适配器与命令
   adapter.Fill(dataset);//填充数据集
    return dataset;
}

有参数

SqlCommand cmd=new SqlCommand(sql,con);

cmd.Parameters.Add(new SqlParameter("@pubid",SqlDbType.Char,4));

cmd.Parameters["@pubid"].Value=this.TextBox1.Text;

cmd.Connection.Open();

cmd.ExecuteNonQuery();
cmd.Connection.Close();

//没有参数

定义连接与命令

sqlConnection pconn=new sqlconnection(strconn)； 

sqlComm = new SqlCommand();

//配置命令

sqlComm.Connection = sqlConn;

sqlComm.CommandText = clientSql;

sqlComm.CommandType = CommandType.Text;

//适配器

sqlAdapter = new SqlDataAdapter();

.//运行适配器

sqlAdapter.SelectCommand = sqlComm;

//适配器填充数据

sqlAdapter.Fill(ds);