I am connecting my VB application to Oracle Database. I need to configure the Data Source in the app.config.ng know which section do I define my UID, PWD and DSN and what functions do I use to read this information. Can I also write back this information through the application.
View 1 Replieshow do you add information from another datasource into a cell in a data grid which has the relevant information i.e order_bindingsource grid which has the information order id, item id, quantity and cost per item.
The item id I have linked to the Productbindingsource but I also need the information to be shown cost per item which is in data source products.The item id is a drop down box with the items displayed what I need is when an item is selected I need the price to show up in the cost per item box.
how do you add information from another data source cell to a to another data source cell in a different form
View 1 RepliesI have an access database with 5 tables.I want to fill a dataset with the entire contents of the database.Why can't it roughly look like this?[code]Instead I'm having to create an adapter for EVERY table, tab the table name (why?), fill the schema, and then fill the table.
View 1 RepliesOne Possible (working) Solution:
Private Sub ReadXMLAttributes(ByVal oXML As String)
ReadXMLAttributes(oXML, "mso-infoPathSolution")
End Sub
Private Sub ReadXMLAttributes(ByVal oXML As String, ByVal oTagName As String)
Try
[Code]...
Is it possible to do the following?
A user is prompt to enter a 3 digit code followed by a single letter, like this: 000A
is it possible to limit the input to the textbox to 4 characters? and is it also possible to create a function which detects which letter is at the end of the input so that it can put the data in the right place?
For example, if i have three folders, A folder, B Folder and C folder, can I create something to detect the last letter of the users input and based on that letter the input goes into the correct folder?
I want to be able to get the table structure / design / column information from an access database. I have created a post in the Database/Access section with no luck, here, but I am wondering if I could achieve this through vb (2008 express edition) rather than the access sql query itself. My overall goal is to compare one DB structure with another, an integrity check if you will.
View 5 RepliesThis project is based on a MUD, or at least originates from playing them. I have an ascii map where each character represents a type of terrain. I have found code for reading one line at a time, but I need to not only dictate which line to be read, but how many characters in to the line to read. Basically trying to make a grid/coordinate system, where I can tell it my location is 4, 7 and the program will read the fourth line, seventh character.
View 3 RepliesI use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
I have been successful in using the datasource binding in VB 2008 (drag and drop from datasource to form)My question is that I have date and time fields in an access database. In the database they are fine. I have the date as a long date and the time field as medium time.When these dates are viewed in my vb form, they show as:example (for date of 5/15 and time of 9:00)
Date field: 5/15/2009 12:00:00 AM
Time field: 12/30/1899 9:00:00 AM
I tried to format these field in VB to long date and medium time but it doesn't change. Any suggestions on how to do this?
I have an IEnumerable(Of System.Data.DataRowView) and would like to set it to be the datasource of a datagridview - however when I try I get no results my IEnumerable variable in the eg below is called xIEnum
DataGridView1.DataSource = xIEnum
However when I go
DataGridView1.DataSource = xIEnum.ToList
it works.... However I want the data to automatically update when I change the underlying datasource that the IEnum is mapped to?
i import into a list box data from a db. when i try to save listbox it save this text
System.Data.DataRowView
instead text of single item...
how i can get the real text of each item?
I'm learning some more VB in my spare time, and I'm making a simple customer database that uses SQLCE. I've got the datasource set up and all that, but for some reason when I hit accept on the form, nothing happens?
[Code]...
I gather MATTER NUMBER and PATENT NUMBERS in a listbox on a dialog form - that I pass to the main form after the dialog closes.I then ask for CASES on subsequent dialog forms and want to have drop downs for MATTER NUMBER and PATENT NUMBERS that "have the suggestions" of what was entered in those list boxes earlier.So - I've been using DATASOURCE for binding to datatables and thought to myself - heh - I can probably set the DATASOURCE of the DROPDOWNS - and it works!
Public AddMatterNumber As ListBox
Public AddPatentApp As ListBox
MatterNumber.DataS
[code].....
I have a vb.net project. I have used the GUI and wizard to create a DataSource pointing to a SQL Server Stored Procedure. It works great! However, a new column has been added to the stored procedure.In the GUI if I right click the data source name and refresh, nothing happens.If I right click the stored procedure name and refresh, nothing happens.If I preview data I can see the new column returned.If I choose edit with wizard there is a red exclamation point next to the name of the stored procedure and red X be each column name.
When I hover over the field name it says "Column ABC in the DataSet references a column missing from the Database".When I hover over the stored procedure it says "STORED_PROCEDURE is mapped to STORED_PROCEDURE in the DataSet. Element STORED_PROCEDURE in the DataSet contains columns that do not exist in the Database".I can't figure out how to get the new columnd in the dataset.
[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.
View 14 RepliesI am trying to link a date produced from a month calendar to a three column data source . Col 1 is date and cols 2 and 3 hold password records for use on the selected date. I am able to have the selection from the month calendar produce a result into the label text but cannot see how to relate the date in col 1 back to the label. I am beginning in this world,
View 1 Repliesi need to query the datatable & set the outcome as datagridview controls datasource
vb.net
Private Sub Txt_Search_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txt_Search.TextChanged
'routine objective:- Filter datatable & set the datagridview datasource
[code]....
During Loading a form, I bind a datasource property of the DGV to the bindingsource, and then set the fillweight property of the DGV columns. But, after form being shown, earlier set properties are being reseted to default = 100.
The procedure is like:
1. TestForm.Show()
2. TestForm_Load(...) Hnadles MyBase.Load
DGV.DataSource = bindingsource
DGV.columns(0).fillweight = 80
DGV.columns(1).fillweight = 120
3. Me.close() (Closing the form which called TestForm.Show()
And now I have visible a TestForm with well binded datasouce seeing all the columns, but their fillweith property was beeing reseted...
I made an application that was used by one person only, but now my boss told me that this application it'll be used by all company.I made the application with a dataset that have the datasource in a access database that's installed with the application. The user can add, delete and change values in the database, so i had to put the database in a sql server to everyone see the changes.There's someway to change the dataset datasource/connection string?
View 9 RepliesI have created an application which uses an sql server connection as its datasource. The problem I'm having is that the application needs to work on computer that has no network connection. How Can i change the datasource so that on runtime it can work off a machine that is not connected to a network? The datasource from the sql connection only contains one table with no data. It only needs to be updated with a target folder that can be changed to any location on any computer already written in the code.
The connection string suddenly stands as: Dim MyConnectionString As String = "Data Source=MY-PC;Initial Catalog=ImageLocs;User Id=test;Password=test;Pooling=False"
My form closes whenever I insert an object that has a data bound in it. The object I'm trying to insert is a textbox from the data source window (drag n drop). I've checked on the database and that the table has records in it.
View 1 RepliesI have two tables "Person" and "Alias" in a one to many relationship. I have a DGV for "Person" and want to use a combobox for the Aliases. I also have a textbox and a button for the user to type the alias name and click the button to add the alias name to the combobox and update the dataset. I keep getting the "Items collection cannot be modified when the DataSource property is set." Error. But if i use a DGV instead of a combobox for aliases, I have no errors and everything works fine. If I remove the datasource property for the combobox it will not get populated with the data already entered, so how, or can I, set it up where the combobox gets populated when the form loads and able to add items to the combobox????
View 1 RepliesI was wondering how i can loop through a combo boxes items display item field - and return the value for each - i want this to be generic regardless of the combo boxes data source - or if the combo box has been populated with a string list / class etc
View 3 RepliesI need to create a user control which can be used in my all projects. I have created a user control with a TextBox Control and a ListBox Control. My goal is that as soon as any character is pressed in the textbox, Listbox's item which starts from that character should be selected. I have done all the coding needed for the functionality but my problem is that when I add this usercontrol to my form, I should be able to change the DataSource, displaymember and valuemember properties at designtime. But I cannot see these properties when I add the control on the form.
View 1 RepliesHow can I create the property... type the combobox? for now I found alone this that it goes in mistake
[Code]....
The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
I was looking for some stuff online, and i was looking through my reference sheets for vb.net, but it seems in the code i have found, there is declare in methods. Below is an example i am talking about. The thing is, that i dont recognize it and believe that it is an earlier version of Visual Basic ( 6 or earlier) which used it. Should i just keep looking for different code?
Public Declare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal hKey As Long, ByVal _
lpSubKey As String, phkResult As Long) As Long
Goal: Find information on how to implement a method which will check if a certain DSN exists, and then if it does, extract the information and use the information for connection purposes.
I have a text box where i am entering numbers of double datatype andon the Keytdown event of the textbox some checks take pace and in certain circumstances I want to be able to stop the user from entering other information until they enter the right information in the textbox (where it says right here) . now when I say exit sub the textbox somehow loses focus . but this is not how I want it to be I want the textbox to remain with the focus so the user can change the information . How can i go about this. And the other thing is why is my txtDestPayRate1.Focus() just befor the exit sub not working?
Private Sub txtDestPayRate1_KeyDown1(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles txtDestPayRate1.KeyDown
If e.KeyCode = Keys.Enter Then
[CODE]...
I am designing a backup/restore utility for work.atm i have been able to populate field for PC name, IP address, MAC address, number of printers installed on the PC but i am wondering is it possble to get all the printer information 'with the click of a button' to print all information like the prnmngr.vbs script down.I am able to run a batch file but i wanna get it to go from that app or even embed to batch file to the app and run it form there .
View 4 Replies