or
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" CellSpacing="0" AllowPaging="True" GridLines="None" Skin="Default"> <MasterTableView> <Columns> <telerik:GridTemplateColumn DataField="AREA_ZIP_CODE" UniqueName="AREA_ZIP_CODE"> <HeaderTemplate> <asp:Label ID="Label2" runat="server" Text="AREA_ZIP_CODE"></asp:Label> </HeaderTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("AREA_ZIP_CODE") %>' Visible=false></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="AREA_ZIP_DESC" UniqueName="AREA_ZIP_DESC"> <HeaderTemplate> <asp:Label ID="Label3" runat="server" Text="AREA_ZIP_DESC"></asp:Label> </HeaderTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%# Eval("AREA_ZIP_DESC") %>' Visible=false></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="ACTIVE_FLAG" HeaderText="ACTIVE_FLAG" SortExpression="ACTIVE_FLAG" UniqueName="ACTIVE_FLAG"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Delete" UniqueName="Delete"> <ItemTemplate> <asp:Button ID="Button1" runat="server" Text="Delete" CommandName="Delete" /> <asp:Button ID="Button2" runat="server" Text="Cancel" CommandName="Cancel" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <PagerStyle AlwaysVisible="True" /></MasterTableView><FilterMenu EnableImageSprites="False"></FilterMenu> </telerik:RadGrid>
Protected Sub RadGrid1_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand
If e.CommandName = "Delete" Then
Delete(sender, e)
ElseIf e.CommandName = "Cancel" Then
Cancel(sender, e)
End If
End Sub
Protected Sub Delete(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs)
Dim rowNum As Integer = Convert.ToInt32(e.Item.ItemIndex)
Dim item As GridDataItem = RadGrid1.Items(rowNum)
Dim lb As Label
For Each row As GridDataItem In RadGrid1.Items
lb = item.FindControl("Label1")
If row.ItemIndex <> rowNum Then
lb.Visible = False
ElseIf row.ItemIndex = rowNum Then
lb.Visible = True
End If
Next
End Sub
Protected Sub RadGrid1_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
Dim da As New SqlDataAdapter
Dim con As New SqlConnection
Dim com As New SqlCommand
con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True"
con.Open()
com.Connection = con
com.CommandText = "SELECT * FROM [area_zip_table]"
da.SelectCommand = com
Dim dt As New DataTable
da.Fill(dt)
RadGrid1.DataSource = dt
End Sub
<telerik:RadWindowManager
ID="RadWindowManager1"
ShowContentDuringLoad="false" VisibleStatusbar="false"
runat="server"
VisibleOnPageLoad="false"
Width="894px"
Modal="true"
Behaviors="None"
EnableEmbeddedSkins="false"
EnableShadow="true"
OnClientClose="OnClientClose"
ReloadOnShow="false">
<Windows>
<telerik:RadWindow ID="radPopup" runat="server" KeepInScreenBounds="true" EnableShadow="true" />
</Windows>
</telerik:RadWindowManager><telerik:RadGrid runat="server" ID="radgrid" AutoGenerateColumns="false" OnNeedDataSource="radgrid_NeedDataSource"> <MasterTableView> <Columns> <telerik:GridTemplateColumn DataField="Text" HeaderText="foo"> <ItemTemplate> <%# Eval("Text") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="Text" HeaderText="bar" Visible="false" /> <telerik:GridEditCommandColumn HeaderText="Edit" /> </Columns> </MasterTableView></telerik:RadGrid>//OADate column for chart: DataColumn col = new DataColumn("OADate", typeof(System.Double)); dtable.Columns.Add(col);//Converting SQL Datetime values to OADate column int b = 0; foreach (DataRow row in dtMerArrCru.Rows) { row["OADate"] = Convert.ToDateTime(dtable.Rows[b][1]).ToOADate(); b++; }//Formatting chart: RadChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortDate; RadChart1.PlotArea.XAxis.Appearance.CustomFormat = "MM/dd/yyyy"; RadChart1.PlotArea.XAxis.IsZeroBased = false; RadChart1.PlotArea.XAxis.AutoScale = false; RadChart1.PlotArea.XAxis.AddRange(Convert.ToDouble(dtMerArrCru.Rows[0]["OADate"]), Convert.ToDouble(dtMerArrCru.Rows[dtMerArrCru.Rows.Count - 1]["OADate"]), 1); RadChart1.DataGroupColumn = "Type"; RadChart1.DataManager.ValuesXColumn = "OADate"; RadChart1.DataManager.ValuesYColumns = new string[] { "Quantity" }; RadChart1.DataSource = dtable; RadChart1.DataBind();