Public dataset getshopnamefrombussinesstable ()
{
Strsql = @ "select * from user ";
Dfwsqldataadapter dalistdata;
Dataset dslistdata = new dataset ();
Datatable dtlistdata = new datatable ();
Try
{
Using (sqlconnection conn = dfwsql. getopenconnection ())
{
Using (sqltransaction TRS = conn. begintransaction (isolationlevel. serializable ))
{
Dtlistdata. tablename = "sectname ";
Dalistdata = new dfwsqldataadapter (strsql, Conn, TRS );
Dalistdata. Fill (dtlistdata );
TRS. Commit ();
}
}
}
Catch (exception)
{
Throw;
}
Dslistdata. Tables. Add (dtlistdata );
Return dslistdata;
}
Public static sqlconnection getopenconnection (bool useadmin, string referencedb, int connecttimeout)
{
Sqlconnectionstringbuilder bldr = new sqlconnectionstringbuilder ();
Bldr. datasource = sqlserver; // @ "." sqlserver ";
Bldr. initialcatalog = northwind;
Bldr. userid = alexusli
Bldr. Password = 123456
Bldr. asynchronousprocessing = true;
Bldr. multipleactiveresultsets = false;
Bldr. Pooling = true;
Bldr. connecttimeout = 15;
Bldr. contextconnection = false;
String connectionstring = bldr. connectionstring;
Sqlconnection con = new sqlconnection (connectionstring );
Con. open ();
Return con;
}