Real Problem

[Big E]

Okay here is my code. I'm using ASP.Net and SQL Server 2000. When I run this
code the selecteditem.value is 1 the selecteditem.text is ALABAMA. This is
correct. But when I try and get the value once this procedure has run my
selecteditem.value is ALABAMA and the selecteditem.text is ALABAMA. It's not
keeping the selecteditem.value after I change the combobox selection.

Thanks.

Big E

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")
Dim i As Integer
For i = 0 To dtState.Rows.Count - 1
cboStateCompany.Items.Add(dtState.Rows(i)("StateCo de"))

cboStateCompany.SelectedItem.Value = (dtState.Rows(i)("StateId"))

cboStateCompany.SelectedItem.Text = (dtState.Rows(i)("StateCode"))

Next

cnPortal.Close()
cnPortal = Nothing

[Curt_C [MVP]]

check your binding, it looks like you are rebinding with JUST the state
passed to the DDL, not the ID & State.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Okay here is my code. I'm using ASP.Net and SQL Server 2000. When I run this code the selecteditem.value is 1 the selecteditem.text is ALABAMA. This is
correct. But when I try and get the value once this procedure has run my
selecteditem.value is ALABAMA and the selecteditem.text is ALABAMA. It's not keeping the selecteditem.value after I change the combobox selection.

Thanks.

Big E

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")
Dim i As Integer
For i = 0 To dtState.Rows.Count - 1
cboStateCompany.Items.Add(dtState.Rows(i)("StateCo de"))

cboStateCompany.SelectedItem.Value = (dtState.Rows(i)("StateId"))

cboStateCompany.SelectedItem.Text = (dtState.Rows(i)("StateCode"))

Next

cnPortal.Close()
cnPortal = Nothing

[Cliff Harris]

I'm not positive why that's not working, however, you might want to consider
looking into binding your datatable to the combobox instead of adding each
item individually, it's easier, and avoids user error:

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")

cboStateCompany.DataSource = dtState
cboState.DataValueField= "StateId"
cboState.DataTextField = "StateCode"
cboStateCompany.DataBind()

cnPortal.Close()
scnPortal = Nothing

see if that fixes anything for you...
(also, if my syntax is incorrect, sorry, I'm a C# programmer... VB.Net is
not my forte)

HTH,
-Cliff
"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Okay here is my code. I'm using ASP.Net and SQL Server 2000. When I run this code the selecteditem.value is 1 the selecteditem.text is ALABAMA. This is
correct. But when I try and get the value once this procedure has run my
selecteditem.value is ALABAMA and the selecteditem.text is ALABAMA. It's not keeping the selecteditem.value after I change the combobox selection.

Thanks.

Big E

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")
Dim i As Integer
For i = 0 To dtState.Rows.Count - 1
cboStateCompany.Items.Add(dtState.Rows(i)("StateCo de"))

cboStateCompany.SelectedItem.Value = (dtState.Rows(i)("StateId"))

cboStateCompany.SelectedItem.Text = (dtState.Rows(i)("StateCode"))

Next

cnPortal.Close()
cnPortal = Nothing

[Big E]

Thanks Cliff it works now.
"Cliff Harris" <he***@myrealbox.com> wrote in message
news:u7**************@TK2MSFTNGP11.phx.gbl...

I'm not positive why that's not working, however, you might want to consider looking into binding your datatable to the combobox instead of adding each
item individually, it's easier, and avoids user error:

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")

cboStateCompany.DataSource = dtState
cboState.DataValueField= "StateId"
cboState.DataTextField = "StateCode"
cboStateCompany.DataBind()

cnPortal.Close()
scnPortal = Nothing

see if that fixes anything for you...
(also, if my syntax is incorrect, sorry, I'm a C# programmer... VB.Net is
not my forte)

HTH,
-Cliff
"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Okay here is my code. I'm using ASP.Net and SQL Server 2000. When I run

this

code the selecteditem.value is 1 the selecteditem.text is ALABAMA. This is correct. But when I try and get the value once this procedure has run my
selecteditem.value is ALABAMA and the selecteditem.text is ALABAMA. It's

not

keeping the selecteditem.value after I change the combobox selection.

Thanks.

Big E

Dim Portal As String
Dim dsState As DataSet
Dim cnPortal As SqlConnection
Dim daState As SqlDataAdapter
Dim dtState As DataTable = New DataTable
Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")
dsState = New DataSet
cnPortal = New SqlConnection(Portal)
daState = New SqlDataAdapter("SELECT * FROM tlkpState", cnPortal)
daState.Fill(dsState, "tlkpState")
dtState = dsState.Tables("tlkpState")
Dim i As Integer
For i = 0 To dtState.Rows.Count - 1
cboStateCompany.Items.Add(dtState.Rows(i)("StateCo de"))

cboStateCompany.SelectedItem.Value = (dtState.Rows(i)("StateId"))

cboStateCompany.SelectedItem.Text = (dtState.Rows(i)("StateCode"))

Next

cnPortal.Close()
cnPortal = Nothing