or
<
style type="text/css">
/* Set the desired properties to the custom buttons */
a.adminLoginStyleClass.rtbWrap .rtbText
{
font-size: 12px;
background: url('./images/administration.png') no-repeat left center;
}
a.logoffStyleClass.rtbWrap .rtbText
{
font-size: 12px;
background: url('./images/logoff.png') no-repeat left center;
}
</
style>
<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" AllowPaging="True" AllowFilteringByColumn="true" AllowSorting="True" AutoGenerateColumns="false" PageSize="50" Height="410px" Skin="Hay"> <MasterTableView DataKeyNames="customerId" AutoGenerateColumns="false"> <Columns> <telerik:GridBoundColumn DataField="Edit" HeaderText="<span style='visibility: hidden;'>a</span>" SortExpression="Edit" UniqueName="Edit" HeaderStyle-Width="40px" AllowFiltering="false" AllowSorting="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="name" HeaderText="Name" SortExpression="name" UniqueName="name"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="address" HeaderText="Address" SortExpression="address" UniqueName="address"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="city" HeaderText="City" SortExpression="city" UniqueName="city"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="state" HeaderText="State" SortExpression="state" UniqueName="state"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="zip" HeaderText="Zip" SortExpression="zip" UniqueName="zip"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="phone" HeaderText="Phone" SortExpression="phone" UniqueName="phone"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="fax" HeaderText="Fax" SortExpression="fax" UniqueName="fax"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="email" HeaderText="Email" SortExpression="email" UniqueName="email"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="additional" HeaderText="Additional Info" SortExpression="additional" UniqueName="additional" ItemStyle-Width="200"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <HeaderStyle Width="120px" /> <ClientSettings> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True"> </Scrolling> </ClientSettings></telerik:RadGrid> Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not (Page.IsPostBack) Then RadGrid1.DataSource = myFunctions.customerListTable() RadGrid1.DataBind() End If End Sub Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource RadGrid1.DataSource = myFunctions.customerListTable() End Sub'this function creates a data table for the customer list Public Shared Function customerListTable() Dim sql = "SELECT customerId, name, address, city, state, zip, phone, email, fax, additional FROM Customers" & _ " WHERE deleted = 'false' ORDER BY name" Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("connection").ToString Using myConn As New SqlConnection(conn) 'create the table Dim myTable As New DataTable myTable.Columns.Add("customerId") myTable.Columns.Add("edit") myTable.Columns.Add("name") myTable.Columns.Add("address") myTable.Columns.Add("city") myTable.Columns.Add("state") myTable.Columns.Add("zip") myTable.Columns.Add("phone") myTable.Columns.Add("email") myTable.Columns.Add("fax") myTable.Columns.Add("additional") myConn.Open() Dim cmd As New SqlCommand(sql, myConn) Dim reader = cmd.ExecuteReader While reader.Read() myTable.Rows.Add(reader("customerId"), "<a href=""../Customers/EditCustomer.aspx?id" & reader("customerId") & """>Edit</a>", _ reader("name"), reader("address"), reader("city"), reader("state"), reader("zip"), _ reader("phone"), reader("email"), reader("fax"), reader("additional")) End While 'while reader.read myConn.Close() Return myTable End Using 'using myConn End Function 'customerListTable