dropdownlist - using as a picklist

[Paul Owen]

Hmm, nobody seems to want to answer any of my questions, but here goes again!

I have a Detailview control that is bound to a data source. Within the
Detailview control I have a number of dropdownlist controls that I want to
list available options but will be bound to the Detailview control. I can
achieve all this and seem to select the correct item from the datasource.
However, when I try to update, the bound dropdownlist value seems to be
missing and I get a db error saying cannot enter a null value. I have tried a
number of ways to achieve this by declaring on a page and now I am using code
behind to define & construct the dropdownlist items. Any help would be great
as I am beginning to suspect that old style ASP was a much better solution!..

Private Sub testbind(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender

ddl.ClearSelect ion()
ddl.DataSourceI D = "SqlDataSource2 "
ddl.DataValueFi eld = "Case_Contact_D irectorate_ID"

End Sub

Private Sub test2(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender
Dim con As New
SqlClient.SqlCo nnection(Config urationSettings .ConnectionStri ngs("AppConnect ionString1").Co nnectionString)
Dim comm As New SqlClient.SqlCo mmand("SELECT [Directorate_ID],
[Directorate_Nam e] FROM [Directorate]", con)
Dim rdr As SqlClient.SqlDa taReader
con.Open()
rdr = comm.ExecuteRea der

Dim di As ListItem
While rdr.Read
di = New ListItem(rdr(1) , rdr(0))
ddl.Items.Add(d i)
End While
con.Close()
con = Nothing
comm = Nothing
Dim val As Integer = ddl.Items(0).Va lue
'di = ddl.Items(0)
'ddl.Items.Remo ve(di)
'di = Nothing
For Each di In ddl.Items
If di.Value = val Then
di.Selected = True
Exit For
End If
Next

End Sub

[Patrice]

I don't see how the update is done... My first though would be to use the
profiler to see if this is the only field that has a problem or if something
is totally wrong about the update...

You may want also to try first with a single drop donw list to see if it
behaves as expected... (could it works for some but not all of your
dropdownlist).

Do you use ASP.NET 2.0 ?

Patrice
--

"Paul Owen" <Pa******@discu ssions.microsof t.com> a écrit dans le message de
news:3D******** *************** ***********@mic rosoft.com...

Hmm, nobody seems to want to answer any of my questions, but here goes again!
I have a Detailview control that is bound to a data source. Within the
Detailview control I have a number of dropdownlist controls that I want to
list available options but will be bound to the Detailview control. I can
achieve all this and seem to select the correct item from the datasource.
However, when I try to update, the bound dropdownlist value seems to be
missing and I get a db error saying cannot enter a null value. I have tried a number of ways to achieve this by declaring on a page and now I am using code behind to define & construct the dropdownlist items. Any help would be great as I am beginning to suspect that old style ASP was a much better solution!..
Private Sub testbind(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender

ddl.ClearSelect ion()
ddl.DataSourceI D = "SqlDataSource2 "
ddl.DataValueFi eld = "Case_Contact_D irectorate_ID"

End Sub

Private Sub test2(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender
Dim con As New
SqlClient.SqlCo nnection(Config urationSettings .ConnectionStri ngs("AppConnect i
onString1").Con nectionString) Dim comm As New SqlClient.SqlCo mmand("SELECT [Directorate_ID],
[Directorate_Nam e] FROM [Directorate]", con)
Dim rdr As SqlClient.SqlDa taReader
con.Open()
rdr = comm.ExecuteRea der

Dim di As ListItem
While rdr.Read
di = New ListItem(rdr(1) , rdr(0))
ddl.Items.Add(d i)
End While
con.Close()
con = Nothing
comm = Nothing
Dim val As Integer = ddl.Items(0).Va lue
'di = ddl.Items(0)
'ddl.Items.Remo ve(di)
'di = Nothing
For Each di In ddl.Items
If di.Value = val Then
di.Selected = True
Exit For
End If
Next

End Sub

[Paul Owen]

Thanks for the reply Patrice,

I am using framework 2.0 and I am trying to carry out the update using the
datasource update and a stored procedure with 14 update params. I need to use
the dropdownlist controls to guarantee the integrity of the data...I am
prepared to code the update but I have so much trouble identifying and
accessing the cells that hold the data, I thought this would be more likely
to succeed!

"Patrice" wrote:

I don't see how the update is done... My first though would be to use the
profiler to see if this is the only field that has a problem or if something
is totally wrong about the update...

You may want also to try first with a single drop donw list to see if it
behaves as expected... (could it works for some but not all of your
dropdownlist).

Do you use ASP.NET 2.0 ?

Patrice
--

"Paul Owen" <Pa******@discu ssions.microsof t.com> a écrit dans le message de
news:3D******** *************** ***********@mic rosoft.com...

Hmm, nobody seems to want to answer any of my questions, but here goes

again!

I have a Detailview control that is bound to a data source. Within the
Detailview control I have a number of dropdownlist controls that I want to
list available options but will be bound to the Detailview control. I can
achieve all this and seem to select the correct item from the datasource.
However, when I try to update, the bound dropdownlist value seems to be
missing and I get a db error saying cannot enter a null value. I have

tried a

number of ways to achieve this by declaring on a page and now I am using

code

behind to define & construct the dropdownlist items. Any help would be

great

as I am beginning to suspect that old style ASP was a much better

solution!..

Private Sub testbind(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender

ddl.ClearSelect ion()
ddl.DataSourceI D = "SqlDataSource2 "
ddl.DataValueFi eld = "Case_Contact_D irectorate_ID"

End Sub

Private Sub test2(ByVal sender As Object, ByVal e As System.EventArg s)
Dim ddl As DropDownList
ddl = sender
Dim con As New

SqlClient.SqlCo nnection(Config urationSettings .ConnectionStri ngs("AppConnect i
onString1").Con nectionString)

Dim comm As New SqlClient.SqlCo mmand("SELECT [Directorate_ID],
[Directorate_Nam e] FROM [Directorate]", con)
Dim rdr As SqlClient.SqlDa taReader
con.Open()
rdr = comm.ExecuteRea der

Dim di As ListItem
While rdr.Read
di = New ListItem(rdr(1) , rdr(0))
ddl.Items.Add(d i)
End While
con.Close()
con = Nothing
comm = Nothing
Dim val As Integer = ddl.Items(0).Va lue
'di = ddl.Items(0)
'ddl.Items.Remo ve(di)
'di = Nothing
For Each di In ddl.Items
If di.Value = val Then
di.Selected = True
Exit For
End If
Next

End Sub