hi
I am trying to populate a dropdownlist(ddl2) based on a the selectedvalue of ddl1 ?
D
put the DataConnection class in the App_Code folder:
I am trying to populate a dropdownlist(ddl2) based on a the selectedvalue of ddl1 ?
D
Imports Telerik.Web.UI |
Partial Class dropdowninformtemplate |
Inherits System.Web.UI.Page |
Protected Sub RadGrid1_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemCreated |
If e.Item.ItemType = Telerik.Web.UI.GridItemType.EditFormItem And e.Item.IsInEditMode Then |
Dim item As GridEditFormItem |
item = e.Item |
Dim ddl As DropDownList = CType(item.FindControl("ddl1"), DropDownList) |
Dim cmb As RadComboBox = item.FindControl("cmb") |
AddHandler ddl.SelectedIndexChanged, AddressOf ddl1_SelectedIndexChanged |
ddl.DataSource = DataConnection.GetDataTable("select * from products") |
ddl.DataTextField = "productname" |
ddl.DataValueField = "productid" |
ddl.DataBind() |
End If |
End Sub |
Protected Sub ddl1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) |
'populate ddl2 |
End Sub |
Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand |
If e.Item.IsInEditMode Then |
Dim item As GridEditFormItem |
item = CType(e.Item, GridEditFormItem) |
Dim ddl2 As DropDownList = item.FindControl("ddl2") |
End If |
End Sub |
Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource |
RadGrid1.DataSource = DataConnection.GetDataTable("select * from customers") |
End Sub |
End Class |
put the DataConnection class in the App_Code folder:
Imports Microsoft.VisualBasic |
Imports System.Data |
Imports System.Data.SqlClient |
Public Class DataConnection |
Public Shared Function GetDataTable(ByVal query As String) As DataTable |
Dim ConnString As String = ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString |
Dim conn As SqlConnection = New SqlConnection(ConnString) |
Dim adapter As SqlDataAdapter = New SqlDataAdapter |
adapter.SelectCommand = New SqlCommand(query, conn) |
Dim table1 As New DataTable |
conn.Open() |
Try |
adapter.Fill(table1) |
Finally |
conn.Close() |
End Try |
Return table1 |
End Function |
End Class |
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="dropdowninformtemplate.aspx.vb" |
Inherits="dropdowninformtemplate" %> |
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head runat="server"> |
<title></title> |
</head> |
<body> |
<form id="form1" runat="server"> |
<div> |
<telerik:RadScriptManager ID="RadScriptManager1" runat="server"> |
</telerik:RadScriptManager> |
<telerik:RadGrid ID="RadGrid1" runat="server"> |
<MasterTableView EditMode="EditForms"> |
<Columns> |
<telerik:GridEditCommandColumn> |
</telerik:GridEditCommandColumn> |
</Columns> |
<EditFormSettings EditFormType="Template"> |
<FormTemplate> |
<asp:DropDownList ID="ddl1" runat="server" AutoPostBack="true"> |
</asp:DropDownList> |
<asp:DropDownList ID="ddl2" runat="server"> |
</asp:DropDownList> |
</FormTemplate> |
</EditFormSettings> |
</MasterTableView> |
</telerik:RadGrid> |
</div> |
</form> |
</body> |
</html> |