Visual Basic

Dave Kreskowiak30-Apr-07 11:59

30-Apr-07 11:59

If you're using a DataAdapter and doing updates back to the database through that Adapter, there is no choice. You MUST provide the other SQL commands, either by using the CommandBuilder, or by supplying them yourself.

If you're not calling update on the Adatper, then you don't need the other commands. There is simply no getting around this if you use an Adapter.

There are, of course, other ways to fill a dataset and writing data back to a database without using a DataSet.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

CCG31-May-07 1:34

CCG3

1-May-07 1:34

Hey Dave, thanks for you input on this. I am probably not explaining things correctly so I will try to do better. This function that I am using works on on less than 18 other tables in my project with no problems.

Here's an example of what I am doing in a working function...

If txtDrugUse.Text = "" Then<br />
                    EditRow.SurgDrugDesc = String.Empty<br />
                Else : EditRow.SurgDrugDesc = Me.txtDrugUse.Text<br />
                End If<br />
<br />
<br />
                'Update the record<br />
                Try<br />
                    Me.Validate()<br />
                    Me.Pat01SurgeryBindingSource.EndEdit()<br />
                    Me.Pat01SurgeryTableAdapter.Update(Me.AnesDataSet.Pat01Surgery)<br />
                Catch ex As Exception<br />
                    MsgBox("Update of Surgury Table Failed")<br />
                End Try

Now I that have this working just fine all over my project and that is why I don't understand why I suddenly need to use a CommandBuilder to do the same exact thing that works everywhere else. Any ideas?

One thing that I have noticed, and I don't know if it has anything to do with it or not. but when I type in Me.Validate it takes it but from the drop down list that comes up it isn't listed but ValidateChildren is listed. I don't understand why and it might not have anything to with it but I am completely at a loss here.

Dave Kreskowiak1-May-07 1:50

1-May-07 1:50

Did you use the Designer to add these tables to your code?? It sure looks like it. In that case, the CommandBuilders have been put into your code automatically by the designer.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

IBM DOS BASIC 3.0 To .Net

CCG31-May-07 1:53

CCG3

1-May-07 1:53

Yes I did. I created the Dataset and then I drug the needed tables to the designer.

MoreMakarand30-Apr-07 9:14

MoreMakarand

30-Apr-07 9:14

Hi All,

I have the application developed in MS Dos Basic 3.0.
I want to convert or reverse engineering that application into .Net 2005 C#.
Kindly provide me suggestion or ways (any kind of parser is available).

thanks in advance.

Mack

Re: IBM DOS BASIC 3.0 To .Net

Dave Kreskowiak30-Apr-07 9:24

Re: IBM DOS BASIC 3.0 To .Net

30-Apr-07 9:24

The only choice you have is to analyze the source code of the app and completely rewrite it from scratch. There is NOTHING that will convert old DOS Basic code to anything in use today.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

MoreMakarand1-May-07 3:15

MoreMakarand

1-May-07 3:15

Thank you Dave...

Makarand More

Vb.net apps require internet access to run?

Emetz56430-Apr-07 8:42

Emetz564

30-Apr-07 8:42

I've been writing a bunch of little apps exploring various controls, components, etc.I have two minor issues, wondering if anyone could help.

First, when I build the apps to run outside of vb express, they all seem to require internet access to run.If I don't create an exception in my firewall for each app they crash on execution.

Second, When using the FileSystemWatcher object, if I save a file from the internet to the watched directory, I get double File Created events.Is this normal?

Eric.

Re: Vb.net apps require internet access to run?

Dave Kreskowiak30-Apr-07 9:23

Re: Vb.net apps require internet access to run?

30-Apr-07 9:23

Emetz564 wrote:
First, when I build the apps to run outside of vb express, they all seem to require internet access to run.If I don't create an exception in my firewall for each app they crash on execution.

Don't know what this is. You don't need internet access to run the app. It would probably depend on what controls you're using.

Emetz564 wrote:
cond, When using the FileSystemWatcher object, if I save a file from the internet to the watched directory, I get double File Created events.Is this normal?

Yes, it is. The FSW depends entirely on HOW the application is doing the file work. In the case if IE, when it downloads a file, it's downloaded to a temp folder using a temp name, not the real filename. When the download is done, the file is copied to the actual destination folder (Creat event #1), then renamed to its real filename (Create event #2).

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Emetz56430-Apr-07 22:47

Emetz564

30-Apr-07 22:47

Thanks for answering.
Regarding question #1:
The apps in question aren't using any network or internet related controls.Just your basic combination of buttons,text boxes, notifyicon, etc.I guess I'll try a network sniffer and see what they're doing.

Regarding question #2:
If the FSW is only watching the destination folder, shouldn't the file created event in the temp folder be ignored?

Eric.

Re: Vb.net apps require internet access to run?

Dave Kreskowiak1-May-07 2:06

detecting mouse click on a form playing a video

1-May-07 2:06

Emetz564 wrote:
I guess I'll try a network sniffer and see what they're doing.

That would be my next move.

Emetz564 wrote:
If the FSW is only watching the destination folder, shouldn't the file created event in the temp folder be ignored?

It is being ignored. The FSW only watches the target folder. When it starts, it enumerates the files and their Created and Modified DateTimes, along with other things. Every once in a while it makes another list and compares the two.

When a new filename shows up or a file with the same name has a new Created time, it fires off the Create event.

If a file disappears off the list, Deleted event.

If a file has a new Modified DateTime, the Changed event.

Now, Renamed is a bit different. The FSW CAN detect a renamed file, but, for some reason, not in all cases. It depends on what the application is doing that is modifying the files. Either the Renamed event is going to fire, or the Created event will fire, maybe along with the Deleted event. It probably has to do with a timing issue when the FSW scans the target folder(s).

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

kuku3330-Apr-07 6:42

kuku33

30-Apr-07 6:42

Hey all, I'm kind of new to VB so be gentle with me.
I'm trying to write an application that detects a mouse click on a video (target acquisition), working with still pics (jpeg etc.) worked great
but when I play a video (using MMcontrol) the clicks are not detected.
I'm using VB6 (thats what the U offers) and directx9 (on XPsp2)
Thanx in advance , have fun ya all.

Re: detecting mouse click on a form playing a video

Dave Kreskowiak30-Apr-07 10:09

Re: detecting mouse click on a form playing a video

30-Apr-07 10:09

I haven't used the MMControl in, what, 8 years. But, IIRC, it doesn't give any Click events for the video window, just the control bar.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

kuku335-May-07 0:42

kuku33

5-May-07 0:42

Well thanks.
what i really need is a way to detect a click on the video, I don't care which
controller I use, if there is anything taht can make it work I'll take it.
thanks again.

Re: detecting mouse click on a form playing a video

Dave Kreskowiak5-May-07 3:42

Re: Biz talk server and .Net

5-May-07 3:42

Well, I don't know if it's possible, because I just about never touch DirectX, but if you have the capability to tell DirectX which window to draw in, you can use a PictureBox control as the target window, then handle the Click event of the PictureBox.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Biz talk server and .Net

nitin_ion30-Apr-07 6:01

nitin_ion

30-Apr-07 6:01

can some one tell me on using Biz talk server for .Net application.

Dave Kreskowiak30-Apr-07 9:17

how to process richtextbox load using backgroundworker

30-Apr-07 9:17

You haven't really given us a question to answer. All we can do is refer you to the BizTalk Developer Center[^].

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

musay30-Apr-07 5:57

musay

30-Apr-07 5:57

i have a syntax richtextbox; which check words in change event; its working but very slow; i want to minimize the load using of backgroud worker; which process colorizing process in the same time with writting, please i need the solution for this problem very soon!!!

my E-Mail:
mosayousef@yahoo.com

thank you!

mosayousef@yahoo.com

Re: how to process richtextbox load using backgroundworker

Dave Kreskowiak30-Apr-07 9:15

30-Apr-07 9:15

You could move that to a background thread, but it's going to get slower the with more and more text. The RichTextBox wasn't designed to be a colorizer. It'll work, but not good. THe problem is that the user is still modifying text while you code is trying to modify it too. That's not easy to control. Depending on the method you chose to do the coloring and put the RTF back into the RTB, you can be overwriting the changes the user is making to the text, while your colorizing it. Since we know nothing of your code, it's really impossible to say anything other that refer you to an article like this one[^].

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Special Datagrid sort

Dayekh30-Apr-07 4:16

Dayekh

30-Apr-07 4:16

Hi,

I have a list of records. Those records have a field called Progress. There are 4 Progresses. 'Pending', 'Work In Progress' and 'Completed'.
If I sort by Progress in ASCENDING, then the order will be:
Completed
Pending
Work In Progress

If I sort by Progress in DESCENDING, then the order will be:
Work In Progress
Pending
Completed

I need PENDING to be at the top. So that all the records which are PENDING will be at the top and the rest can be sorted as normal. Any ideas how I can do this?

Thank you.

kubben30-Apr-07 4:35

kubben

30-Apr-07 4:35

Add a new column to the DataTable in memory and set the value based off the Progress column. That way you can set Pending = 1, work in progress = 2, completed = 3. Then in your code take the dataview and sort it.
dim dv as DataView = dataTable.DefaultView
dv.Sort = "NewSortColumn"

Or you could just add a Sort column to your table in the database as well.
Or you could move the Process column into its own table and just stored the processid in your table you are returning.

Hope that helps.
Ben

Arun.Immanuel30-Apr-07 5:07

Arun.Immanuel

30-Apr-07 5:07

Or sort based on len(Progress) bcos it has the least length.

Regards,
Arun Kumar.A

Dave Kreskowiak30-Apr-07 9:06

30-Apr-07 9:06

That's a really bad idea. I'd fire you if you wrote code like that.

What if the status enums change? How about localization changes in the text of the enums??

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Arun.Immanuel30-Apr-07 9:40

Arun.Immanuel

30-Apr-07 9:40

Sorry , I didn't think on these effects.

Anyway, thank U very much.

Regards,
Arun Kumar.A