技巧百問(3):asp.net串連sql和access的方法?

1.sql類   DataView
         

public DataView getview(string query,string connstr,int startrcd,int pagesize)
        {
            SqlConnection connection=new SqlConnection(connstr);
            SqlDataAdapter myadp=new SqlDataAdapter(query,connection);
            DataSet tableset=new DataSet();
            myadp.Fill(tableset,"alltable");
            myadp.Fill(tableset,startrcd,pagesize,"istable");
            DataView isview=new DataView();
            isview.Table=tableset.Tables["alltable"];
            maxselect=isview.Count;
            isview.Table=tableset.Tables["istable"];
            return isview;
            tableset.Tables[0].Select();
        }

DataReader
public SqlDataReader getreader(string query,string connstr)
        {
            SqlConnection connection=new SqlConnection(connstr);
            SqlCommand mycom=new SqlCommand(query,connection);
            connection.Open();
            SqlDataReader isreader=mycom.ExecuteReader();
            return isreader;
        }

Nonequery

public int nonequery(string query,string connstr)
        {
            SqlConnection connection=new SqlConnection(connstr);
            SqlCommand command=new SqlCommand(query,connection);
            connection.Open();
            int n=command.ExecuteNonQuery();
            connection.Close();
            return n;            
        }

       串連Access的就是該哈名稱就是了。我是弄成類，很方便。