Imports 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.
Well basicly I have been trying trial and error, and im sure this is a very simple fix, but how would I populate a ComboBox with information from My.Settings using VB.Net.
View 6 RepliesI 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'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
View 10 Replieshere's the code:
Try
Dim com As New OleDbCommand
com.Connection = con
[code]......
I have a project I created for my VB class where you enter what type of ticket(combobox), how many tickets(textbox), what type of tickets(listbox) and will give you the total amount.I want to do a little more to the program and was wondering about adding the person's name, address, phone, city, state, zip and then having all the information put into a database. I wanted to also take the information entered from the program and use the printPreview control to view a report from Access(possible?).
I've only worked with viewing database information on the forms in VB but I've never entered data into the database. Is this possible?Can I have the information entered on the form be entered into a database that keeps track of all tickets purchased and customer information?I can see this working in my head but don't know if it's logistically possible.
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
View 4 RepliesI am trying this..
Imports System.Data.OleDb
Public Class Form1
Dim conn As OleDbConnection
Dim cmd As OleDbCommand
[code]....
I get an error: object reference not set to an instance of an object
Im currently doing a small programme of a register system. I need to add a new group box filed with a few textboxes and a couple comboboxes for each entry in a access 2010 database. for example if i had someone called bob in my database with his details i would like the GUI of the VB app to add in a new textbox for the name, a textbox for the address ect in a set order, this needs to work for multiple entry's so the textboxes ect don't overlap but be placed neatly below the added textbox.
View 3 RepliesThis is written in.NET 1.1 and connected to a SQL 2000 Server Database
[code...]
[code].....
View 4 RepliesI have this datagrid containing a couple of items: Attachment 72953 I have a save button which on click will add both the rows to the database table named MSale. The MSale table contains the seven columns present in the datagrid...
View 5 RepliesI have a Visual Basic 2008 Windows form application that processes some scores and data. I want to export the data to an Access database. I have created the Access database and connected it to the VB program.I am looking for a simple set of commands or sample code to add records to the database. Perhaps I am oversimplifying the problem, but it seems like it should be so much easier than it has proven to be. I only want to export the data in code; the user should never see the database or do anything to it while the program is running.
View 3 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]...
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 Repliessample code for show id from database ke combo box. i use sql database.
View 1 RepliesMy application is in VS 2008 (vb.net Windows form)
I want tips for this:
What types of care I take for it?
What types of problems can be generally happen?
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 RepliesI did populate data from db into the combo box and display it into the text field .
Below is my code :
Imports System.Data.SqlClient
Public Class MPEJobEntry
'declaration of connection string
[code]....
The apostrophe is used to separate data when adding records to an Access Database data table using the "INSERT INTO" SQL statement. Having apostrophes in the data really screws things up with this new software. Is there a simple workaround? Is it possible to specify a different character? Is it possible to add data without using SQL Statements? I also noticed that the new OleDbDataAdapter Add Method generates the same SQL Error because it apparently creates an "INSERT INTO" SQL Statement.gh
View 4 Repliesi am creating app , its a question i am stciked at , i am using vb 2008 by using databinding my combobox has the list ready from one column but as selection change the values from all textboxes and labels should change as per the combbox's selection can anyone help
View 10 Replies
