Click here to Skip to main content
15,900,973 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:59
mveDave Kreskowiak22-Feb-07 9:59 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 10:40
alexfromto22-Feb-07 10:40 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 11:57
mveDave Kreskowiak22-Feb-07 11:57 
QuestionDisplaying forms Pin
jady8422-Feb-07 7:17
jady8422-Feb-07 7:17 
AnswerRe: Displaying forms Pin
Dave Kreskowiak22-Feb-07 8:38
mveDave Kreskowiak22-Feb-07 8:38 
AnswerRe: Displaying forms Pin
TwoFaced22-Feb-07 9:10
TwoFaced22-Feb-07 9:10 
QuestionOleDB error Pin
7prince22-Feb-07 7:10
7prince22-Feb-07 7:10 
AnswerRe: OleDB error Pin
Dave Kreskowiak22-Feb-07 8:36
mveDave Kreskowiak22-Feb-07 8:36 
First, why are you using the Ole data providers when your using a MS SQL Server? Use the Sql Server providers (SqlConnection, SqlCommand, Sql...) for better performance.

Next, you're retrieving all this data just to find a record and write it back when you don't have to. The DataSet object that you filled with your DataAdapter already has this data in it. If the textbox's are bound to the DataSet, the updates have already been made. Just call the Update method on your DataAdapter and it'll write the changed records back to the database. Just about all of this code is unnecessary.

Dave Kreskowiak
Microsoft MVP - Visual Basic


GeneralRe: OleDB error Pin
7prince22-Feb-07 12:55
7prince22-Feb-07 12:55 
QuestionHow to avoid serialization of events Pin
Bergerrudi22-Feb-07 5:51
Bergerrudi22-Feb-07 5:51 
AnswerRe: How to avoid serialization of events Pin
nlarson1122-Feb-07 5:59
nlarson1122-Feb-07 5:59 
GeneralRe: How to avoid serialization of events Pin
Dave Kreskowiak22-Feb-07 6:10
mveDave Kreskowiak22-Feb-07 6:10 
GeneralRe: How to avoid serialization of events Pin
nlarson1122-Feb-07 6:19
nlarson1122-Feb-07 6:19 
AnswerRe: How to avoid serialization of events Pin
Dave Kreskowiak22-Feb-07 6:06
mveDave Kreskowiak22-Feb-07 6:06 
GeneralRe: How to avoid serialization of events Pin
Bergerrudi23-Feb-07 0:36
Bergerrudi23-Feb-07 0:36 
Questionstring to DateTime Conversion Pin
Jonathan Gibbs22-Feb-07 4:17
Jonathan Gibbs22-Feb-07 4:17 
AnswerRe: string to DateTime Conversion Pin
Stefan Troschuetz22-Feb-07 7:44
Stefan Troschuetz22-Feb-07 7:44 
GeneralRe: string to DateTime Conversion Pin
Jonathan Gibbs23-Feb-07 2:57
Jonathan Gibbs23-Feb-07 2:57 
QuestionCheck fields for specific characters Pin
rhon_ridge22-Feb-07 3:15
rhon_ridge22-Feb-07 3:15 
AnswerRe: Check fields for specific characters Pin
nlarson1122-Feb-07 6:01
nlarson1122-Feb-07 6:01 
QuestionWhen to close streamreaders/writers Pin
Marcus J. Smith22-Feb-07 3:12
professionalMarcus J. Smith22-Feb-07 3:12 
AnswerRe: When to close streamreaders/writers Pin
Dave Kreskowiak22-Feb-07 5:05
mveDave Kreskowiak22-Feb-07 5:05 
GeneralRe: When to close streamreaders/writers Pin
Marcus J. Smith22-Feb-07 5:21
professionalMarcus J. Smith22-Feb-07 5:21 
GeneralRe: When to close streamreaders/writers Pin
Dave Kreskowiak22-Feb-07 5:25
mveDave Kreskowiak22-Feb-07 5:25 
GeneralRe: When to close streamreaders/writers Pin
Marcus J. Smith22-Feb-07 5:28
professionalMarcus J. Smith22-Feb-07 5:28 

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.