or
01.<ComponentArt:Grid ID="gdCards" runat="server" EnableViewState="false" PageSize="17" RunningMode="Client">02. <Levels>03. <ComponentArt:GridLevel04. DataKeyField="card_id">05. <Columns>06. <ComponentArt:GridColumn DataField="card_id" HeadingText="Card ID" Width="60" FixedWidth="true" DefaultSortDirection="Ascending" />07. <ComponentArt:GridColumn DataField="card_tp_desc" HeadingText="Card Type" />08. <ComponentArt:GridColumn DataField="trk_act_dt" HeadingText="Activate Date" Width="85" FixedWidth="true" FormatString="d" />09. <ComponentArt:GridColumn DataField="fname" HeadingText="First Name" />10. <ComponentArt:GridColumn DataField="lname" HeadingText="Last name" />11. <ComponentArt:GridColumn DataField="amt_left" HeadingText="Amount Left" FixedWidth="true" Width="75" />12. <ComponentArt:GridColumn DataField="needs_printed" HeadingText="Print?" FixedWidth="true" Width="50" ColumnType="CheckBox" />13. <ComponentArt:GridColumn DataField="card_num" HeadingText="Card #" FixedWidth="true" Width="100" />14. </Columns>15. </ComponentArt:GridLevel>16. </Levels>17.</ComponentArt:Grid>1.gdCards.DataSource = tblCards.DefaultView;2.gdCards.DataBind();01.<telerik:RadGrid ID="rgCards" runat="server" PageSize="17" AllowPaging="true">02. <MasterTableView AutoGenerateColumns="false" DataKeyNames="card_id">03. <Columns>04. <telerik:GridBoundColumn DataField="card_id" HeaderText="Card ID" HeaderStyle-Width="60"></telerik:GridBoundColumn>05. <telerik:GridBoundColumn DataField="card_tp_desc" HeaderText="Card Type"></telerik:GridBoundColumn>06. <telerik:GridBoundColumn DataField="trk_act_dt" HeaderText="Activate Date" HeaderStyle-Width="85" DataFormatString="{0:d}"></telerik:GridBoundColumn>07. <telerik:GridBoundColumn DataField="fname" HeaderText="First Name"></telerik:GridBoundColumn>08. <telerik:GridBoundColumn DataField="lname" HeaderText="Last name"></telerik:GridBoundColumn>09. <telerik:GridBoundColumn DataField="amt_left" HeaderText="Amount Left" HeaderStyle-Width="75" DataFormatString="{0:c}"></telerik:GridBoundColumn>10. <telerik:GridCheckBoxColumn DataField="needs_printed" HeaderText="Print?" HeaderStyle-Width="50"></telerik:GridCheckBoxColumn>11. <telerik:GridBoundColumn DataField="card_num" HeaderText="Card #" HeaderStyle-Width="100"></telerik:GridBoundColumn>12. </Columns>13. </MasterTableView>14.</telerik:RadGrid>1.rgCards.DataSource = tblCards.DefaultView;2.rgCards.DataBind();

RadWindow ConfirmWindow = new RadWindow();
<br>ConfirmWindow.NavigateUrl = "HolidayApproveDecline.aspx?Type=" + ((Byte)Type).ToString() + "&IDs=" + IDBuilder.ToString();<br>ConfirmWindow.Width = 450;
<br> ConfirmWindow.Height = 430;
<br> ConfirmWindow.ID = "wndUserAddHoliday";
<br> ConfirmWindow.VisibleOnPageLoad = true;
<br> ConfirmWindow.OnClientClose = "RefreshGrid";
<br> ConfirmWindow.VisibleStatusbar = false;
<br> ConfirmWindow.IconUrl = "../Images/address_book.png";
<br> ConfirmWindow.Title = "Bevestigen";
<br> WindowBehaviors Behaviors = new WindowBehaviors();
<br> Behaviors |= WindowBehaviors.Close;
<br> ConfirmWindow.Behaviors = Behaviors;<br>
<br> ConfirmWindow.Modal = true;<br> RadWindowManager MasterWindowManager = (RadWindowManager)this.Master.FindControl("MasterWindowManager");<br> MasterWindowManager.Windows.Add(ConfirmWindow);


protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e) { GridEditFormInsertItem insertItem = e.Item as GridEditFormInsertItem; string name = (insertItem["Name"].FindControl("txbName") as RadTextBox).Text; string Cate= (insertItem["IDCate"].FindControl("cboCate") as DropDownList).SelectedValue; RadAsyncUpload radAsyncUpload = insertItem["Pic"].FindControl("AsyncUpload1") as RadAsyncUpload; UploadedFile file = radAsyncUpload.UploadedFiles[0]; byte[] pic= new byte[file.InputStream.Length]; file.InputStream.Read(hinh, 0, (int)file.InputStream.Length); //file.InputStream.re //string hinh = con.ImageToByteArray(b);CONVERT(varbinary(30), @nvarcharParam) con.ExecuteSQL("INSERT INTO Hinh(IDCate, Name, Pic) VALUES(" + Cate+ ", N'" + name + "',CONVERT(varbinary(50),'" + pic + "'))"); }<telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" ShowStatusBar="True" GridLines="None" PageSize="3" OnNeedDataSource="RadGrid1_NeedDataSource" OnInsertCommand="RadGrid1_InsertCommand"> <PagerStyle Mode="NumericPages" AlwaysVisible="true"></PagerStyle> <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="ID"> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderText="ID" UniqueName="ID" SortExpression="ID" Visible="false"> <ItemTemplate> </ItemTemplate> <EditItemTemplate> </EditItemTemplate> <HeaderStyle Width="30%"></HeaderStyle> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Name" UniqueName="Name" SortExpression="Name"> <ItemTemplate> <asp:Label runat="server" ID="lblName" Text='<%# Eval("Name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadTextBox runat="server" Width="200px" ID="txbName" Text='<%# Eval("Name") %>'> </telerik:RadTextBox> <asp:RequiredFieldValidator ID="Requiredfieldvalidator1" runat="server" ControlToValidate="txbName" ErrorMessage="Please, enter a name!" Display="Dynamic" SetFocusOnError="true"></asp:RequiredFieldValidator> </EditItemTemplate> <HeaderStyle Width="30%"></HeaderStyle> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Cate" UniqueName="IDCate" DataField="IDCate" > <ItemTemplate> <asp:Label runat="server" ID="lblCate" Text='<%# Eval("CateName") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="cboCate" runat="server" Width="200px" DataTextField="Cate" DataValueField="IDCate" DataSource="<%# loadCate() %>" SelectedValue='<%# Bind("IDCate") %>' AppendDataBoundItems="True" > <asp:ListItem Selected="True" Text="Select" Value=""> </asp:ListItem> </asp:DropDownList> </EditItemTemplate> <ItemStyle VerticalAlign="Top"></ItemStyle> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Pic" HeaderText="Pic" UniqueName="Pic"> <ItemTemplate> <telerik:RadBinaryImage runat="server" ID="RadBinaryImage1" DataValue='<%# Eval("Pic") %>' AutoAdjustImageControlSize="false" Height="80px" Width="80px" ToolTip='<%#Eval("Pic", "Photo of {0}") %>' AlternateText='<%#Eval("Pic", "Photo of {0}") %>'></telerik:RadBinaryImage> </ItemTemplate> <EditItemTemplate> <telerik:RadAsyncUpload runat="server" ID="AsyncUpload1" OnClientFileUploaded="OnClientFileUploaded" AllowedFileExtensions="jpg,jpeg,png,gif" MaxFileSize="1048576" OnFileUploaded="AsyncUpload1_FileUploaded"> </telerik:RadAsyncUpload> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn Text="Delete" CommandName="Delete" ButtonType="ImageButton"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridButtonColumn> </Columns> <EditFormSettings> <EditColumn ButtonType="ImageButton"> </EditColumn> </EditFormSettings> <PagerStyle AlwaysVisible="True"></PagerStyle> </MasterTableView> </telerik:RadGrid>