hi,
i am new new in telerik, and i am try print the selected row in grid or the update window(pop-up).
i can do this?
i am new new in telerik, and i am try print the selected row in grid or the update window(pop-up).
i can do this?
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> |
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
<!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 id="Head1" runat="server"> |
<style type="text/css"> |
.CommandStyle, .EditCommandStyle |
{ |
font-size:9.5pt; |
font-family:Arial; |
font-weight:bold; |
color:#003399; |
} |
</style> |
</head> |
<body> |
<form id="form1" runat="server"> |
<table width="100%" dir=rtl> |
<tr> |
<td align="center"> |
<table> |
<tr> |
<td> |
<img src="images/ramat.jpg" alt="" /> |
</td> |
</tr> |
<tr> |
<td dir="rtl"> |
<telerik:RadGrid ID="rgSapakim" runat="server" Skin="WebBlue" |
HeaderStyle-HorizontalAlign="Right" |
AllowAutomaticUpdates="True" AllowAutomaticInserts="True" |
DataSourceID="sqlDSSapakim" GridLines="None" Font-Bold="False" |
Font-Italic="False" Font-Overline="False" Font-Strikeout="False" |
Font-Underline="False" HorizontalAlign="Right" AllowFilteringByColumn="True" |
AllowSorting="True" AllowAutomaticDeletes="True" oninit="rgSapakim_Init"> |
<MasterTableView EditMode="PopUp" Width="100%" AutoGenerateColumns="False" DataKeyNames="Kod_sapak" CommandItemDisplay="TopAndBottom" |
DataSourceID="sqlDSSapakim" |
CellSpacing="-1" GridLines="None" allowmulticolumnsorting="True"> |
<CommandItemSettings AddNewRecordText="New" RefreshText="Refreh"></CommandItemSettings> |
<Columns> |
<telerik:GridBoundColumn DataField="Kod_sapak" DataType="System.Int32" |
HeaderText="קוד ספק" ReadOnly="True" SortExpression="Kod_sapak" |
UniqueName="Kod_sapak" FilterControlWidth="30px" |
CurrentFilterFunction="EqualTo"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridTemplateColumn DataField="Shem_sapak" HeaderText="שם הספק" |
SortExpression="Shem_sapak" UniqueName="Shem_sapak"> |
<EditItemTemplate> |
<asp:TextBox ID="Shem_sapakTextBox" runat="server" |
Text='<%# Bind("Shem_sapak") %>'></asp:TextBox> |
<span style="color: Red">*</span> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator_ShemSapak" ControlToValidate="Shem_sapakTextBox" |
ErrorMessage="שדה חובה" runat="server"> |
</asp:RequiredFieldValidator> |
</EditItemTemplate> |
<ItemTemplate> |
<asp:Label ID="Shem_sapakLabel" runat="server" Text='<%# Eval("Shem_sapak") %>'></asp:Label> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridBoundColumn EditFormColumnIndex="0" DataField="Shem_Male_ish_kesher" |
HeaderText="שם מלא איש קשר" |
SortExpression="Shem_Male_ish_kesher" UniqueName="column2"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn EditFormColumnIndex="0" DataField="Tel_misrad" HeaderText="טלפון משרד" |
SortExpression="Tel_misrad" UniqueName="Tel_misrad" |
AllowFiltering="False" AllowSorting="False"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn EditFormColumnIndex="0" DataField="Tel_nayad" HeaderText="טלפון נייד" |
SortExpression="Tel_nayad" UniqueName="Tel_nayad" |
AllowFiltering="False" AllowSorting="False"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn EditFormColumnIndex="0" DataField="Fax" HeaderText="פקס" SortExpression="Fax" |
UniqueName="Fax" AllowFiltering="False" |
AllowSorting="False"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn Visible="false" EditFormColumnIndex="1" DataField="Email" HeaderText="אימייל" |
SortExpression="Email" UniqueName="Email" FilterControlWidth="0px" |
AllowFiltering="False" AllowSorting="False"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn Visible="false" EditFormColumnIndex="1" DataField="Ta_doaar" HeaderText="תא דואר" |
SortExpression="Ta_doaar" UniqueName="Ta_doaar" FilterControlWidth="0px" |
AllowFiltering="False"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn Visible="false" EditFormColumnIndex="1" DataField="Ktovet" HeaderText="כתובת" |
SortExpression="Ktovet" UniqueName="Ktovet" FilterControlWidth="50px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridBoundColumn> |
<telerik:GridCheckBoxColumn EditFormColumnIndex="1" DataField="Status_sapak" HeaderText="סטאטוס ספק" |
SortExpression="Status_sapak" UniqueName="Status_sapak" |
FilterControlWidth="40px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridCheckBoxColumn> |
<telerik:GridNumericColumn Visible="false" EditFormColumnIndex="1" DataField="Hanacat_sapak_kvuaa" NumericType="Percent" |
DataType="System.Decimal" HeaderText="הנחת ספק קבועה" |
SortExpression="Hanacat_sapak_kvuaa" UniqueName="Hanacat_sapak_kvuaa" |
FilterControlWidth="30px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridNumericColumn> |
<telerik:GridDropDownColumn Visible="false" EditFormColumnIndex="2" DataField="Aminut" HeaderText="אמינות" |
SortExpression="Aminut" UniqueName="Aminut" DataSourceID="sqlDSZion_Sapakim" |
ListValueField="Kod_zion" ListTextField="Teur_zion" |
FilterControlWidth="30px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridDropDownColumn> |
<telerik:GridDropDownColumn Visible="false" EditFormColumnIndex="2" DataField="Mecirim" HeaderText="מחירים" |
SortExpression="Mecirim" UniqueName="Mecirim" DataSourceID="sqlDSZion_Sapakim" |
ListValueField="Kod_zion" ListTextField="Teur_zion" |
FilterControlWidth="30px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridDropDownColumn> |
<telerik:GridDropDownColumn Visible="false" EditFormColumnIndex="2" DataField="Nikayon" HeaderText="נקיון" |
SortExpression="Nikayon" UniqueName="Nikayon" DataSourceID="sqlDSZion_Sapakim" |
ListValueField="Kod_zion" ListTextField="Teur_zion" |
FilterControlWidth="30px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridDropDownColumn> |
<telerik:GridDropDownColumn Visible="false" EditFormColumnIndex="2" DataField="Amida_be_luz" HeaderText="עמידה בלוז" |
SortExpression="Amida_be_luz" UniqueName="Amida_be_luz" DataSourceID="sqlDSZion_Sapakim" |
ListValueField="Kod_zion" ListTextField="Teur_zion" |
FilterControlWidth="30px"> |
<ItemStyle HorizontalAlign="Right"></ItemStyle> |
</telerik:GridDropDownColumn> |
<telerik:GridTemplateColumn DataField="Zion_sofi" DataType="System.Decimal" |
EditFormColumnIndex="2" HeaderText="ציון סופי" SortExpression="Zion_sofi" |
UniqueName="Zion_sofi"> |
<EditItemTemplate> |
<asp:Label ID="Zion_sofiLabel" runat="server" Text='<%# Eval("Zion_sofi") %>'></asp:Label> |
</EditItemTemplate> |
<ItemTemplate> |
<asp:Label ID="Zion_sofiLabel" runat="server" Text='<%# Eval("Zion_sofi") %>'></asp:Label> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridButtonColumn CommandName="Edit" Text="עריכה" |
UniqueName="EditColumn"> |
<ItemStyle HorizontalAlign="Right" CssClass="CommandStyle" ForeColor="#003399"></ItemStyle> |
</telerik:GridButtonColumn> |
<telerik:GridButtonColumn CommandName="Delete" Text="מחיקה" ConfirmText="האם אתה בטוח שברצונך למחוק ספק זה?" ConfirmDialogType="RadWindow" |
ConfirmTitle="מחיקה" UniqueName="column1"> |
<ItemStyle CssClass="CommandStyle" ForeColor="#003399" /> |
</telerik:GridButtonColumn> |
</Columns> |
<EditFormSettings ColumnNumber="3" PopUpSettings-Modal="true" PopUpSettings-Width="750px" CaptionFormatString="עדכון ספק מספר : {0}" CaptionDataField="kod_sapak"> |
<EditColumn CancelText="ביטול" UpdateText="שמירה" InsertText="שמירה"></EditColumn> |
<FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditCommandStyle"></FormTableButtonRowStyle> |
<PopUpSettings Modal="True" Width="700px"></PopUpSettings> |
</EditFormSettings> |
<EditItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" |
Font-Underline="False" HorizontalAlign="Right" Wrap="True" /> |
</MasterTableView> |
<HeaderStyle HorizontalAlign="Right"></HeaderStyle> |
<ClientSettings> |
<Selecting AllowRowSelect="True" /> |
</ClientSettings> |
<EditItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Right" |
Wrap="True" /> |
<PagerStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" |
Font-Underline="False" HorizontalAlign="Right" Wrap="True" /> |
<CommandItemStyle Font-Bold="True" Font-Overline="True" Font-Size="11pt" /> |
</telerik:RadGrid> |
</td> |
</tr> |
</table> |
</td> |
</tr> |
</table> |
<asp:SqlDataSource ID="sqlDSSapakim" runat="server" |
ConnectionString="<%$ ConnectionStrings:ramatRachelConString %>" |
DeleteCommand="DELETE FROM [whk_Sapakim] WHERE [Kod_sapak] = @Kod_sapak" |
InsertCommand="INSERT INTO [whk_Sapakim] ([Shem_sapak], [Shem_Male_ish_kesher], [Tel_misrad], [Tel_nayad], [Fax], [Email], [Ta_doaar], [Ktovet], [Status_sapak], [Aminut], [Hanacat_sapak_kvuaa], [Mecirim], [Nikayon], [Amida_be_luz]) VALUES (@Shem_sapak, @Shem_Male_ish_kesher, @Tel_misrad, @Tel_nayad, @Fax, @Email, @Ta_doaar, @Ktovet, @Status_sapak, @Aminut, @Hanacat_sapak_kvuaa, @Mecirim, @Nikayon, @Amida_be_luz)" |
SelectCommand="SELECT [Kod_sapak], [Shem_sapak], [Shem_Male_ish_kesher], [Tel_misrad], [Tel_nayad], [Fax], [Email], [Ta_doaar], [Ktovet], [Status_sapak], [Aminut], [Hanacat_sapak_kvuaa], [Mecirim], [Nikayon], [Amida_be_luz], (Aminut + Mecirim + Nikayon + Amida_be_luz)/4 AS Zion_Sofi FROM [whk_Sapakim]" |
UpdateCommand="UPDATE [whk_Sapakim] SET [Shem_sapak] = @Shem_sapak, [Shem_Male_ish_kesher] = @Shem_Male_ish_kesher, [Tel_misrad] = @Tel_misrad, [Tel_nayad] = @Tel_nayad, [Fax] = @Fax, [Email] = @Email, [Ta_doaar] = @Ta_doaar, [Ktovet] = @Ktovet, [Status_sapak] = @Status_sapak, [Aminut] = @Aminut, [Hanacat_sapak_kvuaa] = @Hanacat_sapak_kvuaa, [Mecirim] = @Mecirim, [Nikayon] = @Nikayon, [Amida_be_luz] = @Amida_be_luz WHERE [Kod_sapak] = @Kod_sapak"> |
<DeleteParameters> |
<asp:Parameter Name="Kod_sapak" Type="Int32" /> |
</DeleteParameters> |
<UpdateParameters> |
<asp:Parameter Name="Shem_sapak" Type="String" /> |
<asp:Parameter Name="Shem_Male_ish_kesher" Type="String" /> |
<asp:Parameter Name="Tel_misrad" Type="String" /> |
<asp:Parameter Name="Tel_nayad" Type="String" /> |
<asp:Parameter Name="Fax" Type="String" /> |
<asp:Parameter Name="Email" Type="String" /> |
<asp:Parameter Name="Ta_doaar" Type="String" /> |
<asp:Parameter Name="Ktovet" Type="String" /> |
<asp:Parameter Name="Status_sapak" Type="String" /> |
<asp:Parameter Name="Aminut" Type="Int32" /> |
<asp:Parameter Name="Hanacat_sapak_kvuaa" Type="Decimal" /> |
<asp:Parameter Name="Mecirim" Type="Int32" /> |
<asp:Parameter Name="Nikayon" Type="Int32" /> |
<asp:Parameter Name="Amida_be_luz" Type="Int32" /> |
<asp:Parameter Name="Kod_sapak" Type="Int32" /> |
</UpdateParameters> |
<InsertParameters> |
<asp:Parameter Name="Shem_sapak" Type="String" /> |
<asp:Parameter Name="Shem_Male_ish_kesher" Type="String" /> |
<asp:Parameter Name="Tel_misrad" Type="String" /> |
<asp:Parameter Name="Tel_nayad" Type="String" /> |
<asp:Parameter Name="Fax" Type="String" /> |
<asp:Parameter Name="Email" Type="String" /> |
<asp:Parameter Name="Ta_doaar" Type="String" /> |
<asp:Parameter Name="Ktovet" Type="String" /> |
<asp:Parameter Name="Status_sapak" Type="String" /> |
<asp:Parameter Name="Aminut" Type="Int32" /> |
<asp:Parameter Name="Hanacat_sapak_kvuaa" Type="Decimal" /> |
<asp:Parameter Name="Mecirim" Type="Int32" /> |
<asp:Parameter Name="Nikayon" Type="Int32" /> |
<asp:Parameter Name="Amida_be_luz" Type="Int32" /> |
</InsertParameters> |
</asp:SqlDataSource> |
<telerik:RadScriptManager ID="RadScriptManager1" Runat="server"> |
</telerik:RadScriptManager> |
<asp:SqlDataSource ID="sqlDSZion_Sapakim" runat="server" |
ConnectionString="<%$ ConnectionStrings:ramatRachelConString %>" |
SelectCommand="SELECT [Kod_zion], [Teur_ zion] AS Teur_zion FROM [whk_Zion_Sapakim]"></asp:SqlDataSource> |
</form> |
</body> |
</html> |