|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
//************************************************** **********
// Get Stores and populate dataset with STOREID and Store private DataSet BindStores() { // Populate the ddlDataSet const string strSQLDDL = @"SELECT STOREID, STORE FROM TBSTORES ORDER BY STOREID"; OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(strSQLDDL, myConnection); myDataAdapter.Fill(ddlDataSet1, "ddlStores"); myConnection.Dispose(); return ddlDataSet1; } //************************************************** ********** //************************************************** ********** // Get Stores and populate dataset with ACCCESSLEVELID and ACCESSLEVEL private DataSet BindAccessLevels() { // Populate the ddlDataSet const string strSQLDDL = @"SELECT ACCESSLEVELID, ACCESSLEVEL From TBACCESSLEVELS ORDER BY ACCESSLEVELID"; OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(strSQLDDL, myConnection); myDataAdapter.Fill(ddlDataSet2, "ddlAccessLevels"); myConnection.Dispose(); return ddlDataSet2; } //************************************************** ********** //************************************************** ********** // Get Stores and populate dataset with UserName private DataSet BindUserNames() { // Populate the ddlDataSet const string strSQLDDL = @"SELECT USERNAME From TBUSERS ORDER BY USERNAME"; OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(strSQLDDL, myConnection); myDataAdapter.Fill(ddlDataSet3, "ddlUserNames"); myConnection.Dispose(); return ddlDataSet3; } //************************************************** ********** |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Database Development > Can we bind all these three to one connection |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|