I need your guide regarding to pull data form other database to other database. I'm already pull the data into Dataset using this command oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn) da = ds.fill then i need to insert to other database but it have different name of column that is Staff_Id,Staff_name,Department.
View 2 RepliesI have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
View 1 RepliesI'm having a problem to pull data from MS Access to my combobox. I know how to search one data using another data (e.g: using IC num to search name) but this time I just want to pull the data (e.g: name) that has several rows to my combobox. I think the method is the same but don't know where to change it.
Then when I added new names to the combobox, want to save it to my database, can each name be saved in different rows? I added the names to the combobox 1st, after that then I saved it. [code]...
I want to pull data from database and populate an array. Field one: A short name to call the second. Field tow: A connection string to a database.
EG: Cstr=Connstr("OrDB")
The known name of OrDB would result in a string assigned to the variable Cstr that could be a connection string to an oracle database.
I have a form as shown below:
And a database as shown below:
It is an inventory program I am doing on the side just to keep track of a small number of supplies, I want to be able to enter a barcode and have the program see if it already is in the inventory database, if not, it will allow me to enter information and add it to the database (That part works - Thanks to member on D.I.C.) If the barcode exists, I want it to fill the form with all the data from the database and allow me to update fields such as date used and used definition
Here is what I have so far:
Imports System
Imports System.IO
'Added For Database
[CODE]...
I have a VB 2010 program with a single-table Access Database.I have selected the option to copy the Access Database to the output directory.When doing so, the program copies the original database to the inDebug folder.I want the original (NOT the copy) to be modified when the program is being tested.Also, when I attempted to publish the program and run it to test, I got an error which was sourced to be a temporary file (which was the database) that was missing.I think this is a reaction from the "Copy Always" option.
View 1 RepliesI'm currently working on a Capstone Point of Sales project. We're using a multi-column list box to pull up the item #, Item Name, Quantity(may be deleted) and Price. However, I haven't had much experience with a connect database in Visual Basic. how to pull and display the data from the database into the list box?
View 5 RepliesI have a program I built to pull my weather station data from a mysql database. I can get ALL the records to load, but when I try to query a date from the RecDate row, nothing.
Imports MySql.Data.MySqlClient
Imports MySql.Data.MySqlClient.MySqlCommand
Public Class search
Private connsearch As String = "Server=" & My.Settings.Data_Source & ";" _
& "Database=" & My.Settings.database & ";" _
[Code]...
I am using the tutorial posted here for my database testing. I have gotten it to display the data using a messagebox but it just goes through them 1 by one. I want it to display all the data from the database in a table on my form.
Using connection As New SqlClient.SqlConnection("Server=71.200.87.112MySQLExpress; Database=database_test;User ID=sa;Password=greddy6;Trusted_Connection=False;")[cod
I open a form from the datagridview on a selected record in the database. When saving I have my code saving to (0) I need to somehow pull the text form the account textbox in order to save to that row in the database. here is a copy of my save button...
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'save updates to database
[Code]......
In ASP.NET, what is the definitive way to pull one record from the database and bind it and HTML tag?
View 2 RepliesI have a SQL database that is different than the one in ASP.net so I had to create a custom membership Provider. The provider to get the user looks like this:My SQL class name is CustomSqlProvider:
Public Overrides Function GetUser(ByVal username As String, _
ByVal userIsOnline As Boolean) As MembershipUser
'Dim connectionString As String = "Server=***;Database=***;User Id=***password=****"'
[code]....
After adding those gets and sets and assigning parameter variables to my Sproc parameters I get the following error: "Reference not set to an instance of an object." at this line of code:
Dim currentUser As MembershipUser = Membership.GetUser()
Dim UserId As Guid = CType(currentUser.ProviderUserKey, Guid)
And this is what I have on the UserInfo.aspx.vb Page under the Button click:
Dim sql As New SqlClient.SqlCommand("Update_User", con)
sql.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = UserId
sql.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = txtUserName.Text
I am importing a image in to a database but it would be able to add some of the file details in to the database as well. So I would like to pull out all the details in the camera section
View 1 RepliesI have one table here with a list of UserIDs, Users, and ClientCodes. Each user can be assigned a client code to view that client's data elsewhere. Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves. All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.
What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it. I have it displaying the correct user and their current ClientCode but that's about it.
Who can write a windows service used as SMS gateway to push and pull sms to database..
View 3 RepliesI am trying to work with an access database. If this line pulls data from a dataset and puts it into a textbox: TextBox1.Text = Me.A_DataSet.a_Table.Rows(0).Item(0).ToString How would I pull the field name? For Example, in this database I have 3 fields:
[Code]...
I got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
[Code]...
the "text", such as that you would find in a forum, and use it in a Visual Basic Windows Form.Everything in bold is finishedGrab theHTML source of a web page and store it into a string variable.Next I need to search that string variable for two HTML syntax, and place the text between them into another string variable
View 4 RepliesHow do i load the Main form of a WPF so that a seperate thread goes and gets data from the database while the form is in an apartmentstate? (drag-able / movable) I Know this is possible with opening a new window from your main form like this :
Private Sub openOrderWindow()
Dim OrderWindow As Orders = New Orders
OrderWindow.ShowDialog()
End Sub
[code]....
I've tried putting MyBase.ShowDialog() and .Show() and .9000+ other things The only benefit I've got out of using a seperate thread to load from the databse is i can see the screen right away (as oppose to it being a transparent box until it loads) but i cannot move it around or minimize it?is there any way to make it Movable while it loads?
I'm trying to add data from a form to an access database. I'm using this
[Code].....
I seem to be having a problem with displaying data in a second form. I've created a linear search algorithm which works just fine - it locates the records from the database. I now want to be able to display the record in another form, I've attempted this using the code below but it doesn't seem to work:
Public Class formSearch
Dim searchItem As String
Dim currentRecord As Integer
Dim Provider As String
Dim Source As String
[Code] .....
The commented out lines are the ones that don't seem to work. The "txtfirstname" and "txtlastname" fields are located in the coding of another form, called "formcustomers".
i'm new in vb.net, how to get data from database and put in lable in new from ???
View 3 RepliesI have 5 forms after the first initial login form which i believe to be correct You are to enter customer details which so far i believe to correct(all fields must be filled) I then have a Service or repair screen whichever the user wants. on the repair screen i have a checkedlistbox with repair types in. anyway after all of this i have a calculate button on either service and repair screen and i want to know how to pass all customer details and repair or service onto an invoice displaying the cost of the service or repair Inlcuding VAT and Hourly rate
[Module Var
Public Title As String
Public Surname As String
[Code]....
I have a simple form with about 40 textboxes bound to an access database.I simply want the data entered on the form to be written to the database.I have search extensively but i am getting more confused.I dont want to use the binding navigator to do the record adding just a button.From what i understand the data has to be written to the dataset and then the datbase updated.But how do i get the form data into the dataset ?
View 3 RepliesI have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA.
For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it, DB3 with a RECDATA table inside it est. So I need to put all the Recdata into 1 Database file, or to copy all the RECDATA from all the database files to 1 RECDATA they all have the same columns All I need is to get all that data into 1 RECDATA table.
The program where this database comes from is a voicerecording system creating a new database every day. There is 1 database just for indexing (to view the recordings) and then the daily database is where the recording lies in, that Colum is called RECFILE. I will give you a example of the 2 database.
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.