Updating dataset, very slow compared to Foxpro ? - Visual Basic Discussion Boards

jasonbullard17-Nov-05 15:39

17-Nov-05 15:39

What do you mean by auto populate fields. Are you saying you want to open a form and then once the form is open have data sent to three different text boxes in the sub form?

VBA Code
Form_FormName.TextBoxName.Value = ""

or

Form_FormName.TextBoxName.Text = ""

HTH,
Jason

Re: MS ACCESS - VBA

GM9921-Nov-05 4:51

GM99

21-Nov-05 4:51

Thanks, But i try that and didn't work. It is possible that I'm l doing something wrong.

This is what is did:

I go to the code envir - form afterupdated of the subform then i type the

Form_Crs.crs_cd.Value = ""

Please tell what am I doing wrong?

Confused | :confused:

Thanks

TCP/ Thread/ Timer

Brent Lamborn17-Nov-05 5:46

Brent Lamborn

17-Nov-05 5:46

Hello all...

I a windows service that starts a new thread in the onstart event to do the work. The work has a while loop that listens to a TCP connection which blocks on the stream.read call. There may or may not be any packet for up to 30 seconds and I need to update data more often than that, about every one second. I have a timer which should tick every 1 sec but the while loop that listens to the TCP stream seems to keep the tick event from firing. The timer.start call is inside the thread. Any ideas on how to get that tick event to fire? Or a better solution?

Thanks in advance...

"Half this game is ninety percent mental."
- Yogi Berra

converting string to date

microuser_200016-Nov-05 22:08

microuser_2000

16-Nov-05 22:08

hellow to all ..
how can i convert a sting to a date type ..
and then substract it from another date ?

Re: converting string to date

eagertolearn17-Nov-05 5:52

eagertolearn

17-Nov-05 5:52

What i did is adding the "/" and "#" to the string and get the difference by using DateDiff Smile | :)

So, it's like this

dim d as date
d = "#" + month.Tostring + "/" + date.Tostring + "/" + year.tostring + "#"
dim day as integer
day = DateDiff(DateInterval.Day, d, WhateverDate)

You can change the Dateinterval to your liking.
Hope that helps Smile | :)

Hindi in VB.net

abhinish16-Nov-05 18:33

abhinish

16-Nov-05 18:33

Hi guys!

need some help..
i want to use hindi fonts in my application also i want to save the data in sql2000 in hindi..for displaying it later

can any one help me as i m searching for it but cant find the appropriate help.

abhinav

Referencing a TextBox in a DataGrid

dptalt16-Nov-05 12:32

dptalt

16-Nov-05 12:32

How do I create a Validated event for a TextBox that is in a DataGrid?

Thanks

Updating dataset, very slow compared to Foxpro ?

snoopdog10116-Nov-05 10:13

snoopdog101

16-Nov-05 10:13

I am recreating a program originally written in Foxpro, which is nearly complete. I am running into a design problem causing me some grief. Basically the program is a form connected to a database displaying the fields in texbox. The original Foxpro program saved the changes made if the person moved out of the textbox, or tabbed out. Pretty convienent for them, and they are used to that. The Foxpro update is almost instant.

Ok mine has an update button, takes about 9 seconds for the adapters to update. If I tie this into any control it will take that long. I know that the design is different, but is this what I am stuck with ? I know nothing of Foxpro but it seems it is updated just that one field and mine is updating everything ? Mine is updating like this...

dataset1.Update(ChangedRows)

Re: Updating dataset, very slow compared to Foxpro ?

dptalt16-Nov-05 12:46

dptalt

16-Nov-05 12:46

You could try using the OleDbCommand instead of the DataAdapter for your update. You will have less overhead. Also Dataset1.Update updates the whole DataSet which takes more time then updating one table row using OleDbCommand. Not sure how much of a difference this will make. 9 seconds seems like along time - is the database server being over worked?

I'm a long time FoxPro programmer switching to VB .Net and I can say in your example FoxPro will always be quicker because in FoxPro the table is already opened and at the correct record. In VB .NET you have to make a connection and send the update command.

Re: Updating dataset, very slow compared to Foxpro ?

snoopdog10117-Nov-05 7:08

snoopdog101

17-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

Re: Updating dataset, very slow compared to Foxpro ?

dptalt18-Nov-05 2:31

dptalt

18-Nov-05 2:31

rem out this line

DataSet11.Merge(objDataSetChanges)

Rich Text box Focus

Gerald Manickam16-Nov-05 3:11

Gerald Manickam

16-Nov-05 3:11

hai,

I am using Rich Text box control for displaying the status in my project.when the text exceeds the control's size i can't able to see the status .Is there is way to always focus at new entered text position.

with Thanks and regards,

P.Gerald Manickam

How to get height , width in pixel of screen in VB net

dinhnq15-Nov-05 21:31

dinhnq

15-Nov-05 21:31

Please let me know how to get height , width in pixel of screen in VB net
Thanks

Re: How to get height , width in pixel of screen in VB net

Mazitan16-Nov-05 2:59

Mazitan

16-Nov-05 2:59

You should be able to do this using the screen class. (either bounds or working area will do)

Helpful linkhttp://msdn2.microsoft.com/library/e8xzhd15.aspx[^]

COM and DCOM in VB

Paritos15-Nov-05 20:55

Paritos

15-Nov-05 20:55

HI,

I request to send the real defination of com and dcom with small example in VB.
Also features of COM and DCOM is needed to me.

thank you

Paritosh

Re: COM and DCOM in VB

Christian Graus17-Nov-05 17:35

Christian Graus

17-Nov-05 17:35

This is a prime example of the sort of question that is trivial to answer yourself with the help of google. You want to know what COM is, that's not a programming question, it's a 'I can't be bothered searching myself' question.

For what it's worth, when you inevitably get some 1 votes, I didn't vote on this post.

Christian Graus - Microsoft MVP - C++

How to read and write a text file in VB.Net ?

Zakiah15-Nov-05 20:48

Zakiah

15-Nov-05 20:48

Hello,
Can any body tell me how to read and write a text file in VB.Net

Thanks in advance,

Re: How to read and write a text file in VB.Net ?

Joshua Quick15-Nov-05 21:07

Joshua Quick

15-Nov-05 21:07

Take a look at System.IO.File on MSDN.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemiofileclasstopic.asp[^]

Re: How to read and write a text file in VB.Net ?

S-to16-Nov-05 15:36

S-to

16-Nov-05 15:36

for simple instantly >>

http://www.builderau.com.au/program/windows/0,39024644,20267367,00.htm[^]

In Datagrid the Error tooltip does not pop up even though ErrorIcon is displayed

BabyEmperor15-Nov-05 20:38

BabyEmperor

15-Nov-05 20:38

Hi,

i have made a form which follows the following logic :-

The form displays various panels which are used to get criterias from the user. then form.layout is suspended and the following algorithm executes :
1. Based on these criterias i add various column to a datatable say dtRecordsReturned.
2. Then datagridcolumnstyles [some of them are instances of classes i inherited from datagridcolumnstyle] are made and added to a datagridtablestyle , which is then added to the TableStyle property of a datagrid say dgRecordsReturned.
3. the dtRecordsReturned is then bound to a dataview dvRecordsReturned.
4. dvRecordsReturned is bound to the dgRecordsReturned.
5. then records(rows) are added to dtRecordsReturned by executing a sqlQuery.
6. Then Values of some of the columns of each row are set according to the criterias got from the user. While doing this some special conditions may arise, which i am displaying to the user by setting an errormessage on that particulare column by calling .SetColumnError(columnname,strSpecialContidionDescription).
7. then the panel [pnlRecordsReturned] which contains dgRecordsReturned is brought to the front by calling pnlRecordsReturned.BringToFront().
8.Finally the form.Resumelayout() is called.

Now the Problem i am facing is that though the ColumnErrorIcon is displayed in the columns, no tooltip message pops up when the cursor is hovered over the icon.

I tried using .RowError instead of .SetColumnError still the result is similar. ErrorIcon appears in the rowheader but no tooltip message pops up.

Any Suggestions?

Thanks

3-Tier Coding

rei ayumi15-Nov-05 19:39

rei ayumi

15-Nov-05 19:39

hiya, i am new to .NET.I am required to use .NET to do my project. Hope the people here can help me the following questions.

1:When begin,what codes should i added first?
2:What is the code for the link control from a web form to another?
3:How to connect to microsoft access?
4:How to make the buttons to scroll the info?
5:How to make the data to be read according to the link topic under the same database?

Thanks

Re: 3-Tier Coding

StylezHouse16-Nov-05 3:49

StylezHouse

16-Nov-05 3:49

Wow...

rei ayumi wrote:
1:When begin,what codes should i added first?

....

rei ayumi wrote:
2:What is the code for the link control from a web form to another?

<a href="page2.aspx">Goto Page 2</a>

<asp:hyperlink id="Page2Link" runat="server" navigateurl="page2.aspx" />

rei ayumi wrote:
3:How to connect to microsoft access?
4:How to make the buttons to scroll the info?
5:How to make the data to be read according to the link topic under the same database?

Seems to me you don't even know the basics... I'd suggest you get a book...or 12....and read some tutorials, or follow by example, lots of great code on this site.

Re: 3-Tier Coding

Keith Barrow24-Jun-11 0:47

Keith Barrow

24-Jun-11 0:47

rei ayumi wrote:
1:When begin,what codes should i added first?

Whichever you think should be added first! Given you question it seems you are a begginer, I would suggest writing a small part of the UI and use that to get data out.

rei ayumi wrote:
2:What is the code for the link control from a web form to another?

Not sure what you mean by this!

rei ayumi wrote:
3:How to connect to microsoft access?

You need to research a technology called ADO.NET: it is built into the .net framwork and provides a way of connecting to most common databases. You might also want to google for "LINQ to SQL" and Entity Framework for options based on ADO.NET

rei ayumi wrote:
4:How to make the buttons to scroll the info?

Depends, but normally you don't, the scroll appears when the data is too large to fit. Again, I'm not sure I understand your question.

rei ayumi wrote:
5:How to make the data to be read according to the link topic under the same
database?

It is impossible to tell you exactly how to do this, it depends how you are getting your data. With pure ADO.NET you query the database using the link topic to filter via an SQL WHERE clause. With LINQ and Entity Framework you can write a LINQ query to do the same job. The details depend exactly on which technology you use, what and how you want to filter.

Hope this helps.

[Edit]
Though the help is late, I didn't realise that I was not on "Page 1" of the forum and was answering a 5 year old question. If you do invent time-travel, go back and inform yourself that ADO.NET is your only option until 2007 IIRC.

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Flickering form

eagertolearn15-Nov-05 16:05

eagertolearn

15-Nov-05 16:05

Hi,

I'm designing a form without a title form. To move the form around, I have to write another simple mouse_move event that will get the location of the mouse pointer and will replace the location of the form. It works, but the thing is, when i tried to move the form around, it flickers. I tried to use the doublebuffering style, but it still flickers. Anyone know why this is or how to handle this kind of situation? Also, the mouse pointer is off by a noticable distance from the form.
Anyone, please help. I am a newbie here, so please show me your guidance.

Thank you

Re: Flickering form

Joshua Quick15-Nov-05 16:16

Joshua Quick

15-Nov-05 16:16

We can better help you if you post your MouseMove event code.

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