Switch From ADO To ADO.NET - Regards To Data Access When It Comes To Windows Forms Applications
Jul 21, 2009
I have some friends who are 'old-school' VB6 database developers and I was telling them about .NET and its features, specifically ADO.NET. In our conversation, they brought up the following reasons why they would rather stick with ADO than move to ADO.NET: The Dataset is disconnected (What if power fails?)
The same amount of code still has to be written The new options of Dataset, BindingSource and TableAdapter seem confusing the same code is written programatically access the Database, all that changes is how that command is laid out. Why ADO.NET is 'better' than ADO with regards to data access when it comes to Windows Forms applications. What does ADO.NET provide that ADO does not? What does it do better than ADO? I'd like examples that do not involve LINQ.
I'm running into some strange exceptions coming from a few workstations that are running one of our Windows Forms Applications. The application is written for .NET Framework 2.0 and coded in VB.NET. We've re-imaged the machines a couple of time but not matter what we do, the same problem occurs. We are not seeing this problem with any other machines besides these two. Below is the exception message and the Stack Trace. Can anyone provide any insight as to why this may be happening?
I need to assign code to a button, that when clicked on, validates an ISBN code, and displays a message that it is either Valid or Invalid. I basically need help transforming code used in a console application that will now be used in a windows form application, so no more writeline stuff, now message boxes. [code]
I am needing to be able to access excel and adobe acrobat menu items and popup Windows (mostly acrobat). Is there a way to do this besides using mouse clicks and sending key strokes (come on, this aint applescript). There are some menu actions I need to automate and I need to be able to discover if a window did open and if so I need to do things in it.
I may be the only person still automating excel this way and I am looking at doing it in ways that better handle COM objects and such, but for now I just importMicrosoft.Office.Interop.Excel and go for it. Something that gave me a lot of grief at first was hanging excel.exe processes, but there are tons of resources online for fixing that. At this point I am pretty confident in my abilities to handle it.One thing I did notice and was wondering about is how does closing a windows forms application interact with excel.exe running in the background and likely more specifically the garbage collector. I have written quite a few excel automation projects and noticed that after I run my program .exe and it has completed there is an excel.exe process that hangs on until I close the pop up window from the windows forms application. Why is that happening?
I need to get a button to enter the applications subfolder and randomly select 1 file to be played in the windows media player COM which i have put in the form. I have tried creating a shuffling playlist but i cant get it to stop after one file is played (it just goes on shuffeling to another file, and i really do not want a playlist). I manage to create a batch file to be started to randomly pick a file in that folder, but when i do this the file is being played in the systems default player..
I am using Visual Studio 2010. I have a Splash Screen which starts first (Everything is running smoothly there). Then it Opens Dialog1. My user is required to check 5 boxes (2,3,4,5,6) (1 has been deleted). I used this Code :
If CheckBox2.Checked And CheckBox3.Checked And
[code].....
I've been experimenting for an 1 hour. The code didn't show errors. I tested it and it didn't work. Then I found out that I was working on Dialog 2 in Dialog 1 code. So I tried another thing and that didn't work because I can't put Dialog2 code in Dialog1 code.
I always get an exception when I try to switch between different forms in my program. Here is the exception message:
Control.Invoke must be used to interact with controls created on a separate thread
I have attached the forms to very nice variables and this problem occurs when I try to use command like MyForm.Show().
It does not happen when the forms are not attached to variables, but then I have collosal problems with refreshing the textboxes and stuff.
edit;
I have 4 different forms. When I load the main module and main form, in the Sub (...) Handles MyBase.Load I execute the following code:
In module:
Public StartupForm As frmStartup Public RegularForm As frmRegularUse Public LoginForm As frmLogin
[Code]....
This is the aproach I worked out to get the full control over refreshing the forms. It is a program for Motorola Scanner with Windows CE. Now, for example, when I enter the correct password in LoginForm, I want to switch to the RegularForm. When I try to use RegularForm.Show() or RegularForm.ShowDialog or RegularForm.BringToFront(), I get an exception. When I try to call the form with the frmRegularUse.Show() I can call the form, but it is being created in a different thread, I believe, so I loose control over it (when I try to put something from the keyboard, there is no response).
I've run into an issue with Access Key in either Visual Basic or C#... also happens whether on my windows 7 64 but laptop or my Windows Vista 32 bit laptop - in Visual Studio 2010 professional... I create an Access Key (for example E&xit)... while the underline under the x shows up in the development area, it does NOT show up when I run the application NOR does it work... for example, press alt-x does not run the code associated with the exit (nor does a break into that code show it gets into that code).When I try it in a menu, it is a little different at first the underline under the access key does not show up but then after I access something by hand, it sometimes shows up and is usable.
I' am trying to access to sqldatabe in order to programming data directy without control at this moment. At awinforms forms aplication with visual basic 2010.the Sqldatabase is local and I was trying with dataview but I feel not good, because didn'taccess successful at all
I've seen quite a few posts regarding changing cultures, localize cultures, etc... but I couldn't care less about all that auto-stuff.I'm developing this GUI to connect with one of our production machines that will be used by the ppl who will be servicing the machines. Which might well be anywhere around Europe and soon enough Japan and US. Therefore, it was asked already to have language options, cause the guy servicing is likely to be a local.
As I said, auto-stuff doesn't bother me, all I want is the option to go to File -> Preferences and change a drop-down box to whatever language the person fancy and put a My.Settings.Save() I'm planning to create a few simple xml files called "en", "fr", "sp", etc which will be something like: <Frm_Main.Label1>Text of the label</Frm_Main.Label1> The actual problem is: I know the coded strings will have to be manually set, but: Is there a way to cycle through all the UI items (labels, toolstripmenu, buttons, group boxes) to set those .text ?? I'm trying stuff like
I might be going about this the wrong way, but I'm trying to create a form that will include a single button, for instance "Enter". When "Enter" is clicked, I want the form to then display the contents of form 2, which might include more buttons and/or a textbox, etc. I want to do all this without ever opening or closing a form.
In my project I have 3 different forms. They all have the same design layout so the only different you see is where the text boxes and buttons are placed. Right now I have 3 buttons at the top of each form that Im using to switch between the forms
[Code]...
I know there is probably a much better way of doing this, and faster. I dont' like the delay between each window showing/hiding. what options do I have to make this run better? Since I have the same design background is there I way I can just hide and show just the controls instead of showing/hiding the entire window?
Would I be correct in assuming that this is the best way to go? (I don't want lots of popup forms in the program, looking for the most streamlined way to go).
Also, if this is the correct way to go how would I go about hiding each panel in the IDE so that I can work on each one seperately using the designer view?
Here is the best example application I can think to use: [URL] Each of the tabs (Proxies, Harvester etc) has an image as the tab (Which I can't find an option to do with TabControl and then displays the container / panel below it
I am working on moving applications from Windows 2000 to new server Windows 2003 R2(64 Bit). I noticed that there are some VB programs and config files for those programs have been placed in Windows 2000 Registry. Some other applications are using them from different servers.Why do we use registry here? How can i move these to registry in windows 2003? Can I just move these or do I have to write VB programs to place them in 2003 registry?
I've got a dictionary<string,string> that I need to access and use on several windows forms. In asp.net, I could store it in Session and use it from any aspx page. How would I do this in forms?
When a messagebox pops up, how can I bring a form infront of the messagebox (or switch betwen different forms) and then bring the messagebox back again again if I want to click OK button to proceed with the remaining code?
I am using VB 2008 & Access 2007 for windows forms application having typed datasets while creating connection to DB vb asks to store connection string so i did it now that i want to know where is the actual path of file where these connection strings are stored. b'cas after runnig a macro in Access Database i lost all these connections from Data Source Configuration Wizard Combo Box & also i am anable to create a new connection to Databases.I have tried to reinstall the entire Visual Studio couple of times .
I have a desktop (XP) application and a CE app (Motorola MC9090) and I want to Scan few Barcodes with Motorola and then send the text to the application on PC using WiFi. I have no idea how to do it - (VB.NET preferred)
Is there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form. I also have the same problem for a Microsoft Access protected file.
Basically what I want to do is create a program that every now and then (maybe 10 minutes) switches between either, all the windows currently open, or a selection of all the windows currently open, then checks the colour of a location on the screen. At the moment I have the program checking the colour at a specific coordinate, so that's all good. The problem I have now is how to switch between windows.
I've thought up a few ways to do this. The windows that I care about checking all have the same name, the same process class, but different process IDs. I already managed to stick all the process IDs into an array of integers hoping that I could use them but I don't have a clue how to bring a window to front using just the process ID. So the first method would work if I could figure out a way to do that.
My second idea, which is a pretty rubbish way of doing it, would be to simply simulate pressing Alt+Tab however many times to change between windows.
I have to forms, form1 and form 2. On form1 I have datagridview with all the fields in it. If I double click on it I would like a new form to open where I can add a new record.
Then I have a edit button on the form, If I click the edit button I would like another form to open where I can edit the data in.
In this post it explains it, I need the same but for linq to sql.
I'm developing a windows forms application using VB.NET. I'm currently working on DataReport (by Microsoft, not Crystal). Everything works fine when using DataSet as DataSource. But I have a question on how am I going to put data to my DataReport from a user input? Preferably when the user is on the act of printing(clicking the print button in the ReportViewer), a Form will pop-up and ask him for input. That input I'm talking about is random names of people, and we don't have to track their names so there's no reason to put it on the database.
