or
<telerik:RadGrid runat="server" ID="gvPatientSearch" DataSourceID="dsPatients" AllowAutomaticInserts="true"> <ClientSettings> <ClientEvents OnPopUpShowing="PopUpShowing" /> </ClientSettings> <MasterTableView DataKeyNames="patientID" CommandItemDisplay="Top" Width="100%" EditMode="PopUp"> <EditFormSettings UserControlName="~/App_Assets/Controls/patientControl.ascx" EditFormType="WebUserControl" CaptionDataField="lastName" CaptionFormatString="Edit Patient Record for {0}" InsertCaption="New Patient" FormStyle-Width="600px" > </EditFormSettings> <CommandItemSettings ShowAddNewRecordButton="true" AddNewRecordText="Add New Patient" /> <Columns> ... <telerik:GridEditCommandColumn /> </Columns> </MasterTableView> </telerik:RadGrid> <%@ Control Language="VB" AutoEventWireup="false" CodeFile="patientControl.ascx.vb" Inherits="App_Assets_Controls_patientControl" %> <div align="center"> <asp:FormView runat="server" ID="fvPatients" DataKeyNames="patientID" DataSourceID="dsPatients" DefaultMode="Insert"> <EditItemTemplate> <table class="searchTable" style="border: 1px solid #2a5690; background-color: #f7f5f0;" cellpadding="3" cellspacing="1" width="99%"> <tr> <td align="right">Last Name:</td> <td> <telerik:RadTextBox runat="server" ID="txtLastName" Text='<%# Bind("lastName") %>' MaxLength="50" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtLastName" CssClass="errorMessage">«</asp:RequiredFieldValidator> </td> </tr> <tr> <td align="right">First Name:</td> <td> <telerik:RadTextBox runat="server" ID="txtFirstName" Text='<%# Bind("firstName") %>' MaxLength="50" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtFirstName" CssClass="errorMessage">«</asp:RequiredFieldValidator> </td> </tr> <tr> <td align="right">Middle Name:</td> <td> <telerik:RadTextBox runat="server" ID="txtMiddleName" Text='<%# Bind("middleName") %>' MaxLength="50" /> </td> </tr> <tr> <td align="right" valign="top">Sex:</td> <td valign="top"> <asp:RadioButtonList runat="server" RepeatDirection="Horizontal" ID="cboSex" SelectedValue='<%# Bind("sex") %>'> <asp:ListItem Text="Male" Value="M" /> <asp:ListItem Text="Female" Value="F" /> </asp:RadioButtonList> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="cboSex" CssClass="errorMessage">please choose sex</asp:RequiredFieldValidator> </td> </tr> <tr> <td align="right">Date of Birth:</td> <td> <telerik:RadDateInput MinDate="01/01/1900" runat="server" ID="dteDateOfBirth" SelectedDate='<%# Bind("dateOfBirth") %>' /> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="dteDateOfBirth" CssClass="errorMessage">«</asp:RequiredFieldValidator> </td> </tr> <tr> <td align="right">SSN:</td> <td> <telerik:RadMaskedTextBox ID="txtSSN" runat="server" Mask="###-##-####" TextWithLiterals="-" Width="75px" Text='<%# Bind("ssn") %>' /> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtSSN" CssClass="errorMessage">«</asp:RequiredFieldValidator> </td> </tr> <tr> <td align="right">Phone Number:</td> <td> <telerik:RadMaskedTextBox runat="server" ID="txtPhoneNumber" Mask="###-###-####" TextWithLiterals="-" MaxLength="15" Text='<%# Bind("phoneNumber") %>' /> </td> </tr> <tr> <td align="right">Alternate (Cell) Phone Number:</td> <td><telerik:RadMaskedTextBox runat="server" ID="txtPhoneNumber2" Mask="###-###-####" TextWithLiterals="-" MaxLength="15" Text='<%# Bind("phoneNumber2") %>' /></td> </tr> <tr> <td align="right">Address Line 1:</td> <td><telerik:RadTextBox runat="server" ID="txtAddressLine1" MaxLength="150" Text='<%# Bind("addressLine1") %>' /></td> </tr> <tr> <td align="right">Address Line 2:</td> <td><telerik:RadTextBox runat="server" ID="txtAddressLine2" MaxLength="150" Text='<%# Bind("addressLine2") %>' /></td> </tr> <tr> <td align="right">City:</td> <td><telerik:RadTextBox runat="server" ID="txtCity" EmptyMessage="enter city" MaxLength="50" Text='<%# Bind("city") %>' /></td> </tr> <tr> <td align="right">State:</td> <td><telerik:RadTextBox runat="server" ID="txtState" EmptyMessage="enter state" MaxLength="2" Text='<%# Bind("state") %>' /></td> </tr> <tr> <td align="right">Zip Code:</td> <td><telerik:RadTextBox runat="server" ID="txtZipCode" EmptyMessage="enter zip code" MaxLength="10" Text='<%# Bind("zipCode") %>' /></td> </tr> <tr> <td align="right">Email Address:</td> <td><telerik:RadTextBox runat="server" ID="txtEmailAddress" Text='<%# Bind("emailAddress") %>' /></td> </tr> <tr> <td align="right">Hospital Patient ID:</td> <td><telerik:RadTextBox runat="server" ID="txtHospitalPatientID" Text='<%# Bind("hospitalPatientID") %>' /></td> </tr> <tr> <td></td> <td><telerik:RadButton CommandName="Insert" runat="server" ID="btnSave" Text="Add Patient" /></td> </tr> </table> </EditItemTemplate> </asp:FormView> </div> <asp:SqlDataSource runat="server" ID="dsPatients" SelectCommandType="StoredProcedure" SelectCommand="sp_Patients" InsertCommandType="StoredProcedure" InsertCommand="sp_Patients" UpdateCommandType="StoredProcedure" UpdateCommand="sp_Patients" > <SelectParameters> <asp:Parameter Name="Action" DefaultValue="SELECT" /> <asp:QueryStringParameter Name="patientID" QueryStringField="patientID" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="Action" DefaultValue="INSERT" /> <asp:CookieParameter Name="lastUpdatedBy" CookieName="userName" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Action" DefaultValue="UPDATE" /> <asp:CookieParameter Name="lastUpdatedBy" CookieName="userName" /> </UpdateParameters> </asp:SqlDataSource> protected void gridTxnEnquiry_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e){ if (e.Item is GridDataItem) { GridDataItem dataItem = (GridDataItem)e.Item; DataRow dr = ((DataRowView)e.Item.DataItem).Row; // Set the Back Colour depending on the Record Type int rectype = int.Parse(dr["RecordType"].ToString()); switch (rectype) { case 0: dataItem.BackColor = Color.Blue break; case 1: dataItem.BackColor = Color.Red break; } }}<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="editormem.aspx.vb" Inherits="WebApplication4.editormem" %><!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"> <telerik:RadScriptManager ID="ccc" runat="server"> </telerik:RadScriptManager> <div> <asp:UpdatePanel ID="up" runat="server" ChildrenAsTriggers="true" UpdateMode="Conditional"> <ContentTemplate> <asp:Button ID="aa" runat="server" Text="Hit me multiple times" /> <telerik:RadEditor ID="re" runat="server" ContentAreaMode="Div"> <Content> Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test<br />Test </Content> </telerik:RadEditor> </ContentTemplate> </asp:UpdatePanel> </div> </form></body></html>protected void RadButton2_Click(object sender, EventArgs e){ foreach (GridDataItem item in RadGrid1.SelectedItems) { //GridDataItem item = (GridDataItem)RadGrid1.SelectedItems; int UserID = Convert.ToInt16(item["UserID"].ToString()); string Type = "D"; DateTime Date = DateTime.Now; string Description = "Monthly Storage Fee - Tag: " + (item["PackageTag"].ToString()) + Label3.Text; Int32 AmountDue = Convert.ToInt32((item["AmtDue"].ToString())); string connectionString = ConfigurationManager.ConnectionStrings["foo"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); try { SqlCommand cmd = new SqlCommand("INSERT INTO Billing (UserID, Type, Date, Description, Amount) VALUES (@UserID, @Type, @Date, @Description, @AmountDue)", connection); cmd.Parameters.AddWithValue("@UserID", UserID); cmd.Parameters.AddWithValue("@Type", Type); cmd.Parameters.AddWithValue("@Date", Date); cmd.Parameters.AddWithValue("@Description", Description); cmd.Parameters.AddWithValue("@AmountDue", AmountDue); connection.Open(); cmd.ExecuteNonQuery(); } catch { Label4.Text = "uh oh"; } finally { connection.Close(); } } //Label4.Text = "Fees successfully inserted";}