How do you load a dropdownlist when edit is clicked in a datagrid

[Stanley J Mroczek]

How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Shiva]

Hi,
There are many ways to do it. One of them is to handle the ItemDataBound
event of the grid as given below:

if (e.Item.ItemTyp e == ListItemType.Ed itItem)
{
DropDownList ddl = (DropDownList) e.Item.FindCont rol ("deViews");
// Build a dataset or data table with data to populate the drop-down
ddl.DataSource = <datatable name>;
ddl.DataTextFie ld = <datatable col name>;
ddl.DataValueFi eld = <datatable col name>;
ddl.DataBind();
}

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:8E******** *************** ***********@mic rosoft.com...
How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Stanley J Mroczek]

I am trying to load a droplist in VB when the edit is clicked in a datagrid.
I tried to use OnDataBinding and loading the droplist in subroutine "loaddd".

I get this error Object reference not set to an instance of an object.

Here is the code:

<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" OnDataBinding=" loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As System.EventArg s)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub

"Shiva" wrote:

Hi,
There are many ways to do it. One of them is to handle the ItemDataBound
event of the grid as given below:

if (e.Item.ItemTyp e == ListItemType.Ed itItem)
{
DropDownList ddl = (DropDownList) e.Item.FindCont rol ("deViews");
// Build a dataset or data table with data to populate the drop-down
ddl.DataSource = <datatable name>;
ddl.DataTextFie ld = <datatable col name>;
ddl.DataValueFi eld = <datatable col name>;
ddl.DataBind();
}

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:8E******** *************** ***********@mic rosoft.com...
How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Shiva]

Try this one:

.... ...
<EditItemTempla te>
<asp:dropdownli st id="deViews" runat="server"> </asp:dropdownlis t>
.... ....
</EditItemTemplat e>
.... ...

Assuming the datagrid id is dgrd1,

Sub dgrd1_ItemDataB ound (sender As Object, e As DataGridItemEve ntArgs)
Handles dgrd1.ItemDataB ound
If (e.Item.ItemTyp e = ListItemType.Ed itItem) Then
DropDownList ddl = CType (e.Item.FindCon trol ("deViews"), DropDownList)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New SqlCommand("Get _All_TypeofOpti ons",
myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)
End While

ddl .DataSource = dtrControlOptio n
ddl .DataTextField = "TypeOption "
ddl .DataValueField = "IdTypeOpti on"
ddl .DataBind()

myConnection.Cl ose()
'BindOption()
Dim i As Integer
For i = 0 To ddl.Items.Count - 1
Dim opchk As String = ddl.Items(i).Va lue
If opchk = Session("typeof option") Then
ddl.Items(i).Se lected = True
End If
Next
End If
End Sub

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:CF******** *************** ***********@mic rosoft.com...
I am trying to load a droplist in VB when the edit is clicked in a datagrid.
I tried to use OnDataBinding and loading the droplist in subroutine
"loaddd".

I get this error Object reference not set to an instance of an object.

Here is the code:

<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" OnDataBinding=" loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As System.EventArg s)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub

"Shiva" wrote:

Hi,
There are many ways to do it. One of them is to handle the ItemDataBound
event of the grid as given below:

if (e.Item.ItemTyp e == ListItemType.Ed itItem)
{
DropDownList ddl = (DropDownList) e.Item.FindCont rol ("deViews");
// Build a dataset or data table with data to populate the drop-down
ddl.DataSource = <datatable name>;
ddl.DataTextFie ld = <datatable col name>;
ddl.DataValueFi eld = <datatable col name>;
ddl.DataBind();
}

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:8E******** *************** ***********@mic rosoft.com...
How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Stanley J Mroczek]

I still get this error. Object reference not set to an instance of an object.

Droplist deViews is it the EditItemTemplat e
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.NullRefe renceException: Object reference not set
to an instance of an object.

Source Error:
Line 211: End While
Line 212:
Line 213: c.DataSource = dtrControlOptio n
Line 214: deViews.DataTex tField = "TypeOption "
Line 215: deViews.DataVal ueField = "IdTypeOpti on"
Source File: C:\best\_Option Maint.ascx.vb Line: 213


<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False
Text='<%# DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As DataGridItemEve ntArgs)
Handles OptionGrid.Item DataBound

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub
"Shiva" wrote:

Try this one:

.... ...
<EditItemTempla te>
<asp:dropdownli st id="deViews" runat="server"> </asp:dropdownlis t>
.... ....
</EditItemTemplat e>
.... ...

Assuming the datagrid id is dgrd1,

Sub dgrd1_ItemDataB ound (sender As Object, e As DataGridItemEve ntArgs)
Handles dgrd1.ItemDataB ound
If (e.Item.ItemTyp e = ListItemType.Ed itItem) Then
DropDownList ddl = CType (e.Item.FindCon trol ("deViews"), DropDownList)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New SqlCommand("Get _All_TypeofOpti ons",
myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)
End While

ddl .DataSource = dtrControlOptio n
ddl .DataTextField = "TypeOption "
ddl .DataValueField = "IdTypeOpti on"
ddl .DataBind()

myConnection.Cl ose()
'BindOption()
Dim i As Integer
For i = 0 To ddl.Items.Count - 1
Dim opchk As String = ddl.Items(i).Va lue
If opchk = Session("typeof option") Then
ddl.Items(i).Se lected = True
End If
Next
End If
End Sub

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:CF******** *************** ***********@mic rosoft.com...
I am trying to load a droplist in VB when the edit is clicked in a datagrid.
I tried to use OnDataBinding and loading the droplist in subroutine
"loaddd".

I get this error Object reference not set to an instance of an object.

Here is the code:

<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" OnDataBinding=" loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As System.EventArg s)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub

"Shiva" wrote:

Hi,
There are many ways to do it. One of them is to handle the ItemDataBound
event of the grid as given below:

if (e.Item.ItemTyp e == ListItemType.Ed itItem)
{
DropDownList ddl = (DropDownList) e.Item.FindCont rol ("deViews");
// Build a dataset or data table with data to populate the drop-down
ddl.DataSource = <datatable name>;
ddl.DataTextFie ld = <datatable col name>;
ddl.DataValueFi eld = <datatable col name>;
ddl.DataBind();
}

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:8E******** *************** ***********@mic rosoft.com...
How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Shiva]

Hi,

Your ItemDataBound code is still using the dropdown list id that was given
in the EditItemTemplat e. However, this id cannot be used as is. You have to
find the dropdownlist control instance in the current daragrid row and use
that for further usage. If you look at the code in my reply, there is a line
like this:

DropDownList ddl = CType (e.Item.FindCon trol ("deViews"), DropDownList)

Use ddl wherever you are using deView.

Also, the whole dropdown list populating code should run only if the current
datagrid row is of EditItem type. So, you need this line as well:

If (e.Item.ItemTyp e = ListItemType.Ed itItem) Then
'Populate the dropdown...
End If

HTH.

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:63******** *************** ***********@mic rosoft.com...
I still get this error. Object reference not set to an instance of an
object.

Droplist deViews is it the EditItemTemplat e
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.NullRefe renceException: Object reference not set
to an instance of an object.

Source Error:
Line 211: End While
Line 212:
Line 213: c.DataSource = dtrControlOptio n
Line 214: deViews.DataTex tField = "TypeOption "
Line 215: deViews.DataVal ueField = "IdTypeOpti on"
Source File: C:\best\_Option Maint.ascx.vb Line: 213


<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False
Text='<%# DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As DataGridItemEve ntArgs)
Handles OptionGrid.Item DataBound

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" )
dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub
"Shiva" wrote:

Try this one:

.... ...
<EditItemTempla te>
<asp:dropdownli st id="deViews" runat="server"> </asp:dropdownlis t>
.... ....
</EditItemTemplat e>
.... ...

Assuming the datagrid id is dgrd1,

Sub dgrd1_ItemDataB ound (sender As Object, e As DataGridItemEve ntArgs)
Handles dgrd1.ItemDataB ound
If (e.Item.ItemTyp e = ListItemType.Ed itItem) Then
DropDownList ddl = CType (e.Item.FindCon trol ("deViews"), DropDownList)
Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New SqlCommand("Get _All_TypeofOpti ons",
myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" ) dtrControlOptio n.Rows.Add(drop RowOption)
End While

ddl .DataSource = dtrControlOptio n
ddl .DataTextField = "TypeOption "
ddl .DataValueField = "IdTypeOpti on"
ddl .DataBind()

myConnection.Cl ose()
'BindOption()
Dim i As Integer
For i = 0 To ddl.Items.Count - 1
Dim opchk As String = ddl.Items(i).Va lue
If opchk = Session("typeof option") Then
ddl.Items(i).Se lected = True
End If
Next
End If
End Sub

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:CF******** *************** ***********@mic rosoft.com...
I am trying to load a droplist in VB when the edit is clicked in a datagrid. I tried to use OnDataBinding and loading the droplist in subroutine
"loaddd".

I get this error Object reference not set to an instance of an object.

Here is the code:

<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option"
SortExpression= "IdTypeOpti on">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" OnDataBinding=" loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" ID="IdTypeOptio n" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>
</asp:TemplateCol umn>
Sub loaddd(ByVal sender As Object, ByVal e As System.EventArg s)

Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New
SqlCommand("Get _All_TypeofOpti ons", myConnection)

Dim dtrControlOptio n As New DataTable
Dim dropRowOption As DataRow

dtrControlOptio n.Columns.Add( _
New DataColumn("Typ eOption", GetType(String) ))

dtrControlOptio n.Columns.Add( _
New DataColumn("IdT ypeOption", GetType(String) ))

myConnection.Op en()

Dim Optionfile As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

While Optionfile.Read ()
dropRowOption = dtrControlOptio n.NewRow()
dropRowOption(" TypeOption") = Optionfile.Item ("TypeOption ")
dropRowOption(" IdTypeOption") = Optionfile.Item ("IdTypeOption" ) dtrControlOptio n.Rows.Add(drop RowOption)

End While

deViews.DataSou rce = dtrControlOptio n
deViews.DataTex tField = "TypeOption "
deViews.DataVal ueField = "IdTypeOpti on"
deViews.DataBin d()

myConnection.Cl ose()
BindOption()
Dim i As Integer
For i = 0 To deViews.Items.C ount - 1
Dim opchk As String = deViews.Items(i ).Value
Dim chk = deViews.DataVal ueField
If opchk = Session("typeof option") Then
deViews.Items(i ).Selected = True
End If
Next

End Sub

"Shiva" wrote:

Hi,
There are many ways to do it. One of them is to handle the ItemDataBound
event of the grid as given below:

if (e.Item.ItemTyp e == ListItemType.Ed itItem)
{
DropDownList ddl = (DropDownList) e.Item.FindCont rol ("deViews");
// Build a dataset or data table with data to populate the drop-down
ddl.DataSource = <datatable name>;
ddl.DataTextFie ld = <datatable col name>;
ddl.DataValueFi eld = <datatable col name>;
ddl.DataBind();
}

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:8E******** *************** ***********@mic rosoft.com...
How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Stanley J Mroczek]

I can not get the drowdownlist loaded. How do i do that?

"Stanley J Mroczek" wrote:

How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Shiva]

Hi,
Check these out. They have samples:
http://msdn.microsoft.com/library/de...tomcolumns.asp

http://www.4guysfromrolla.com/webtech/050801-1.shtml

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:7F******** *************** ***********@mic rosoft.com...
I can not get the drowdownlist loaded. How do i do that?

"Stanley J Mroczek" wrote:

How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Stanley J Mroczek]

That works find!! THANK YOU

!! Now my problem is when the dropdownlist ddlMan.DataSour ce =
Yearfile.Getall Manufacturer is changed

AutoPostBack=Tr ue OnSelectedIndex Changed= "newManufacture r"

How do get what was selected in (ddlMan)??

Sub newManufacturer (ByVal sender As Object, ByVal e As System.EventArg s)
Dim txtlbIIDManufac turer As Label
??????
End Sub
Private Sub loaddd(ByVal sender As System.Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles CarGrid.ItemDat aBound

If e.Item.ItemType = ListItemType.Ed itItem Then

Dim Yearfile As MaintenanceDB = New MaintenanceDB
Dim drv As DataRowView = CType(e.Item.Da taItem, DataRowView)
Dim currentYear As String = drv("IDCar")
Dim ddlyr As DropDownList = CType(e.Item.Ce lls(0).Controls (1),
DropDownList)
Dim ddlMan As DropDownList = CType(e.Item.Ce lls(1).Controls (1),
DropDownList)
Dim ddlModel As DropDownList =
CType(e.Item.Ce lls(2).Controls (1), DropDownList)

ddlyr.DataSourc e = Yearfile.GetAll Year
ddlyr.DataTextF ield = "YearDate"
ddlyr.DataValue Field = "IDYear"
ddlyr.DataBind( )

Dim i As Integer
For i = 0 To ddlyr.Items.Cou nt - 1
Dim opchk As String = ddlyr.Items(i). Value
Dim chk = ddlyr.DataValue Field
If opchk = Session("IdYear ") Then
ddlyr.Items(i). Selected = True
End If
Next

ddlMan.DataSour ce = Yearfile.Getall Manufacturer
ddlMan.DataText Field = "Manufactur er"
ddlMan.DataValu eField = "IDManufacturer "
ddlMan.DataBind ()

For i = 0 To ddlMan.Items.Co unt - 1
Dim opchk As String = ddlMan.Items(i) .Value
Dim chk = ddlMan.DataValu eField
If opchk = Session("IdIDMa nufacturer") Then
ddlMan.Items(i) .Selected = True
End If
Next


"Shiva" wrote:

Hi,
Check these out. They have samples:
http://msdn.microsoft.com/library/de...tomcolumns.asp

http://www.4guysfromrolla.com/webtech/050801-1.shtml

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:7F******** *************** ***********@mic rosoft.com...
I can not get the drowdownlist loaded. How do i do that?

"Stanley J Mroczek" wrote:

How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>

[Shiva]

This code gets the dropdownlist and from that you can get the selected
index. Have this in your newManufacturer () method:

Dim ddl As DropDownList
Dim item As DataGridItem = CarGrid.Items(C arGrid.EditItem Index)
If (Not item Is Nothing) Then
ddl = CType (item.FindContr ol ("deViews"), DropDownList)
'Now, refer ddl.SelectedIte m to get the selected item
End If

HTH

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:1C******** *************** ***********@mic rosoft.com...

That works find!! THANK YOU

!! Now my problem is when the dropdownlist ddlMan.DataSour ce =
Yearfile.Getall Manufacturer is changed

AutoPostBack=Tr ue OnSelectedIndex Changed= "newManufacture r"

How do get what was selected in (ddlMan)??

Sub newManufacturer (ByVal sender As Object, ByVal e As System.EventArg s)
Dim txtlbIIDManufac turer As Label
??????
End Sub
Private Sub loaddd(ByVal sender As System.Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles
CarGrid.ItemDat aBound

If e.Item.ItemType = ListItemType.Ed itItem Then

Dim Yearfile As MaintenanceDB = New MaintenanceDB
Dim drv As DataRowView = CType(e.Item.Da taItem, DataRowView)
Dim currentYear As String = drv("IDCar")
Dim ddlyr As DropDownList = CType(e.Item.Ce lls(0).Controls (1),
DropDownList)
Dim ddlMan As DropDownList = CType(e.Item.Ce lls(1).Controls (1),
DropDownList)
Dim ddlModel As DropDownList =
CType(e.Item.Ce lls(2).Controls (1), DropDownList)

ddlyr.DataSourc e = Yearfile.GetAll Year
ddlyr.DataTextF ield = "YearDate"
ddlyr.DataValue Field = "IDYear"
ddlyr.DataBind( )

Dim i As Integer
For i = 0 To ddlyr.Items.Cou nt - 1
Dim opchk As String = ddlyr.Items(i). Value
Dim chk = ddlyr.DataValue Field
If opchk = Session("IdYear ") Then
ddlyr.Items(i). Selected = True
End If
Next

ddlMan.DataSour ce = Yearfile.Getall Manufacturer
ddlMan.DataText Field = "Manufactur er"
ddlMan.DataValu eField = "IDManufacturer "
ddlMan.DataBind ()

For i = 0 To ddlMan.Items.Co unt - 1
Dim opchk As String = ddlMan.Items(i) .Value
Dim chk = ddlMan.DataValu eField
If opchk = Session("IdIDMa nufacturer") Then
ddlMan.Items(i) .Selected = True
End If
Next


"Shiva" wrote:

Hi,
Check these out. They have samples:
http://msdn.microsoft.com/library/de...tomcolumns.asp
http://www.4guysfromrolla.com/webtech/050801-1.shtml

"Stanley J Mroczek" <St************ *@discussions.m icrosoft.com> wrote in
message news:7F******** *************** ***********@mic rosoft.com...
I can not get the drowdownlist loaded. How do i do that?

"Stanley J Mroczek" wrote:

How do you load a dropdownlist when edit is clicked in a datagrid ?

<Columns>
<asp:BoundColum n DataField="Opti onDescription" ItemStyle-Wrap="True"
HeaderText="Opt ion Description"></asp:BoundColumn >
<asp:TemplateCo lumn runat="server" HeaderText="Id Type Option" ">
<itemtemplate >
<asp:label runat="server" Text='<%# DataBinder.Eval (Container.Data Item,
"TypeOption ") %>' />
<asp:label runat="server" ID="LlbTypeOpti on" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>'/>
</itemtemplate>
<EditItemTempla te>
<asp:dropdownli st id="deViews" ?????="loaddd"
runat="server"> </asp:dropdownlis t>
<asp:label runat="server" Visible=False Text='<%#
DataBinder.Eval (Container.Data Item, "IdTypeOpti on") %>' />
</EditItemTemplat e>