Dropdownlist in Datagrid

[Richard]

I've seen articles on GotDotNet and elsewhere on how to put a ddl in a
datagrid, and have been able to implement this technique. For a new item,
among the datagrid columns there is the one ddl for the user to choose an
account description, and when the user saves, then the value is saved and
displayed in a bound column in the datagrid. So far so good.

The problem is when the user edits the line. The ddl is refreshed with all
of the choices as a result of the databind method in the grid's editcommand
event, but I need to synchronize the user's current choice that is in the
bound column and display that choice in the ddl. I can retrieve the value in
the bound column with no problem, but when I try to find the the ddl using
FindControl, it returns nothing.

Any help would be greatly appreciated!

Here is some code:

'This event occurs immediately when the user clicks on the Edit button in
the grid.
Private Sub grdLineItems_Ed itCommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
grdLineItems.Ed itCommand

Dim ds As DataSet
Dim dv As DataView

Try
ds = CType(Session(" DSNewLineItems" ), DataSet)
dv = ds.Tables(0).De faultView

With grdLineItems
.EditItemIndex = e.Item.ItemInde x
.DataSource = dv
.DataBind() 'this triggers GetBillTos procedure below
End With

Dim UsersChoice As String
'Get the selected BillToID in the bound column to synchronize
with the ddl
UsersChoice = e.Item.Cells(6) .Text 'this works fine

'Since we're editing, show the BillTo dropdown list
grdLineItems.Co lumns(7).Visibl e = True

'Show the user's current selection in the ddl
Dim ddl As DropDownList
Dim TempValue As String

'This line does not find the control - returns Nothing
ddl = E.Item.FindCont rol("ddlBillTos ")
'...so this line throws an error - object not set
ddl.SelectedIte m.Value = UsersChoice

Session("POAddM ode") = False
lnkAdd.Visible = False

Catch ex As Exception
lblError.Text = ex.Message
End Try

End Sub

Protected Function GetBillTos(ByVa l DeptID As Integer) As DataTable
'This function returns all of the account numbers that the user can
select from, based on his/her department.

Dim ds As DataSet
Dim strSQL As String = "up_select_parm _billtos"
Dim strConn As String = Session("Connec tStringSQL").To String
'Dim NewConnection As SqlConnection = New SqlConnection(s trConn)
'Dim SqlDa As SqlDataAdapter

Try
Dim paramDeptID As New SqlParameter("@ DeptID", SqlDbType.Int, 4)
paramDeptID.Val ue = DeptID
ds = DataHandlerSqlC lient.ExecuteDa taset(strConn,
CommandType.Sto redProcedure, strSQL, paramDeptID)
Return ds.Tables(0)

Catch ex As Exception
Throw ex
End Try

End Function

Here is my html code for the bound column:
<asp:BoundColum n DataField="Bill ToID" ReadOnly="True" HeaderText="Acc ount #">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whit e"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
</asp:BoundColumn >

'Here is my html for the ddl
<asp:TemplateCo lumn Visible="False" HeaderText="Bil l to Account">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whit e"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
<EditItemTempla te>
'This is where the ddl is populated:
<asp:DropDownLi st id=ddlBillTos runat="server" DataValueField= "BillToID"
DataTextField=" BillToDesc" DataSource='<%#
GetBillTos(cint (Session("DeptI D"))) %>'>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>

[hansiman]

Take a look at this:

Private Sub dg_ItemDataBoun d(ByVal sender As Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles
dg.ItemDataBoun d

Dim u As New utils

' in EDIT MODE, make sure cbo have correct selected item (index)
If e.Item.ItemType = ListItemType.Ed itItem Then
Dim currValue As String = ""
Dim myDropDown As DropDownList
Dim idx As Integer

' cboGroup
currValue = CType(e.Item.Da taItem("Employe eGroup"), String)
myDropDown = CType(e.Item.Fi ndControl("cboE mployeeGroup"),
DropDownList)
idx =
myDropDown.Item s.IndexOf(myDro pDown.Items.Fin dByText(currVal ue))
myDropDown.Sele ctedIndex = idx


On Tue, 30 Nov 2004 11:43:05 -0800, "Richard"
<Ri*****@discus sions.microsoft .com> wrote:

I've seen articles on GotDotNet and elsewhere on how to put a ddl in a
datagrid, and have been able to implement this technique. For a new item,
among the datagrid columns there is the one ddl for the user to choose an
account description, and when the user saves, then the value is saved and
displayed in a bound column in the datagrid. So far so good.

The problem is when the user edits the line. The ddl is refreshed with all
of the choices as a result of the databind method in the grid's editcommand
event, but I need to synchronize the user's current choice that is in the
bound column and display that choice in the ddl. I can retrieve the value in
the bound column with no problem, but when I try to find the the ddl using
FindControl, it returns nothing.

Any help would be greatly appreciated!

Here is some code:

'This event occurs immediately when the user clicks on the Edit button in
the grid.
Private Sub grdLineItems_Ed itCommand(ByVal source As Object, ByVal e As
System.Web.UI. WebControls.Dat aGridCommandEve ntArgs) Handles
grdLineItems.E ditCommand

Dim ds As DataSet
Dim dv As DataView

Try
ds = CType(Session(" DSNewLineItems" ), DataSet)
dv = ds.Tables(0).De faultView

With grdLineItems
.EditItemIndex = e.Item.ItemInde x
.DataSource = dv
.DataBind() 'this triggers GetBillTos procedure below
End With

Dim UsersChoice As String
'Get the selected BillToID in the bound column to synchronize
with the ddl
UsersChoice = e.Item.Cells(6) .Text 'this works fine

'Since we're editing, show the BillTo dropdown list
grdLineItems.Co lumns(7).Visibl e = True

'Show the user's current selection in the ddl
Dim ddl As DropDownList
Dim TempValue As String

'This line does not find the control - returns Nothing
ddl = E.Item.FindCont rol("ddlBillTos ")
'...so this line throws an error - object not set
ddl.SelectedIte m.Value = UsersChoice

Session("POAddM ode") = False
lnkAdd.Visible = False

Catch ex As Exception
lblError.Text = ex.Message
End Try

End Sub

Protected Function GetBillTos(ByVa l DeptID As Integer) As DataTable
'This function returns all of the account numbers that the user can
select from, based on his/her department.

Dim ds As DataSet
Dim strSQL As String = "up_select_parm _billtos"
Dim strConn As String = Session("Connec tStringSQL").To String
'Dim NewConnection As SqlConnection = New SqlConnection(s trConn)
'Dim SqlDa As SqlDataAdapter

Try
Dim paramDeptID As New SqlParameter("@ DeptID", SqlDbType.Int, 4)
paramDeptID.Val ue = DeptID
ds = DataHandlerSqlC lient.ExecuteDa taset(strConn,
CommandType.St oredProcedure, strSQL, paramDeptID)
Return ds.Tables(0)

Catch ex As Exception
Throw ex
End Try

End Function

Here is my html code for the bound column:
<asp:BoundColu mn DataField="Bill ToID" ReadOnly="True" HeaderText="Acc ount #">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whi te"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
</asp:BoundColumn >

'Here is my html for the ddl
<asp:TemplateC olumn Visible="False" HeaderText="Bil l to Account">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whi te"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
<EditItemTempl ate>
'This is where the ddl is populated:
<asp:DropDownL ist id=ddlBillTos runat="server" DataValueField= "BillToID"
DataTextField= "BillToDesc " DataSource='<%#
GetBillTos(cin t(Session("Dept ID"))) %>'>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>

[Richard]

Thank you hansiman! This was what I needed!

"hansiman" wrote:

Take a look at this:

Private Sub dg_ItemDataBoun d(ByVal sender As Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles
dg.ItemDataBoun d

Dim u As New utils

' in EDIT MODE, make sure cbo have correct selected item (index)
If e.Item.ItemType = ListItemType.Ed itItem Then
Dim currValue As String = ""
Dim myDropDown As DropDownList
Dim idx As Integer

' cboGroup
currValue = CType(e.Item.Da taItem("Employe eGroup"), String)
myDropDown = CType(e.Item.Fi ndControl("cboE mployeeGroup"),
DropDownList)
idx =
myDropDown.Item s.IndexOf(myDro pDown.Items.Fin dByText(currVal ue))
myDropDown.Sele ctedIndex = idx


On Tue, 30 Nov 2004 11:43:05 -0800, "Richard"
<Ri*****@discus sions.microsoft .com> wrote:

I've seen articles on GotDotNet and elsewhere on how to put a ddl in a
datagrid, and have been able to implement this technique. For a new item,
among the datagrid columns there is the one ddl for the user to choose an
account description, and when the user saves, then the value is saved and
displayed in a bound column in the datagrid. So far so good.

The problem is when the user edits the line. The ddl is refreshed with all
of the choices as a result of the databind method in the grid's editcommand
event, but I need to synchronize the user's current choice that is in the
bound column and display that choice in the ddl. I can retrieve the value in
the bound column with no problem, but when I try to find the the ddl using
FindControl, it returns nothing.

Any help would be greatly appreciated!

Here is some code:

'This event occurs immediately when the user clicks on the Edit button in
the grid.
Private Sub grdLineItems_Ed itCommand(ByVal source As Object, ByVal e As
System.Web.UI. WebControls.Dat aGridCommandEve ntArgs) Handles
grdLineItems.E ditCommand

Dim ds As DataSet
Dim dv As DataView

Try
ds = CType(Session(" DSNewLineItems" ), DataSet)
dv = ds.Tables(0).De faultView

With grdLineItems
.EditItemIndex = e.Item.ItemInde x
.DataSource = dv
.DataBind() 'this triggers GetBillTos procedure below
End With

Dim UsersChoice As String
'Get the selected BillToID in the bound column to synchronize
with the ddl
UsersChoice = e.Item.Cells(6) .Text 'this works fine

'Since we're editing, show the BillTo dropdown list
grdLineItems.Co lumns(7).Visibl e = True

'Show the user's current selection in the ddl
Dim ddl As DropDownList
Dim TempValue As String

'This line does not find the control - returns Nothing
ddl = E.Item.FindCont rol("ddlBillTos ")
'...so this line throws an error - object not set
ddl.SelectedIte m.Value = UsersChoice

Session("POAddM ode") = False
lnkAdd.Visible = False

Catch ex As Exception
lblError.Text = ex.Message
End Try

End Sub

Protected Function GetBillTos(ByVa l DeptID As Integer) As DataTable
'This function returns all of the account numbers that the user can
select from, based on his/her department.

Dim ds As DataSet
Dim strSQL As String = "up_select_parm _billtos"
Dim strConn As String = Session("Connec tStringSQL").To String
'Dim NewConnection As SqlConnection = New SqlConnection(s trConn)
'Dim SqlDa As SqlDataAdapter

Try
Dim paramDeptID As New SqlParameter("@ DeptID", SqlDbType.Int, 4)
paramDeptID.Val ue = DeptID
ds = DataHandlerSqlC lient.ExecuteDa taset(strConn,
CommandType.St oredProcedure, strSQL, paramDeptID)
Return ds.Tables(0)

Catch ex As Exception
Throw ex
End Try

End Function

Here is my html code for the bound column:
<asp:BoundColu mn DataField="Bill ToID" ReadOnly="True" HeaderText="Acc ount #">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whi te"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
</asp:BoundColumn >

'Here is my html for the ddl
<asp:TemplateC olumn Visible="False" HeaderText="Bil l to Account">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whi te"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
<EditItemTempl ate>
'This is where the ddl is populated:
<asp:DropDownL ist id=ddlBillTos runat="server" DataValueField= "BillToID"
DataTextField= "BillToDesc " DataSource='<%#
GetBillTos(cin t(Session("Dept ID"))) %>'>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>

[Eric]

Another solution is to use the Edit Item Template and the SelectedIndex
property and bind that to a function that gives it the proper index to set
like so:
<EditItemTempla te>
<asp:DropDownLi st runat="server" DataSource='<%# GetDivisions() %>'
DataTextField=" Division" DataValueField= "DivisionID " ID="ddlEditDivi sions"
SelectedIndex=' <%#GetDivIdx(Da taBinder.Eval(C ontainer.DataIt em,"Division")) %

'/> </EditItemTemplat e>

"Richard" <Ri*****@discus sions.microsoft .com> wrote in message
news:74******** *************** ***********@mic rosoft.com... I've seen articles on GotDotNet and elsewhere on how to put a ddl in a
datagrid, and have been able to implement this technique. For a new item,
among the datagrid columns there is the one ddl for the user to choose an
account description, and when the user saves, then the value is saved and
displayed in a bound column in the datagrid. So far so good.

The problem is when the user edits the line. The ddl is refreshed with all
of the choices as a result of the databind method in the grid's editcommand event, but I need to synchronize the user's current choice that is in the
bound column and display that choice in the ddl. I can retrieve the value in the bound column with no problem, but when I try to find the the ddl using
FindControl, it returns nothing.

Any help would be greatly appreciated!

Here is some code:

'This event occurs immediately when the user clicks on the Edit button in
the grid.
Private Sub grdLineItems_Ed itCommand(ByVal source As Object, ByVal e As System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
grdLineItems.Ed itCommand

Dim ds As DataSet
Dim dv As DataView

Try
ds = CType(Session(" DSNewLineItems" ), DataSet)
dv = ds.Tables(0).De faultView

With grdLineItems
.EditItemIndex = e.Item.ItemInde x
.DataSource = dv
.DataBind() 'this triggers GetBillTos procedure below
End With

Dim UsersChoice As String
'Get the selected BillToID in the bound column to synchronize
with the ddl
UsersChoice = e.Item.Cells(6) .Text 'this works fine

'Since we're editing, show the BillTo dropdown list
grdLineItems.Co lumns(7).Visibl e = True

'Show the user's current selection in the ddl
Dim ddl As DropDownList
Dim TempValue As String

'This line does not find the control - returns Nothing
ddl = E.Item.FindCont rol("ddlBillTos ")
'...so this line throws an error - object not set
ddl.SelectedIte m.Value = UsersChoice

Session("POAddM ode") = False
lnkAdd.Visible = False

Catch ex As Exception
lblError.Text = ex.Message
End Try

End Sub

Protected Function GetBillTos(ByVa l DeptID As Integer) As DataTable
'This function returns all of the account numbers that the user can
select from, based on his/her department.

Dim ds As DataSet
Dim strSQL As String = "up_select_parm _billtos"
Dim strConn As String = Session("Connec tStringSQL").To String
'Dim NewConnection As SqlConnection = New SqlConnection(s trConn)
'Dim SqlDa As SqlDataAdapter

Try
Dim paramDeptID As New SqlParameter("@ DeptID", SqlDbType.Int, 4) paramDeptID.Val ue = DeptID
ds = DataHandlerSqlC lient.ExecuteDa taset(strConn,
CommandType.Sto redProcedure, strSQL, paramDeptID)
Return ds.Tables(0)

Catch ex As Exception
Throw ex
End Try

End Function

Here is my html code for the bound column:
<asp:BoundColum n DataField="Bill ToID" ReadOnly="True" HeaderText="Acc ount #"> <HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whit e"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
</asp:BoundColumn >

'Here is my html for the ddl
<asp:TemplateCo lumn Visible="False" HeaderText="Bil l to Account">
<HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign ="Left"
ForeColor="Whit e"></HeaderStyle>
<ItemStyle Wrap="False" HorizontalAlign ="Left"></ItemStyle>
<EditItemTempla te>
'This is where the ddl is populated:
<asp:DropDownLi st id=ddlBillTos runat="server" DataValueField= "BillToID"
DataTextField=" BillToDesc" DataSource='<%#
GetBillTos(cint (Session("DeptI D"))) %>'>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateCol umn>