I have a connectionstring in MySettings which all my datasets use. The project has three copies of the same database: LIVE, WHATIF and TEST. I need to have a dialog in my startup that asks the user which db they want to use and then I thought I could amend MySettings.Connection string dynamically. Hey-ho it's read-only! Is there any other approach I can use where I change a connection string once and all my datasets will then point to the selected db?
What is the best way to easily switch from a test database to a production database in vb.net and MySql, when all MySql connection strings are currently hard coded?
I'm writing a flash cards program to help myself and others study. When the user presses the "New Card" button, I've been able to make it create the new card and jump to edit it, but the dataset/binding source/table adapter is not switching with it, so when you deselect the text box, it switches back to whatever was selected before the new card was made.[code]
Most of my project started out using Access databases, but now I want to swap them out for the SQL versions. One example would be this:
DEMOGRAPHICSTableAdapter.FillByCount(EyeBaseDataSet.DEMOGRAPHICS) SPat = EyeBaseDataSetSQL.DEMOGRAPHICS.Patient_NumberColumn.Ordinal 'TODO: This line of code loads data into the 'EyeBaseDataSet.History' table. You can move,
I am using vb.net and SQL server 2005 I have a project with database classes which are generated from database objects. That is I add a dataset to the project and drag and drop a database object onto it. The problem with this is that I have to give a connectionstring which is stored in the code. This is ok while developing the application. But runtime I want to use another connectionstring, both for security reasons and because each user of the application will correspond to a database user (SQL) and shall have a corresponding connectionstring. Is there an easy way to do this without having to restore to plain all datasets and do everything myself?
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
c: Documents and Settings [Local Settings] Application Data\
Is possible to change this path? For example, in my case I save app data in "ProgramData" folder (Vista & W7) and I would like save this config file in the same folder.
Private Sub SaveButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SaveButton.Click Dim Config As Configuration Dim Section As ConnectionStringsSection
I want to store a 2-dimensional array with 5 columns and indefinite rows in My.MySettings. I've tried to use a Class with an item list (list(of T)) but also a StringCollection.
I've been tortured with this question for few days. As I understood, you could put some of form's properties to mysettings, actually binding them with some named values as strings.It's not very hard, and it was well documented. I tried it and it works fine.Only, not all properties are offered to be bound with mysettings, only some of them. For example, you could bind starting position and windowstate, close your application, and when you open it again, it will open the same window on the same place on the
Well currently I'm needing to store various settings, strings, integers, items, etc, within the program settings. So far this has gone without a snag and is working as planned except for one thing, Comboboxes. I have browsed through the various types of settings I can save to and the closest is a "System.Collection.Specialized.StringCollection", however VB is throwing up an error saying that:
Quote:
Error1Value of type 'System.Windows.Forms.ComboBox.ObjectCollection' cannot be converted to 'System.Collections.Specialized.StringCollection'.C:UsersUserAppDataLocalTemporary ProjectsProjectForm1.vb1234Project
How would I go about saving the items in a Combobox?
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
It appears that when you access My.Settings.Default in VB.NET, your thread's CurrentPrincipal changes. Consider the following code.
[Code]...
Is this expected? Is it documented anywhere? I couldn't find any references to it.It also seems to only do this the first time My.MySettings.Default is accessed, which means that a workaround might be to touch the property to initialize it before attempting to set the thread's CurrentPrincipal. Would there be any undesirable side effects to doing that?
I'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
I am trying to copy a table in a database into another database on another connection in VB.NET, using OleDb. If they were on the same connection I would just use SELECT INTO, but they are not. I have two different OleDbConnection and cannot see an easy way to do this.
Right now I am attempting to just copy the database into a DataTable using an OleDbDataAdapter, and then loop through the DataTable and insert every record into the target database one at a time. This obviously takes a ton of time for the large DB I could potentially be dealing with, and I have to deal with escaping strings, null values, etc.
edit - just to make this more clear: I have two OleDbConnection objects, one is linked directly to a local .mdb file on my computer (JET). The other is linked to a database on our servers (SQLOLEDB). I am wanting to do this:
"SELECT * FROM fromDB INTO toDB"
But I can't because fromDB and toDB are on different connections, and the OleDbCommand object is only attached to one. The only way I can see how to do this is to connect to fromDB, copy it into a DataTable, connect to toDB, and copy all of the data in the DataTable row by row into toDB. I was wondering if there is an easier way to do this.
Is there a way to write an application in VB.NET that will create a Compact 3.5 database on my desktop and then fill it with data from a SQL 2000 database?
Private Sub Add_Click Dim tbox As New TextBox tbox.Location = New Point(12, 244)
[Code]...
I added a textbox dynamically during runtime. How will I add the text in the textbox to my database? The name property of the textbox cant be change. What is the name property of the texbox created during runtime?
As a bonus to the project I'm currently working on, the people would like it if I could change the background color of individual table cells depending on what their value is. So in the RadGrid_ItemDataBound event handler I have, I'm trying to set the BackColor of the cell if the cell's text equals a certain value from a dataset in my database. My current code is like so:
I am creating an information access system. Here the notifications created by the admin will be visible to the user through a visual basic form and sql database. I need a maximum of 20 notifications and the last created notification should appear at the top in the form. Also when the 21st notification is created it should automatically delete the 1st and so on.
I'm trying to generate a query dynamically using textbox values from my Bookings form to update only those values that were entered by the user.[code]...
With the following example of code, whenever the user clicks a menu item it will load up a new form. This form will then read from a database, and create text boxes throughout.
Private Sub allowances_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If mainMenu.currentSlic.ToString = "0" Then
I am working on a CMS system for my business, and need to be able to generate notifications dynamically into a control panel. Please note, I am using .NET 2.0, coding with VB and my data is all held on a MySQL database.This is pretty simple for most aspects, but as the whole thing is dynamic some things are proving more difficult.I have a set of tags which are dynamically generated with a repeater as follows:
<asp:Repeater runat="server" ID="locationRepeater"> <ItemTemplate> <p id='locationNotification' title="<%# Container.DataItem %>" runat='server'> COUNT DATA NEEDS TO GO HERE </p>
[Code]...
The data is really, really, simple, all I need to be able to do is query a table on my MySQL database for COUNT of ID WHERE locationName = Container.DataItem during each loop of the repeater... but I don't know how to do this.I'm thinking maybe I have to do this first, create a table in memory somehow, but I am afraid I have no idea how to achieve this.
Has anyone got any examples of a similar thing, it's kind of binding to a repeater from two datasources... each task is very simple, but I don't know how to put it all together!