my problem goes like this:i am making a system of a certain bakery...i already saved some products in the database and i also imported it in the combo box...my problem is this....from my combo box...i want to print it in the list box with its price
View 2 Replieshow is she can import content of MS Access database into combobox in vb..
but i don't have visual studio
I need to import data from a file into a Microsoft SQL Server database.
The file is roughly structured (inconsistent number of fields but the data needed is available in all rows) The file can contain up to 600'000 records The first field is identifies a record
The import of the data contains updating existing records in the database with the new values or inserting a new record if the record could not be found.
What is the best approach to accomplish that?
(Reading the file line by line, executing a SELECT and UPDATE or INSERT from my .NET Application doesn't truly satisfy me, because this way it processes around 35 records per second, which leads to several hours of processing time...)
A first option might be to combine the select and update/insert commands in a stored procedure, but this would still take a lot of time.
Is there something like MySQL INSERT ... ON DUPLICATE UPDATE?
Is it possible to pass a list/array of records (multiple columns) to a stored procedure?
have anyone tried importing specific column of an excel sheet to an sql database?i have tried importing data from excel and it worked but my problem is i want to import only specific columns from my excel file not necesarily importing all the columns..
View 3 RepliesI have some table forms that have been created in word 2003. What I'd like to do is take the xml for the word and map the points on the form to a database.I have done a sort of mail merge from a sql database before using the document.xml from the word doc, but can use the same xml to pull data out from word into a database?
View 2 RepliesI have a project am about to start and I want to used vb.net 2008.
I have an access database with some messed up data for example instead of firstname, Lastname field the person who create the database used fullname for the name filed. The good thing about this is the clerk types the names with a space.
I want to create a program that find the first name insert it into a new table.firstname and last name and put it into a table.lname using a loop all at once.
how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..
View 1 RepliesI'm developing a system to generate a water bill for a local area.In it i need to print out the bill from using the data from the database. how to generate & print the bill in vb.net.
View 2 RepliesI have a Fixed Text File and i need to import data from this Text file to my Database I am Using VB2008 and SQL Server2000 This is a sample of my Text File
View 1 RepliesI have a project to import data from one worksheet into database SQL Server 2008 on Windows Server 2008 using Interop. The project in debug mode works fine, but accessing the site from a client computer, I am getting permission denied message to the file I'm trying to import and it is located on the server. I wonder what it takes to make additional settings, as well as file folder. IIS? DCOM?
View 1 RepliesI am trying to develop an application to monitor and keep track of all the prints in the office.I have gone through some of the tutorial and found out system.printing has the functions to do so. But when I tried to import it, it says name space or type specified for system.import doesn't contain any public member or cannot be found.
View 2 RepliesI generate a print preview, the only thing is, if there is enough data to fill like 2-3 pages I don't know how to generate a new page. It only fills the first page and that's it....
Private Doc As New PrintDocument()
Private Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click[code].....
most of the code it's just pulling data from database and printing necessary charges to the invoice, but if the invoice is more than 1 page then I don't know what to do because it only generates 1 page.
how could we download a pdf file and import the tabular data into access 2007 database, i have tried and got successful in downloading the pdf file from an URL, but not able to import the table data into access 2007 database/or may be an excel file through a VB6 program.
View 1 RepliesI want to load data from a txt in a combobox and a listbox. The txt is composed as follows:
ID NAME
0001,name1
0002,name2
0020,name3
[Code].....
In the combobox I want to load 'NAME " And in the listbox I want to load "ID"
I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object"
Here is my code
Imports System
Imports System.Data
Imports System.Data.OleDb
Public Class ExellFrm
[CODE]...
I have a text file in which there is a list which is composed as follows:
3236, Alberto
5894, Peter
7894: Alonso
and so on ...
What I want is loaded into a listbox the numbers to the first semicolon and load the combobox names.
I got the System.Data.DataRowView when I tried to select the data from sql database. These are my code:
......
myCommand = New SqlCommand("SELECT FirstName +' '+ LastName FROM tblVisitor", myConnection)
myAdapter = New SqlDataAdapter(myCommand)
[Code].....
I am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesImports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code]....
How do i generate a new GUID and Add a new "CustomerName" to my table if the GUID doesnt exist.
I'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]...
trying to put data from a database into a combobox. i've tried different way, still not working.
Public Sub SaveNames(ByRef SQLStatement As String)
Dim cmd As MySqlCommand = New MySqlCommand
With cmd
[code]....
Im now creating an inventory system for my project.
i having difficulty with my project im using combobox to select data from database and i want to update the data. if i selected second row of the data it will update the first row of the data.
eg.
"comboboxitem_name" - red ball pen
- blue ball pen
- black ball pen
"quantitytextbox"- 100
"reorder_quantitytextbox"-20
when i selected the "blue ball pen" and fill the information that i want to update then press the submit button. the red ball pen will update with the information that i want to update to "blue ball pen" and the "red ball pen" will change it name to
"blue ball pen". and now i have two "blue ball pen", one with "red ball pen" information and the other one with original "blue ball pen" information.
I'm doing small system using database 03. I had function to add data into a comboBox. When i add a new data into the the same field using another form, then back to the main Form the comboBox does not update the current data in database..
Codes i tried:
'Form Load
Private Sub FrmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
I have form with combobox I have database contained 2 filed "ItemID" and "ItemName" The combobox fill her data from the database from field "ItemName" I do when I choose in the combobox any item and save, the data saved in database "ItemId" Not "ItemName" by define string put on it "itemId" when the user choose any item in combobox I need when I get the data that saved in database the combobox value="ItemName"
View 2 Replieshow to retrieve data from SQL Database using SQL Connection by selecting the individual value in a ComboBox which the data in the ComboxBox is also retrieved from the SQL Database using DataBound. A 'Display' Button will be clicked to display the data in a TextBox, based on which value the user had selected.
Below is my current
Private Sub displayBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayBtn.Click
'Create Connection
[Code]....
I cannot get my combo box to populate using a select statement from mysql database.
[Code]...
Here is the code for the loading the combobox. I want to load the combobox with the Name of client. so that user can select the Name and then the details which are associated with that ClientName are to be displayed in the desired textboxes.
View 4 Repliesi want to view data(from database) in textbox or combobox itried to use the code as same as datagridview but it doesnt work
View 3 RepliesI know how to pull data from an access database and place it into a combobox, but I am trying to make certain that I dont have multiples of the same information.
Like one column is for countries of origin.
United States
Canada
Mexico
In the combo box, it should only list the United States only once, not multiple times.
How to filter data from the database to combobox? For example, the database have the data, and i have a combobox, then i want to type the first letter, and the dropdown list comes down that the data have the first letter that i type in the combobox.
View 6 Replies