Skip to content

Instantly share code, notes, and snippets.

Created September 18, 2014 17:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/7a3f64ac866e25b3bc29 to your computer and use it in GitHub Desktop.
Save anonymous/7a3f64ac866e25b3bc29 to your computer and use it in GitHub Desktop.
Radgrid with data function
<telerik:RadGrid ID="RadGrid1" runat="server" Skin="Hay" Width="582px" AutoGenerateColumns="False">
<MasterTableView >
<Columns>
<telerik:GridTemplateColumn UniqueName="TemplateColumn" DataField="month">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("month")%>'>></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn1" DataField="D1">
<HeaderTemplate>
<asp:Button ID="Button21" runat="server" Text="D1" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D1")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn2" DataField="D2">
<HeaderTemplate>
<asp:Button ID="Button22" runat="server" Text="D2" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D2")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn3" DataField="D3">
<HeaderTemplate>
<asp:Button ID="Button23" runat="server" Text="D3" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D3")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn4" DataField="D4">
<HeaderTemplate>
<asp:Button ID="Button24" runat="server" Text="D4" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D4")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn5" DataField="D5">
<HeaderTemplate>
<asp:Button ID="Button25" runat="server" Text="D5" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D5")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="TemplateColumn6" DataField="D6">
<HeaderTemplate>
<asp:Button ID="Button26" runat="server" Text="D6" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("D6")%>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
Private Function Data() As DataSet
Dim text As String = "SELECT month,D1,D2,D3,D4,D5,D6 FROM Test1 "
Dim cmd As New SqlCommand(text, con)
con.Open()
Dim da As New SqlDataAdapter(cmd)
Dim ds As New DataSet()
da.Fill(ds)
con.Close()
Return ds
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment