|
Once you give the SELECT command to the DataAdapter, you can use an OleDbCommandBuilder[^] class to automatically generate the INSERT, DELETE, and UPDATE sql commands for the DataAdapter. These are all necessary if you want to do anyn updating of the database from the DataSet/DataTable you filled with the Adapter.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Yes I did. I created the Dataset and then I drug the needed tables to the designer.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Thank you Dave...
Makarand More
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
can some one tell me on using Biz talk server for .Net application.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Or sort based on len(Progress) bcos it has the least length.
Regards,
Arun Kumar.A
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
