Forms :: VS2010 WinForms App Connect To Dll On Webserver?
Nov 13, 2011
I have a desktop WinForms app that I would like to be able to connect to my Sql Server database that I have through my GoDaddy webhost. Problem is not all ISP's forward the 1433 port (like mine) so I can't connect directly to the DB from any of my home computers without buying the expensive dedicated IP address package, which has me thinking since my website can connect directly to the DB I was wondering if it might be possible for me to make a dll that would have all of the database interaction through subs and functions and all my WinForms app would have to do is connect to that dll through http or something, anyone know if I could do something along those lines?
Reason for this is I would like other people to be able to connect to this database (the winforms app would have screens for creating and managing accounts, etc) without worrying about whether their ISP would block the DB port(s) it would just work.
I have a desktop WinForms app that I would like to be able to connect to my Sql Server database that I have through my GoDaddy webhost. Problem is not all ISP's forward the 1433 port (like mine) so I can't connect directly to the DB from any of my home computers without buying the expensive dedicated IP address package, which has me thinking since my website can connect directly to the DB I was wondering if it might be possible for me to make a dll that would have all of the database interaction through subs and functions and all my WinForms app would have to do is connect to that dll through http or something, anyone know if I could do something along those lines?
I have a label that displays text kinda like a title to something (autosize = falseTextAlignment = MiddleCenter) and whenever the label control isn't wide enough to display the single line of text it tries to auto-wrap it causing half of the text to be chopped off at the top and half of it chopped off at the bottom. I would rather it stay on a single line and cut the text off from the right
i am trying to redistribute my app that uses Oracle 11g:
Imports Oracle.DataAccess.Client
The problem i am having is that it will not run on a machine that doesnt seem to have the correct drivers that its looking for. When i install ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio on the test VM it works just fine but thats a 230+mb file to download and install! Not to mention that if the user already has Oracle 10/11g on their machine that it may mess up their current connections/etc by installing that setup file.Is there another setup package that i can install that only has the Oracle Data Provider for .NET 2.0 11.2.0.2.0 or whatever its needing from that ODAC 11.2 Release 3 file.
I am using Server Explorer in VS2010 to connect to an Access 2007 .accdb database. I started getting 'No error message available, result code:E_UNEXPECTED (0x8000FFFF). However, my program runs from Debug and accesses the data.My connection string is Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:MypathDatabase1.accdb. I exited my project and created a new project and tried to add a connection. I could not connect to Access 2007 or Access 2003 databases (.mdb).I had to exit VS2010 and start it again before it started working again.
We've recently upgraded from VS2008 to VS2010. The conversion of our vb.net Windows Forms app went well, but we're now having big problems with the forms designer.retty much any change to the layout of a form (sometimes just a solution rebuild) will work once, but on recompile, the IDE designer refuses to display the form, the error message being a null-reference exception (with no details as to what).Closing and restarting VS2010 will cure it, but only for one compile cycle - and it's obviously not practical to close and reopen every time. Closing and reopening the form does not fix it.
I've been trying to know how to delete all the cookies of a domain, created by using the WebBrowser control.I know that to invalidate a cookie, it's necesary to set its expiration date in a point of the past (a negative value), but all the information I found is for web developing aplications, and I'm using a form.
I am currently helping to write a Visual Basics program that was originally writing with access.The Original Access program has been used and modified over the past 5 years, During that time the database has gotten pretty big.The problem I am having is If I add the entire database to my data sources it creates data tables for every Table and Stored procedure even when they are not currently used in the program resulting in a 20+ minute build time just to debug.I am currently only adding Tables and Stored Procedures as i need them, so its not that much of a problem now, but as I continue to work and add tables the build time is going to go back up, and Id hate to have to wait 20+ minutes to test a small tweak I made.
If I create a new class library project in VB.NET, I can create subfolders (a la C#), add WinForm objects to these subfolders, and then specify a namespace:
Namespace Sub1.Sub2 Public Class SomeForm Public Sub New() InitializeComponent()
[code]...
This resolves as ProjectRootNamespace.Sub1.Sub2.SomeForm, which is good.However, if I create a new WinForms project in VB.NET, and attempt the same thing, I get this error in the designer:The class SomeForm can be designed, but is not the first class in the file. Visual Studio requires that designers use the first class in the file. Move the class code so that it is the first class in the file and try loading the designer again.Is there a way to have forms in sub-namespaces of a VB.NET WinForms app instead of in the root namespace?
I would like to open a new form from some other form, and pass some selected object from a control on that form to the new form. The sensible way to do this, I thought, was as a parameter to the forms constructor. Now I know that the visual studio GUI creates partial classes for my forms, that hold the properties that I can drag onto there in the designer. I assume it also holds a default constructor. Since it might do all sorts of stuff that is needed to initialise the form, I figured I should call it from my custom constructor ala
public sub new(byval my_parameter as Foo) Me.new() Me.my_parameter = my_parameter
[code].....
That clearly wasn't it, because it can't find a default constructor. The thing is, visual studio goes trough great lengths to prevent me from seeing the generated constructor, so I know how to access it. This leads me to believe that I am actually doing it wrong, and should have set out on some different path, as the path you are forced in to usually is the sensible thing to do, which I usualy find out way too late.
Is it better to use friend or public forms in vb.net? What are the advantages of each?I notice when you import a vb6 project, the forms come in as friend, but when you add a new form in vb.net it is public. I have not seen any difference in the way they work, though, so I must be missing something.
I have a very simple windows forms setup. Form1 has a progress bar and a button on it, when clicked the button opens Form2 which also has a button on it that launches Form3. On Form3 is a button which I want to use to raise an event back to Form1.To achieve this can I add an event handler on form1 that will listen for an event of the type raised in form3? Or do I have to pass references to form1 to form2 and then from form2 to form3?
In the middle of converting VB6 code to VB.NET, I need to replace the following code that intends to close all open forms remaining in the application.
'close all sub forms For i = My.Application.OpenForms.Count - 1 To 1 Step -1[code].....
I've replaced the Unload function with Close (as indicated by TFM), but the compiler complains that OpenForms is not a member of My.Application.Where can I access the open forms?
I am retrofitting unit testing into a fairly complex system designed and written by other developers in VB.net. I am trying to develop unit tests for the GUI forms using NUnit and the NUnit Forms extension. (I've been looking at c# examples that are fairly easy to port over if you have a solution but don't know VB syntax as long as it uses NUnit classes)
I will try and explain what I am doing but first a brief description of the program. It basically monitors server activity. You need to connect to a server via a modal form with IP and Port fields(amongst others). Once you have connected to a server other parts of the program unlock and become usable (such as configuration of the server).
Desired process: Load program > click connect button > modal connect form loads > enter details > click OK to connect > main form updates to logged-in state > other functionality
The problem is that I cannot test the functionality of the connect form and then the logged-in functionality of the program. I can test that it loads the modal connect form correctly; enters the details and clicks OK (all fine so-far) but it does not appear to logically progress the program. The modal form just closes again seemingly without running the connect code from the program back-end and I'm back at the main menu not logged in to anything.
I have a feeling that I've either missed something really obvious or that it's simply not doable in NUnit.I have trawled the internet in search of anything similar but the closest was another SO thread that was really generic. Without being able to actually test the logged-in version of the program, I'm at a major hurdle.Another issue is handling message boxes that don't have unique identifiers (e.g. "are you sure you want to exit?"); these also seem to be a major pain in the arse with NUnit (If it makes any difference, I'm running the tests as a stand-alone project using a reference to the executable file of the built project, not the actual source)
I am deploying a VB.net 2010 winforms application, and when I install it on the client's machine, the install process also installs an instance of SQL Server 2005 Express. The application connects to a central SQL database on the server. To install, I am using the "Publish" option in VS 2010. Why does it do that? There should be no need for a local instance of SQL Express. Is there a way to avoid installing SQL 2005 Express (I know it is free, but I would rather not have it installed if possible).
I am retrofitting unit testing into a fairly complex system designed and written by other developers in VB.net. I am trying to develop unit tests for the GUI forms using NUnit and the NUnit Forms extension. (I've been looking at c# examples that are fairly easy to port over if you have a solution but don't know VB syntax as long as it uses NUnit classes)I will try and explain what I am doing but first a brief description of the program. It basically monitors server activity. You need to connect to a server via a modal form with IP and Port fields(amongst others). Once you have connected to a server other parts of the program unlock and become usable (such as configuration of the server).Desired process: Load program > click connect button > modal connect form loads > enter details > click OK to connect > main form updates to logged-in state > other functionality
The problem is that I cannot test the functionality of the connect form and then the logged-in functionality of the program. I can test that it loads the modal connect form correctly; enters the details and clicks OK (all fine so-far) but it does not appear to logically progress the program. The modal form just closes again seemingly without running the connect code from the program back-end and I'm back at the main menu not logged in to anything. I have a feeling that I've either missed something really obvious or that it's simply not doable in NUnit. I have trawled the internet in search of anything similar but the closest was another SO thread that was really generic. Without being able to actually test the logged-in version of the program, I'm at a major hurdle.Another issue is handling message boxes that don't have unique identifiers (e.g. "are you sure you want to exit?"); these also seem to be a major pain in the arse with NUnit(If it makes any difference, I'm running the tests as a stand-alone project using a reference to the executable file of the built project, not the actual source)
I'm using the following code to validate the text entered by user. It works perfectly fine. But I want to add the backspace feature so as to allow the user to delete the wrongly entered number.I have tried a couple of things and they worked but before last digit (after the decimal point) i.e. it does not allows to delete after the number has been completely entered.number is being entered in the format: 12313213.45
What shall I do?Private Sub TextBox5_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox5.KeyPress
is it a bad idea to create separate parts/winforms of the same application (using the same SQL Server DB) in different executable files. For example for a School IS: A Receptionist App, A Teacher App, A Principal App and so on.
I am writing an application in which a user is doing a file conversion. I have a set of tools that can perform the conversion on the fly via command line, but I'm not entirely sure of how to go about passing the parameters I need to the command line and running them. Can someone point me to the right direction?Would I just create a System.Diagnostics.Process and use that? If so how do I do the line by line command? For instance if I need to issue a cd command to change the directory and then execute a command after that how would I do that?
In C# Windows Forms, a user control's InitializeComponent is called from the form's/control's constructor. When I create same scenario in VB.NET I don't get a constructor, and I can't locate a place where InitializeComponent is called.I need to call my code between InitializeComponent and when the control's Load event is raised, preferably still in the control's constructor. How do I do this in VB.NET?
I'm new to the forum and very new to visual basic, and my knowledge base and experience with visual basic is very limited. I'm taking a class and working on my final project. For this project I am to create several forms such as a form where the end user would select a general item types to buy such as a shirt of running shoes, on the next form they would choose a specific shirt or running shoe, and the last form would be a totals form where there is to be sales tax added to each item purchased on the previous screens. The following are my issues:
-Should I keep all the forms under one Project with one Solution page i.e. all encompassed under the one overall project design titled something like Running Store Project, if so how can I add an additional forms to an existing project? Or should I start a new Project w/a new Solutions page for each individual form and then link them together in some fashion? I know just a little tiny bit of what I should do when linking the forms together, I believe I need to choose true or false under view in the properties window, but I don't remember where that is on the properties page and don't know if that is actually correct.
-Also, (and this question might be taken care of w/the previous question), how can I get the taxation amount to be coded for each item purchased? Is there a way to link up the controls in one form to the controls in another form? I assume there has to be a way to do this or it wouldn't make any sense, the info labeled in the controls must be able to flow from one form to another or this wouldn't work anywhere.
So, as you can tell I'm pretty lost on this whole thing, and on this assignment my instructor has asked that no one ask him any questions, unfortunately this is the first assignment where it has been necessary to link individual forms together. I have about 3wks to complete this project and am trying to get it started early enough that it won't be too stressful to complete.
I have 2 forms (Form1, Form2). Form1 seems to recognize Form2 with no additional coding. From Form1 I can load a Combo Box in Form2 with a button and this code;
Form2.CBequations.Items.Add(txtVariable.Text)
txtVariable being a textbox in Form1 and CBequations being the combobox in Form2.But from Form2 I cannot do the same to Form1. It says "Name 'Form1' is not declared." Form2 doesn't recognize Form1 orany of the objects on Form1.
I have made a vb.net application which has 63 forms. On each form label2 should contain the username using the application. The first form displayed to the user is the login form. When the user clicks the login button on this form the user name in all newly opened windows should appear inside label2. How can I do this?
I have a Windows Forms app that, unfortunately, must make calls to controls from a second thread. I've been using the thread-safe pattern described on the [URL].. Which has worked great in the past.
The specific problem I am having now: I have a WebBrowser control and I'm attempting to invoke the WebBrowser.Navigate() method using this Thread-Safe pattern and as a result I am getting StackOverflow exceptions. Here is the Thread-Safe Navigate method I've written.
I have a grid containing rows flagged with different priorities. I want to color the high priority rows red, low ones blue, etc. I'd like to set the shade based on a mathmatically calculated gradient rather than arbitrarily assigning colors to specific priorities. How can I extract a single color from a single point along gradient?
how to create forms and connect them to a database etc. When you see some applications for using databases you dont just get the form in the middle of the screen you get a sort of form inside a surrounding platform. A bit like running Access DB inside the runtime environment.How do I do this in VB Express?
I have pairs of controls: immagebox + textbox = one pair.I want these to show up in a single column grid/tabular format.Each cell contains one image/text pair.I want this grid to scroll because the number of pairs is dynamic depending on a user selection.I suppose I will be adding these controls in code at runtime when the user makes his/her selection.
