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;
}
this name is used to connect to access. It is very convenient to create a class.
