I am kind of an old 'newbee' at this, so bear with me for a moment. I am developing a windows forms application in Visual Studio 2010 Professional that connects to a remote database (MS sqlServer 2008 R2).To speed up development, I configured a DataSource and used the data objects associated with it. In VB6,
the data source could be assigned to the data objects during runtime using a variety of different runtime database connections, ODBC, ADO, ...
I have been unable to find a similar method with the VS2010 Visual Basic DataSource and underlying TableAdapter, BindingSource, BindingNavigator, down to the individual ComboBox and assorted other bound controls. It's convenient to have the integration, but I've got different users with different permissions, The long and short is that I'd like to be able to assign the data source during runtime operation, at least to the connection string level.
When I add a datasource via the wizard the connection string is either writen directly in the dataset.designer or there is a reference to the projects settings. Either way I am figuring out if I could change it dynamicaly when my app starts up ?
I'm trying to use an 'SQL Express' (or is it SQL Compact?) .MDF file as the datasource on a simple website using a Chart control.
Locally, it works great; but only if the 'AttachDbFilename' has the full path. Am I messing something up, or does it really need to be full path? If so - how do I accomplish this without using something like Server.MapPath()?
I know below code causes an error since "Property 'AAConnectionString ' is 'ReadOnly". What other choice do I have to assign a value for a user ID or a password with a value of textbox by coding?
I create project in my pc with vb.net and sql database when i tried to run this project to another pc there is error occurred that the connectionstring has not been initialized. I really troubled this from last one week to solve the problem. how to change the connectionstring on client pc at runtime or any other way to create a connectionstring that has auto detect in any pc where the program is installed.
Im writing a app using vb.net, which has multiple front ends e.g a windows service and a windows forms app. Ive got all my business logic and database stuff compiled into 1 project (producing a dll) then the different front ends as different projects calling the dll.
In the backend / dll project Im connecting to 2 databases using app.config to store the connection strings and DataSets / TableAdapters. This all works fine .... Until
When I deploy the windows app, it deploys the exe and the dll produced by the backend project. when its installed on a client PC, Im need to point the app at a different db server and therefore need to change the connectionstring, but its packaged up in the dll.
is there any way I can use a settings file within my windows app (therefore deployed with my windows app) where I can define the connectionstring, which onload gets passsed through into my dll, so the backend connects the correct database. I know how to pass standard settings through (strings etc) but the my.settings.connectionstrings seem to be readonly.
I have a gridview. Its datasource is set as follows.dtTable is a datable in which the values for the table will be retrieved. But when setting dtTable as datasource I get an error "Object reference not set to an instance of an object". What may be the reason for this?
My current problem is this:I have a form and I have in it three textboxes, 1 button and 1 datagridview; I also have an acceI'm learnig now on how to create a report without a database. But In how to set the datagriview as the datasource for my report
I want to maintain a list of potential ComboBox values over multiple executions of my program, and to use that list as the DataSource on multiple ComboBoxes. I also want changes made to the DataSource to propagate over all of the ComboBoxes already existing in the application.
Can someone recommend what type of object I should use as my DataSource, as My.Settings objects don't seem to support generic list objects.
Also, along with that recommendation, can I also ask for suggestions as to how to propagate the updates of the collection to all ComboBoxes? I would imagine I need a collection type which raises events when its contents change, but I can't think of any, and in any case do not know which are compatible with My.Settings.
The ListBox gets populated correctly. After it is populated, i have a CommandButton and on the click event of the button, i want to remove selected items from the ListBox. So in the click event of the CommandButton, i have written the following code:
lstItems.Items.Remove(lstItems.SelectedItem)
After selecting an item from the ListBox and when i click the CommandButton, i get an error as "Items collection cannot be modified when the DataSource property is set".
[code]My question is how can I remove xStopBits(0) before setting the DataSource?To get around this I currently have a check in the ComboBox1_SelectedIndexChanged event.
I have a datagridview that is populated using an oledbconnection:
Private Sub FileSpecs_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Settings.DBLocation & ";")Dim cmd As OleDbCommand = New OleDbCommand("SELECT specFieldno AS [Field No],specFieldName AS [Field Name], specFieldType FROM fileSpecs WHERE ClientNo='" & ClientSetup.clientNo.Text & "' AND direction=" & ClientSetup.fileDir, cn)
[Code]...
The problem I now face is that the 'index' value of the combobox item for each row is in the field specFieldType which is populated into the datagrid.I need to be able to set the value of the ComboBox for each row when the form is opened, and also be able to save the index value of each row selection if any changes are made/saved.
dbDataSet4 is a typed dataset. I want to learn how to use an Interface. The error message is suggesting using an IList. How would I do this. I'm having trouble finding good documentation on this.
I have to change my sql server and need to point all my crystal reports to that new server at runtime, some reports has StoredProcedures embeded inside and those are the problems.[code]....
I have a form where I have to use control arrays to create a multiple input form i.e. rather than processing one transaction at a time up to 16 transactions must be processed. The following really havent given me much problems at this moment labels and textboxes. I use a for construct to create all the controls including a combobox. This is where my question comes in this form combobox has to be linked to a table in a database. But furthermore and this is where it gets complicated for me anyway each seperate combobox must move independly if i select row 5 in the table in combobox 4 combobox 5 which is havent touched should still be on row 1. How do I accomplish this. I'm using a webservice. I have tried passing a loaded dataset . The code that loaded the dataset is as follows
Dim DSInfo As New Project1.localhost4.AccInfo DSInfo.Credentials = System.Net.CredentialCache.DefaultCredentials InformationData.Merge(DSInfo.GetBusinessJournals)
[Code].....
this code doesnt however provide a link to the table equallly creating a dataset in the combobox method ,loading it and then setting it as datasource also provides no link. I know i'm missing something.
Is it possible to create a new My.Setting item and value at runtime or does the setting already have to created? I'd like create new settings and delete settings.
I programatically / runtime created combobox and bind it to a datasource but can not set its default value. Since I am using the Handler of SelectedValueChanged, this is causing the program to mis-fire. Here is the code I am using.
Public WithEvents T_combo as ComboBox 'dictionary holds data to use in other parts of program Dim T_Dict As New Dictionary(Of String, String)
I've added some Labels to a form at runtime using this
vb.net Dim x As Integer = 25 For i As Integer = 1 To word.Length
[Code]....
Now, I would like to add text to one of them, but I'm not sure how. I thought by setting .Name I would simply be able to write something like lbl4.text ="A". But, of course, because the Label has not been created yet, this is not possible.
Also, I'm not even sure if .Name is working the way I think it is. I was hoping that it would name each Label consecutively: lbl1, lbl2, lbl3, lbl4...etc.
Am I naming the Labels properly? And how would I add text to one of these Labels?
I am developing a point of sale for a buddy.The system it will be on will be running nothing but this application. The system SHOULD always stay at 1024, 768 but i like to plan for problems.What I would like to do is on form_load change to 1024, 768. On exit, (for learning sake on my end) I would like to have it set back to the default.
Columns 0 & 1 are filled from a DataAdapter from Access Database and three are added. I had this working, but I changed it to check for the column "Feed" so I could add several Locations. At first this worked,but I did someething in perfecting it and it now fails after filling the first row of the datagridview (dgvFdMed).I ran a check and the table LotsTab has 8 rows filled. Column 1 & 2 are strings and the database appears they are fine. The added columns have just been created with no value. My plan is to enter the values and then use the data from the grid.
Private Sub sfillGrid(ByVal Loc As String) Dim i As Integer Dim column As DataGridViewColumn
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
i am writing a VB front end (VS 2008 .NET 3.5) to a data loading program that involves moving the contents of CSV flat files into SQL Server 2005 staging tables. I have had some experience with DTS in SQL 2000 so I decided to use SSIS packages to load the CSV data. Creating the packages in BIDS worked fine for the development environment where I hard-coded the Connections and file paths. The problem arises when I will release this program to 30 different sites that do not have SQL Server admins to help changing the configuration.
I have a SQL table in which I will put all the necessary path information and I can pull that into the VB program on startup. I need to see an example of how I can set the properties from VB once the package is instantiated and opened.Here is an example of where I plan to set those properties and run the packages.
Private Function RunPackages() As Boolean Try Dim oApp As New Application Dim oPackage As New Package
[code]....
Even though I am using a configuration file in the example, I am finding it difficult to edit the configuration files for each site. I see that there are methods and properties exposed for the oPackage instance. However, I can't find a good reference for the Class model to use as a guideline. All the examples expect packages to be run and configured with SQL Server and BIDS. direct manipulation of package properties in VB or C#?I am now considering using the old standby SQL Bulk Insert. It almost appears as if the Data Tasks are just wrappers for the Bulk Insert operation. Furthermore we have several sites still using SQL Server 2000. With the economy the way it is, most of those sites do not want to spend ANY extra money upgrading to SQL 2005 or 2008.
However, having a good resource to learn how to manipulate SSIS packages from the CLR would be very helpful. I have heard that in SQL 2008 things have changed even more. It is maddeneing that once I learn a "new" Microsoft technology it seems to be discarded by MS in their next release in favor of a "better" alternative.
How I can set a Textbox or the report header title programmatically at runtime? Like as in a form - Me.text = "Sales Report" Depending on how I query the report I'd like to give the report a descriptive report name.
I have done some searching, but am still having trouble trying to set the browsable attribute of property to false at runtime in order to hide in the properties grid control (based on certain conditions).
I have very new to VB. I was just fiddling and ran into this. I cant set the text alignment of a text box twice with the focus events as well as cant set or reset the password char property. The code is given below:
Private Sub tbxLogin_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles tbxLogin.LostFocus If tbxLogin.Text = String.Empty Then 'tbxLogin.ResetText() tbxLogin.ForeColor = Color.Gray 'tbxLogin.TextAlign = HorizontalAlignment.Center 'trying to align the tbx gives it focus [Code] .....
I'm using .net 2008 Trying to create a small graphic component, I have a problem setting background both at design time and then runtime. I derived a panel like this
[code]...
But it isn't working! If I don't Overrides Property BackColor, this is working as expected but I really need to group in my custom tab.
