or
SELECT
.....ISNULL(KP.dbo.PH.qc,'') as qc,ISNULL(KP.dbo.PH.di,' ') as di
.....
..... FROM KP.dbo.PH<telerik:RadGrid ID="RadGridInspection" CssClass="RadGridCustomClass" AllowSorting="false" AllowPaging="true" AllowFilteringByColumn="false" AutoGenerateColumns="false" runat="server" ClientSettings-EnableAlternatingItems="False" AlternatingItemStyle-BorderStyle="Solid" BorderStyle="Solid" EditItemStyle-BorderStyle="Solid" ItemStyle-BorderStyle="Solid"> <MasterTableView AutoGenerateColumns="False" > <Columns > <telerik:GridBoundColumn DataField="di" UniqueName ="di" HeaderText="DI" ItemStyle-BorderColor="Gray" ItemStyle-BorderStyle="Solid"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ai" UniqueName ="ai" HeaderText="AI" ItemStyle-BorderColor="Gray" ItemStyle-BorderStyle="Solid"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="qc" UniqueName ="qc" HeaderText="QC" ItemStyle-BorderColor="Gray" ItemStyle-BorderStyle="Solid"> </telerik:GridBoundColumn></Columns> </MasterTableView> </telerik:RadGrid>Protected Sub RadGridInspection_PreRender(sender As Object, e As EventArgs) Handles RadGridInspection.PreRender For Each dataItem As GridDataItem In RadGridInspection.Items For Each col As GridColumn In RadGridInspection.Columns 'If dataItem(col.UniqueName).Text = String.Empty Then If String.IsNullOrEmpty(dataItem(col.UniqueName).Text) Or dataItem(col.UniqueName).Text = " " Then dataItem(col.UniqueName).Text = " " End If Next Next End SubHi All,
I have requirement in my project to select a required folder path using folder browse window.
After selecting the path, file name is appended and the file is generated in the selected path
How to implement it in Telerik
Thanks In Advance
<Rad:RadGrid Height="350px" Width="100%" ID="RadGridFields" Skin="Windows7" BorderStyle="Solid" runat="server" AllowPaging="True" GridLines="None" AllowMultiRowEdit="true" AllowAutomaticUpdates="True" AllowSorting="True" AllowMultiRowSelection="false" OnUpdateCommand="RadGridFields_UpdateCommand" OnNeedDataSource="RadGridFields_NeedDataSource" OnItemDataBound="RadGridFields_ItemDataBound" AutoGenerateColumns="false"> <MasterTableView TableLayout="Fixed" DataKeyNames="LabelText" EditMode="InPlace" AllowPaging="false" Width="100%" NoMasterRecordsText=""> <Columns> <Rad:GridEditCommandColumn HeaderText="Edit" HeaderStyle-Width="55px" ButtonType="ImageButton" EditText="Edit" UniqueName="EditCol" /> <Rad:GridTemplateColumn UniqueName="LabelText" HeaderText="LabelText" HeaderStyle-Width="200px" DataField="LabelText"> <ItemTemplate> <%#DataBinder.Eval(Container.DataItem, "LabelText")%> </ItemTemplate> <EditItemTemplate> <Rad:RadTextBox runat="server" ID="textLabel" AutoPostBack="true" Height="140px" Width="200px" /> </EditItemTemplate> </Rad:GridTemplateColumn> <Rad:GridTemplateColumn UniqueName="Mandatory" HeaderText="Mandatory" HeaderStyle-Width="80px" DataField="Mandatory"> <ItemTemplate> <%#DataBinder.Eval(Container.DataItem, "Mandatory")%> </ItemTemplate> <EditItemTemplate> <Rad:RadComboBox runat="server" ID="comboMandatory" AutoPostBack="true" HighlightTemplatedItems="true" Height="140px" Width="80px" DropDownWidth="200px" OnSelectedIndexChanged="comboMandatory_SelectedIndexChanged" > <Items> <Rad:RadComboBoxItem Value="False" Text="False" /> <Rad:RadComboBoxItem Value="True" Text="True" /> </Items> </Rad:RadComboBox> </EditItemTemplate> </Rad:GridTemplateColumn> <Rad:GridTemplateColumn UniqueName="DefaultText" HeaderText="DefaultText" HeaderStyle-Width="200px" DataField="DefaultText"> <ItemTemplate> <%#DataBinder.Eval(Container.DataItem, "DefaultText")%> </ItemTemplate> <EditItemTemplate> <Rad:RadTextBox runat="server" ID="textDefault" AutoPostBack="true" Height="140px" Width="200px" /> </EditItemTemplate> </Rad:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings> <ClientEvents OnRowDblClick="editThisRow" OnCommand="onClientCommand" /> <Scrolling AllowScroll="true" ScrollHeight="100%" /> <Selecting AllowRowSelect="true" /> </ClientSettings> </Rad:RadGrid>protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RadGridFields.DataSource = gridTable; RadGridFields.DataBind(); foreach (GridDataItem item in RadGridFields.MasterTableView.Items) { item.Edit = true; } RadGridFields.Rebind(); } } }foreach (GridDataItem item in RadGridFields.MasterTableView.Items) { item.Edit = true; } RadGridFields.Rebind(); }