Needing pointed in the right direction. I am fooling around with data sources and connections per homework and what I'm looking for is creating an SQL DB connection during runtime. I know that you can add a data source in design by going through the Wizard but what if one would want to create the connection, adapter, and dataset during runtime? Where would you start?
I have cruzed the net looking for some form of a tutorial to just get me started, I don't need it all completely outlined but I need to know where and how to start and what I need to declare the connection, string, and dataset as. I have seen a lot of information using VB6 but nothing that I come across seems to work.
My basic questions are:Do I have to create a seperate class for the database connection?How do I delcare the nuts and bolts of the connection,adapter, and dataset?If a seperate class isn't required then where is the most realistic place these items would be created?
I'm writing a Windows form application. I created a SQL database called myDB.mdf. The database/form connection was created using the wizard provided by VS2008. The connection string, table adapter, dataset, etc were all generated automatically. In runtime, I copied the database to several folders and I want to the application to connect to them one by one and do some data manipulation.
Here below are the relevant code I'm using:
Namespace My Partial Friend NotInheritable Class MySettings Public WriteOnly Property RunTimeConnectionString() As String
I'm writing a windows form application using vs2008. I need to connect to different SQL server express database files during runtime. There is a "how to do" video showing a technique for this
[Code]...
and then in the Form1_load sub and before calling the data adapter to fill data, insert codes below:
Dim strConnectingSting = NewConnectionString My.Settings.RunTimeConnectionString = strConnectingSting
The method works but only for the first database. I found once adapter.fill is called and the connection to a database is established, the connection can't be changed.To do what I want, I have to create a startup project to call my main project. When I want to change connection, close the main project and start again.
I have read through some other post and haven't been able to find an exact answer that I am looking for. I have a connection string saved in my.settings that I am using. My database is residing on a server. Now I am going to have to install this application at more then one area and they will have the database on their server. What I am wanting to do is for the application when it is loading to search the network to find the database and return the connection string without the user having to do anything. I know with a web application you can search the machine you are on for the connection string without knowing its location but was hoping there was some feature like that to search the network to find it.
How can you add a system DSN with its security credentials programmatically at runtime from VB.NET? Keeping key in ODBC.INI is done, but when creating ODBC, it asks for Authentication Type (SQL or Network Login).How can we set that option at runtime?
I'm trying to make labels at runtime. The idea is to create them on the fly in runtime.
I have this on my form:
btnAdd txtName txtAge
[Code]....
Which work fine, but if I want to create another label, how do I check to see if one or more labels have already been created and then apply a new location of the new label? (so it doesn't get override on the same location on the form?)
Im creating a fairly simple game, and when the left key is pressed i need a new picturebox to be created.Heres the code Private Sub frmMain_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
[Code]...
Now there are no errors in the code apparently, but when the left key is pressed, the picture box isnt appearing. I added the "lblAnswer1.visible = false" just to test the keydown functionality, and that works.
im doing a project in which im basically trying to make an etch-a-sketch style program.
I am using a 5x5 pixel picture box as the 'cursor' and have made the program so that i can move the picture box with the arrow keys. I am currently trying to work out how to make a trail of identical picture boxes (from an array of picture boxes) appear wherever the cursor has been using this code
Case Keys.Left CurrentLoc = New Point(PictureBox1.Location.X, PictureBox1.Location.Y) If Not PictureBox1.Location.X - 5 < 0 Then
[Code]....
Basically, im trying to make a trail by moving the original picturebox and the inserting an identical picturebox in the original's previous position. However, the new identical ones do not display
I'm sorry but Microsoft did not think about this very well. I have used the dataset wizard to connect to my sql server and the connection string was placed in the app.config file. The only problem with this is that you can not write to it nor change string at runtime. So I need a way for each one of my users to specify their connection either during installation or after installation. I would appreciate any help in this matter.
I am having some problems adding controls at runtime, or I guess I should say accessing the controls after adding them.The application starts off with a tab control named "tabIncidents" and one tab for an incident information. The user can click on a button to add a client. When the button is pressed a second tab is added to "tabIncidents" named "Clients." On the newly created "Clients" tab another tabcontrol is added named "tabClients" and we create a tab named "Client". Multiple "Client" tabs can be created on this tabcontrol. Each "Client" tab gets a usercontrol added named "clientInformation" which has name and address textboxes.
So basically it is ...
TabIncidents.tabFirstTab (already exists) TabIncidents.Clients (new tab added at runtime if user clicks a button) TabIncidents.Clients.tabClients (new tabcontrol on the new tab)
Problem: Need to get a picturebox to display four images, one after each other. But in a way in which during runtime the changes can be seen.
So I figured if after every image is changed for example if I had some sort of timer, then during runtime the image will be shown, then after a certain period the next one would be shown and etc. I tried doing this using a timer and then a stopwatch but both time's no change can be seen in runtime and there is a small wait before the last image comes up.
I then also, tried using sleep, but that also showed no changes. Underneath is a quick piece of coding of what I'm trying to achieve, but instead of textboxs, for the sake of what I'm trying to do I will be using pictureboxs.
CODE:
Question: I've tried all I know in regards to timers and so on with no luck.
I want to create a Panel dynamically on the form when a button is clicked. Also labels with given TEXT are also to be created when create label button is clicked. then we should be able to print the form contents as it appears but without any buttons. We should be able to resize the panel to adjust the page size.
info on creating instances of my own class at runtime. Simple project for family recipes but would like the option to add new recipes with new instances of my own food Item class at runtime. Creating my own class,no problem. Storing the data in an XML file, OK on that as well. My issue is creating new instances of different food item class as I use this program over time
I know how to create a control at runtime e.g.[code]Can anyone tell me how to create multiple instances using a for-next loop? e.g.[code]The part I can't work out is how to give each new button a new name... like button1, button2 etc
I'm an absolute nebwie, trying to create a program for at work. It is supposed to become a logging program to log certain events. These events have to be recorded in input fields.
I want to create files based on the particular value of supplied recordset using the StreamWriter at RunTime. The files will be dynamic these will be create based on particular field.Example: If I have list of employees, I don't know from which city of the country they came from. I want to create a different files for every city and write those employees in to the corresponding files at runtime.
For some reason the Webbrowser document complete sub will not work. I even tried Public wb as New webbrowser. I will be disposing on the WB many times while the app is running. I need to be able to recreate it so that it continues to work with the WB document complete sub to trigger events...
Is there a way to dynamically create an object at runtime?Background: Basically i have an employee class that i want to instantiate every time an employee logs in. What i don't want it to have an employee object already created for every employee, but when they log in the object gets created.
I am working on getting ready to make a chat client. I want to be able to click a button and a new form come up as a tutorial to myself. Here is the code I am currently using.
I need to be able to change the connection string of a strongly typed dataset at runtime. I have gone into the settings.vb page and written this code:
Namespace My 'This class allows you to handle specific events on the settings class: ' The SettingChanging event is raised before a setting's value is changed. ' The PropertyChanged event is raised after a setting's value is changed. ' The SettingsLoaded event is raised after the setting values are loaded. ' The SettingsSaving event is raised before the setting values are saved. [Code] .....
The way the code is suppose to work is that when a user logs in, the application gets the user's site ID (gvUserSite), then uses that to set the connection string. But when I log on with a SiteID of "21" it always uses the Case Else value. Also when I set breakpoints in settings.vb the application never stops on the breakpoints I set during runtime. As if the breakpoints were never set. Also if I put any code in the "MySettings_SettingChanging" in settings.vb I get a runtime error "The debugger cannot continue running the process. Process was terminated.
I've created two forms of which two separate datasets/tableadapters were created by adding a datasource and dragging and dropping the fields onto my form.I was testing the program using a db that was located on my local drive. Well after publishing the app to the users machines, I noticed that the binded information was still being pulled from my local machine and not the database that the user is working off of.I've set the connection modifier properties for both tableadapters to Public, and I have written the following attempting to change the connection strings:
Private Sub btnSaveSettings_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveSettings.Click Dim pap As New frmPap My.Settings.dbLocation = txtSettings.Text
I need help creating bootstapper for crystal reports runtime..I want crystal reports runtime to be installed automatically with the application if its not installed on the target machine.I am using vs2010?
How Can I create Menus at run time? as MainMenu1 MainManu2 MainMenu3 SubMenu1 SubMenu1 SubMenu2 SubMenu2 ChildMenu1 SubMenu3 ChildMenu2 SubMenu4 SubMenu3 ChildMenu1 SubMenu4 ChildMenu2 SubMenu5 ChildMenu3 ChildMenuA ChildMenuB Etc.....
I am building a form that will eventually list a group of functions on the left. If you drag a function onto the form, it will create a listbox and a label at the loction you dropped it to. If you drag a function into a listbox, it will add that function as a listbox item. I have this working kind of. The problem is that once I create a new listbox, I am no longer able to add items to the previous ones. Here is my code:
Public Class Form1 Private MouseIsDown As Boolean = False 'rivate Functionlist As ListBox
