'need help!!' Thread RSS Feed

need help!!

Tue, 17 Nov 2009 09:06:19 -0700

On my form load event, i populate three comboboxes by code.... in the button click event i try to insert into the database and i use combobox.selecteditem and it generates an insert error.
but when i use combobox.selectedindex, it runs.
dont know wat to do.

Re: need help!!

Tue, 17 Nov 2009 10:31:52 -0700

Have you looked at the contents of the Insert Statement to see why it is giving you an insert error? It'd be very helpful, for me to give you a good answer, if you provided the exact error messages and some sample code...

Here is a suggestion on something to try so you can understand why your statement is crashing:

MsgBox(ComboBox1.SelectedItem.GetType.ToString, vbOkOnly, "Test")

You'll see that you get a type like "ListItem" or something from ComboBox1.SelectedItem. That is because ComboBox1.SelectedItem returns an OBJECT, not a VALUE, and that OBJECT is determined by the Datasource of the ComboBox (in this case you have added an item manually with ComboBox.Items.Add, so it uses a default data type and adds it to the datasource).....

So here is some things you can use:

ComboBox1.SelectedText 'this should work
ComboBox1.SelectedValue 'this works when you have a datasource and a valuemember set
ComboBox1.Items(ComboBox1.SelectedItem).Text

Here is an example of how to check if something is selected, and get the value:

'Assume ComboBox1 is the name of your combobox control
Dim ComboVal as STring = ""
If ComboBox1.SelectedValue > -1 Then 'Something is selected
  ComboVal = ComboBox1.SelectedText
Else
  'By Default you can type text into a ComboBox, if there is
  'text in the combo, and you haven't selected any, you can do
  'something here
End If

Re: need help!!

Wed, 18 Nov 2009 01:14:44 -0700

hey seancampbell this is my code...
ON form load event..
Dim conn As New MySqlConnection
conn.ConnectionString = "server=localhost;" _
& "database=cargomanager;" _
& "userid=root;" _
& "password=admin;"
Try
conn.Open()
Catch myerror As MySqlException
MsgBox("failed to connect to database")
End Try
sql0 = "select name as cname from agent"
sql1 = "select name as dname from airline"
sql2 = "select abbreviation as ename from destination"
command.Connection = conn
command.CommandText = sql0
command1.Connection = conn
command1.CommandText = sql1
command2.Connection = conn
command2.CommandText = sql2
adapter.SelectCommand = command
myadapter.SelectCommand = command1
myadapter2.SelectCommand = command2
adapter.Fill(dt)
myadapter.Fill(dt1)
myadapter2.Fill(dt2)
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "cname"
ComboBox2.DataSource = dt1
ComboBox2.DisplayMember = "dname"
ComboBox3.DataSource = dt2
ComboBox3.DisplayMember = "ename"
conn.Close()
conn.Dispose()
This is the insert statement on button click event..
Try
sql = "insert into invoice(transactionid, description, quantity, weight, agent, airline, destination, price,time) values('" & TextBox1.Text & "', '" & TextBox2.Text & "', '" & TextBox3.Text & "', '" & TextBox4.Text & "', '" & ComboBox1.SelectedItem & "', '" & ComboBox2.Selecteditem & "', '" & ComboBox3.Selecteditem & "', '" & TextBox5.Text & "', NOW());"
command.Connection = conn
command.CommandText = sql
command.ExecuteNonQuery()
MsgBox("operation successfull")
Catch myerror As MySqlException
MsgBox("operation failed")
End Try
this is the error msg
Operator '&' is not defined for string "insert into invoice(transactioni" and type 'DataRowView'.

Re: need help!!

Thu, 19 Nov 2009 12:00:36 -0700

Sorry for my delay in responding...

It seems to me that your problem isn't a SQL error, but instead a syntax error.

.SelectedItem is an Object (in this case, a DataViewRow, because it is bound from a datatable). You cannot convert a DataViewRow into a string value... What you need to use is .SelectedValue or .SelectedItem.Value

So change the sql= line to this:

sql = "insert into invoice(transactionid, description, quantity, weight, agent, airline, destination, price,time) values('" & TextBox1.Text & "', '" & TextBox2.Text & "', '" & TextBox3.Text & "', '" & TextBox4.Text & "', '" & ComboBox1.SelectedItem.Value & "', '" & ComboBox2.SelectedItem.Value & "', '" & ComboBox3.SelectedItem.Value & "', '" & TextBox5.Text & "', NOW());"

Re: need help!!

Fri, 20 Nov 2009 08:03:30 -0700

Thanks Sean for all your help.. I have tried the suggestion you gave me but they don't seem to work. I'm using vb.net express 2008 and mysql server 5.1. However when i use .selectedIndex or .SelectedText, the app doesnt crash...but fails to insert.
Besides intellisense does not give me the .SelectedItem.value option.

By the way have you ever worked with winwedge???
Thanks for all your time.

Re: need help!!

Sun, 22 Nov 2009 09:26:52 -0700

try SelectedItem.Text
or
SelectedText
possibly
SelectedValue?

Is this a Blue Squiggly Underline error (syntax error that wont let you compile) or is this a Run-Time error (the program runs, but crashes when it hits that line of code)?

Re: need help!!

Mon, 23 Nov 2009 00:15:35 -0700

When i use selectedText, the program runs but fails to insert the values into the database.
selectedvalue and selecteditem crashes the program because they are objects and cant be converted to string.
selectedindex works but it inserts the index of the value and not the value itself.

Re: need help!!

Mon, 23 Nov 2009 00:15:37 -0700

Re: need help!!

Tue, 01 Dec 2009 08:13:18 -0700

I am sorry I didn't catch this sooner... Firstly, I was just on a 2 week vacation, but more importantly, because I wasn't paying enough attention, for that I appologize...

In your second reply, you pasted code... In this part of your code:

ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "cname"
ComboBox2.DataSource = dt1
ComboBox2.DisplayMember = "dname"
ComboBox3.DataSource = dt2
ComboBox3.DisplayMember = "ename"

Do this:

ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "cname"
ComboBox1.ValueMember = "cname"
ComboBox2.DataSource = dt1
ComboBox2.DisplayMember = "dname"
ComboBox2.ValueMember = "dname"
ComboBox3.DataSource = dt2
ComboBox3.DisplayMember = "ename"
ComboBox3.ValueMember = "ename"

And use SelectedValue

Re: need help!!

Wed, 02 Dec 2009 01:37:04 -0700

Big thanks to you Sean. I'm really grateful. Thanks so much.
Really looking forward to learning from you.