Click here to Skip to main content
15,887,485 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionTCP/ Thread/ Timer Pin
Brent Lamborn17-Nov-05 5:46
Brent Lamborn17-Nov-05 5:46 
Questionconverting string to date Pin
microuser_200016-Nov-05 22:08
microuser_200016-Nov-05 22:08 
AnswerRe: converting string to date Pin
eagertolearn17-Nov-05 5:52
eagertolearn17-Nov-05 5:52 
QuestionHindi in VB.net Pin
abhinish16-Nov-05 18:33
abhinish16-Nov-05 18:33 
QuestionReferencing a TextBox in a DataGrid Pin
dptalt16-Nov-05 12:32
dptalt16-Nov-05 12:32 
QuestionUpdating dataset, very slow compared to Foxpro ? Pin
snoopdog10116-Nov-05 10:13
snoopdog10116-Nov-05 10:13 
AnswerRe: Updating dataset, very slow compared to Foxpro ? Pin
dptalt16-Nov-05 12:46
dptalt16-Nov-05 12:46 
GeneralRe: Updating dataset, very slow compared to Foxpro ? Pin
snoopdog10117-Nov-05 7:08
snoopdog10117-Nov-05 7:08 
It should not be updating the entire dataset, just that one adapter. I am using something like this.

dataadapter1.Update(ChangedRows)

I figure it close to 8 seconds. I tried to shorten the update statement, that did not seem to help any at all. Your question about the database being overworked ? Nah, I am the only one on it and the server is rather robust. I did borrow this code from someone maybe it is at fault ? This is in the update subroutine.


'Create a new dataset to hold the changes that have been made to the main dataset.<br />
       Dim objDataSetChanges As BA_Application.DataSet1 = New Application.DataSet1<br />
       'Stop any current edits.<br />
       Me.BindingContext(DataSet11, "customer").EndCurrentEdit()<br />
       Me.BindingContext(DataSet11, "inventory").EndCurrentEdit()<br />
       Me.BindingContext(Dataset11, "orders").EndCurrentEdit()<br />
       'Get the changes that have been made to the main dataset.<br />
       objDataSetChanges = CType(DataSet11.GetChanges, Application.DataSet1)<br />
       'Check to see if any changes have been made.<br />
       If (Not (objDataSetChanges) Is Nothing) Then<br />
           Try<br />
               'There are changes that need to be made, so attempt to update the datasource by<br />
               'calling the update method and passing the dataset and any parameters.<br />
               Me.UpdateDataSource(objDataSetChanges)<br />
               DataSet11.Merge(objDataSetChanges)<br />
               DataSet11.AcceptChanges()<br />
           Catch eUpdate As System.Exception<br />
               'Add your error handling code here.<br />
               Throw eUpdate<br />
           End Try<br />
           'Add your code to check the returned dataset for any errors that may have been<br />
           'pushed into the row object's error.<br />
       End If



-- modified at 13:08 Thursday 17th November, 2005
GeneralRe: Updating dataset, very slow compared to Foxpro ? Pin
dptalt18-Nov-05 2:31
dptalt18-Nov-05 2:31 
QuestionRich Text box Focus Pin
Gerald Manickam16-Nov-05 3:11
Gerald Manickam16-Nov-05 3:11 
QuestionHow to get height , width in pixel of screen in VB net Pin
dinhnq15-Nov-05 21:31
dinhnq15-Nov-05 21:31 
AnswerRe: How to get height , width in pixel of screen in VB net Pin
Mazitan16-Nov-05 2:59
Mazitan16-Nov-05 2:59 
QuestionCOM and DCOM in VB Pin
Paritos15-Nov-05 20:55
Paritos15-Nov-05 20:55 
AnswerRe: COM and DCOM in VB Pin
Christian Graus17-Nov-05 17:35
protectorChristian Graus17-Nov-05 17:35 
QuestionHow to read and write a text file in VB.Net ? Pin
Zakiah15-Nov-05 20:48
Zakiah15-Nov-05 20:48 
AnswerRe: How to read and write a text file in VB.Net ? Pin
Joshua Quick15-Nov-05 21:07
Joshua Quick15-Nov-05 21:07 
AnswerRe: How to read and write a text file in VB.Net ? Pin
S-to16-Nov-05 15:36
S-to16-Nov-05 15:36 
QuestionIn Datagrid the Error tooltip does not pop up even though ErrorIcon is displayed Pin
BabyEmperor15-Nov-05 20:38
BabyEmperor15-Nov-05 20:38 
Question3-Tier Coding Pin
rei ayumi15-Nov-05 19:39
rei ayumi15-Nov-05 19:39 
AnswerRe: 3-Tier Coding Pin
StylezHouse16-Nov-05 3:49
StylezHouse16-Nov-05 3:49 
AnswerRe: 3-Tier Coding Pin
Keith Barrow24-Jun-11 0:47
professionalKeith Barrow24-Jun-11 0:47 
QuestionFlickering form Pin
eagertolearn15-Nov-05 16:05
eagertolearn15-Nov-05 16:05 
AnswerRe: Flickering form Pin
Joshua Quick15-Nov-05 16:16
Joshua Quick15-Nov-05 16:16 
GeneralRe: Flickering form Pin
eagertolearn16-Nov-05 5:54
eagertolearn16-Nov-05 5:54 
GeneralRe: Flickering form Pin
Joshua Quick16-Nov-05 7:16
Joshua Quick16-Nov-05 7:16 

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.