Click here to Skip to main content
15,914,444 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Database access through VB.Net Pin
nyjcr17-Dec-04 6:37
nyjcr17-Dec-04 6:37 
GeneralRe: Database access through VB.Net Pin
Anonymous17-Dec-04 8:03
Anonymous17-Dec-04 8:03 
GeneralRe: Database access through VB.Net Pin
OICU81217-Dec-04 19:08
OICU81217-Dec-04 19:08 
GeneralTextBox Alpha blending Pin
Iasonic16-Dec-04 12:53
Iasonic16-Dec-04 12:53 
QuestionMultiple Resource Files? Pin
TAlvord16-Dec-04 12:46
TAlvord16-Dec-04 12:46 
General.DTD write error after modifying XML with XmlDocument Pin
GreenEyes16-Dec-04 10:53
GreenEyes16-Dec-04 10:53 
Generalurgent custom control with collection of controls Pin
ddsmith16-Dec-04 9:33
ddsmith16-Dec-04 9:33 
GeneralRe: DB Connection Question Pin
Dave Kreskowiak16-Dec-04 7:07
mveDave Kreskowiak16-Dec-04 7:07 
Anonymous wrote:
I was trying to use two DataReaders. I guess I need to use two DataSets?

The number of DataSets is not the problem. You can only have one active DataReader object on a connection and any one time. You can have multiple DataSets filled by a DataReader, though.


Anonymous wrote:
"mySqlConnection.Open()"
at the top of my Sub() and close at the bottom. Is this ok?


Not really. You should .Open() your connection immediately before your fill the DataSet, or do whatever you need to do with the database, then .Close() the connection as soon as your done with it. DON'T leave it open and idle for ANY reason. This needlessly consumes resources on the SQL server, not to mention hogs a very expensive licensed connection on the server too.


RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

GeneralRe: DB Connection Question Pin
marrik16-Dec-04 8:17
marrik16-Dec-04 8:17 
GeneralHide Checkbox in Checkbox VB Pin
shinay16-Dec-04 5:55
shinay16-Dec-04 5:55 
GeneralRe: Hide Checkbox in Checkbox VB Pin
shinay16-Dec-04 5:56
shinay16-Dec-04 5:56 
GeneralRe: Hide Checkbox in Checkbox VB Pin
Wjousts16-Dec-04 6:15
Wjousts16-Dec-04 6:15 
GeneralRe: Hide Checkbox in Checkbox VB Pin
shinay16-Dec-04 6:18
shinay16-Dec-04 6:18 
GeneralRe: Hide Checkbox in Checkbox VB Pin
shinay16-Dec-04 6:29
shinay16-Dec-04 6:29 
GeneralRe: Hide Checkbox in Checkbox VB Pin
Wjousts16-Dec-04 6:29
Wjousts16-Dec-04 6:29 
GeneralRe: Hide Checkbox in Checkbox VB Pin
shinay16-Dec-04 6:33
shinay16-Dec-04 6:33 
Generaldatabase help Pin
GaryKoh16-Dec-04 5:49
GaryKoh16-Dec-04 5:49 
GeneralBinding a combobox Pin
Wjousts16-Dec-04 5:29
Wjousts16-Dec-04 5:29 
GeneralRe: Binding a combobox Pin
JWSantora118-Dec-04 16:30
JWSantora118-Dec-04 16:30 
QuestionEasy way of set scroll to bottom in richtext? Pin
carlos_rocha16-Dec-04 4:44
carlos_rocha16-Dec-04 4:44 
AnswerRe: Easy way of set scroll to bottom in richtext? Pin
Dave Kreskowiak16-Dec-04 4:51
mveDave Kreskowiak16-Dec-04 4:51 
GeneralRe: Easy way of set scroll to bottom in richtext? Pin
carlos_rocha16-Dec-04 23:10
carlos_rocha16-Dec-04 23:10 
GeneralRe: Easy way of set scroll to bottom in richtext? Pin
carlos_rocha16-Dec-04 23:51
carlos_rocha16-Dec-04 23:51 
Generalsearching a Date field in Access Pin
jlawren7716-Dec-04 4:10
jlawren7716-Dec-04 4:10 
GeneralRe: searching a Date field in Access Pin
Dave Kreskowiak16-Dec-04 4:45
mveDave Kreskowiak16-Dec-04 4:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.