Created
September 18, 2014 17:04
-
-
Save anonymous/7a3f64ac866e25b3bc29 to your computer and use it in GitHub Desktop.
Radgrid with data function
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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