Questions on UI for ASP.NET AJAX Forum

110,745 questions

1 answer

158 views

Hi, i want to provide a upload function for user in Grid edit mode and then provide a download link in grid view.

the attachment file will save in another table (different linqdatasource with grid), how can i databind the download link ? (will use "UserID" as key in both table)

moreover, my upload function not works, it cannot save the bindary file to the table. please help.

<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"

DataSourceID="ODS_attendance" width="1200" PageSize="15"

GridLines="None" style="margin-top: 0px" AllowFilteringByColumn="True"

AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"

ShowStatusBar="True" AllowAutomaticDeletes="false" AllowAutomaticInserts="false"

AllowAutomaticUpdates="True">

<GroupingSettings CaseSensitive="false" />

<MasterTableView AutoGenerateColumns="False"

DataKeyNames="UserID" DataSourceID="ODS_attendance"

AllowFilteringByColumn="False" AllowPaging="False"

CommandItemDisplay="Top" OverrideDataSourceControlSorting="true" >

<CommandItemSettings ExportToPdfText="Export to PDF" ShowAddNewRecordButton="false" />

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"

Visible="True">

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"

Visible="True">

</ExpandCollapseColumn>

<Columns>

<telerik:GridEditCommandColumn UniqueName="EditCommandColumn" HeaderStyle-Width="50">

</telerik:GridEditCommandColumn>

<telerik:GridBoundColumn UniqueName="UserID" DataField="UserID" HeaderText="UserID"

ReadOnly="True" HeaderStyle-Width="5%" Visible="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Employee_No" DataType="System.String"

FilterControlAltText="Filter Employee column" HeaderText="Employee No" ReadOnly="True"

SortExpression="Employee_No" UniqueName="Employee_No" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Employee_Display_Name" DataType="System.String"

FilterControlAltText="Filter Employee column" HeaderText="Employee" ReadOnly="True"

SortExpression="Employee_Display_Name" UniqueName="Employee_Display_Name" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Department" DataType="System.String"

FilterControlAltText="Filter Department column" HeaderText="Reporting office" ReadOnly="True"

SortExpression="Department" UniqueName="Department" >

</telerik:GridBoundColumn

<telerik:GridBoundColumn DataField="Start_Time"

FilterControlAltText="Filter Start Time column" HeaderText="Start Date"

SortExpression="Start_Time" UniqueName="Start_Date" DataFormatString="{0: dd-MMM-yyyy}" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="End_Time"

FilterControlAltText="Filter End Time column" HeaderText="End Date"

SortExpression="End_Time" UniqueName="End_Date" DataFormatString="{0: dd-MMM-yyyy}" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Start_Time"

FilterControlAltText="Filter Start Time column" HeaderText="Start Time"

SortExpression="Start_Time" UniqueName="Start_Time" DataFormatString="{0: hh:mm tt}" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="End_Time"

FilterControlAltText="Filter End Time column" HeaderText="End Time"

SortExpression="End_Time" UniqueName="End_Time" DataFormatString="{0: hh:mm tt}" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TotalDays"

FilterControlAltText="Filter TotalDays column" HeaderText="Total Day"

SortExpression="TotalDays" UniqueName="TotalDays" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TotalHours"

FilterControlAltText="Filter TotalDTotalHoursays column" HeaderText="Total Hour"

SortExpression="TotalHours" UniqueName="TotalHours" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Type"

FilterControlAltText="Filter Type column" HeaderText="Type"

SortExpression="Type" UniqueName="Type" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="pre_test_score"

FilterControlAltText="Filter pre_test_score column" HeaderText="Pre test score"

SortExpression="pre_test_score" UniqueName="pre_test_score" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn

<telerik:GridBoundColumn DataField="post_test_score"

FilterControlAltText="Filter post_test_score column" HeaderText="Post test score"

SortExpression="post_test_score" UniqueName="post_test_score" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn

<telerik:GridBoundColumn DataField="Result"

FilterControlAltText="Filter Result column" HeaderText="Result"

SortExpression="Result" UniqueName="Result" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn

<telerik:GridBoundColumn DataField="Cost"

FilterControlAltText="Filter Cost column" HeaderText="Cost"

SortExpression="Cost" UniqueName="Cost" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Remarks"

FilterControlAltText="Filter Remarks column" HeaderText="Remarks"

SortExpression="Remarks" UniqueName="Remarks" AllowFiltering="true" AllowSorting="true">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn>

<ItemTemplate>

<asp:LinkButton ID="DownloadButton" runat="server"

CommandName="DownloadAttachment" Text="Download">

</asp:LinkButton>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadUpload ID="AttachmentUpload" runat="server">

</telerik:RadUpload>

</EditItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<EditFormSettings EditFormType="Template">

<EditColumn FilterControlAltText="Filter EditCommandColumn1 column"

UniqueName="EditCommandColumn1">

</EditColumn>

<FormTemplate>

<table id="Table2" cellspacing="2" cellpadding="1" width="50%" border="1" rules="none"

style="border-collapse: collapse;">

<tr class="EditFormHeader">

<td style="width:150px">

<asp:Label ID="Label3" Text="Employee No" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="tb_emp_no" runat="server" Text='<%# Bind("Employee_No") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label2" Text="Employee Name" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label4" runat="server" Text='<%# Bind("Employee_Display_Name") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label9" Text="Reporting office" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label10" runat="server" Text='<%# Bind("Department") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label5" Text="Start Date & Time" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label6" runat="server" Text='<%# Bind("Start_Time","{0: dd-MMM-yyyy hh:mm tt}") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label7" Text="End Date & Time" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label8" runat="server" Text='<%# Bind("End_Time","{0: dd-MMM-yyyy hh:mm tt}") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label19" Text="Total Days" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label20" runat="server" Text='<%# Bind("TotalDays") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label21" Text="Total Hours" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label22" runat="server" Text='<%# Bind("TotalHours") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label11" Text="Training Type" runat="server"></asp:Label>

</td>

<td>

<asp:label ID="Label12" runat="server" Text='<%# Bind("type") %>' ReadOnly="true"></asp:label>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label13" Text="Pre test score" runat="server"></asp:Label>

</td>

<td>

<asp:textbox ID="tb_pre_test_score" runat="server" Text='<%# Bind("pre_test_score") %>' ></asp:textbox>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label15" Text="Post test score" runat="server"></asp:Label>

</td>

<td>

<asp:textbox ID="tb_post_test_score" runat="server" Text='<%# Bind("post_test_score") %>' ></asp:textbox>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label18" Text="Result" runat="server"></asp:Label>

</td>

<td>

<asp:DropDownList runat="Server" SelectedValue='<%# Bind("Result") %>'

DataTextField="Result" DataValueField="Result"

ID="comboResult">

<asp:ListItem Text="" Value=""></asp:ListItem>

<asp:ListItem Text="Pass" Value="Pass"></asp:ListItem>

<asp:ListItem Text="Fail" Value="Fail"></asp:ListItem>

<asp:ListItem Text="Defer" Value="Defer"></asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label16" Text="Cost" runat="server"></asp:Label>

</td>

<td>

<asp:textbox ID="tb_cost" runat="server" Text='<%# Bind("cost") %>' ></asp:textbox>

</td>

</tr>

<tr>

<td style="width:150px">

<asp:Label ID="Label17" Text="Remarks" runat="server"></asp:Label>

</td>

<td>

<asp:textbox ID="tb_remarks" runat="server" Text='<%# Bind("remarks") %>' ></asp:textbox>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Label14" Text="Certificate" runat="server"></asp:Label>

</td>

<td>

<telerik:RadUpload ID="AttachmentUpload" runat="server">

</telerik:RadUpload>

</td>

</tr>

<tr>

<td align="right" colspan="2">

<asp:Button ID="Button1" Text="Update"

runat="server" CommandName="Update"></asp:Button>

<asp:Button ID="btnDelete" Text="Delete" runat="server" CausesValidation="False"

CommandName="Delete" OnClientClick="return conformbox();" visible="false" ></asp:Button>

<asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False"

CommandName="Cancel"></asp:Button>

</td>

</tr>

</table>

</FormTemplate>

</EditFormSettings>

<PagerStyle PageSizeControlType="RadComboBox" />

</MasterTableView>

<PagerStyle PageSizeControlType="RadComboBox" />

<FilterMenu EnableImageSprites="False">

</FilterMenu>

</telerik:RadGrid>

<asp:ObjectDataSource ID="ODS_attendance" runat="server"

SelectMethod="GetTrainingRecordsArrayBySessionID" TypeName="LRDB">

<SelectParameters>

<asp:QueryStringParameter Name="id" QueryStringField="SessionID" Type="Int32" />

</SelectParameters>

<UpdateParameters>

<asp:Parameter Name="UserID" Type="Int16"></asp:Parameter>

<asp:Parameter Name="Remarks" Type="String" />

<%--<asp:Parameter Name="Status" Type="Boolean" />--%>

</UpdateParameters>

</asp:ObjectDataSource>

<asp:LinqDataSource ID="LDS_Certificate" runat="server" TableName="db_Certificates"

ContextTypeName="dcLRDBDataContext" EntityTypeName="" Where="UserID==@UserID">

<SelectParameters>

<asp:Parameter Name="UserID" Type="Int32"></asp:Parameter>

</SelectParameters>

</asp:LinqDataSource>

Code behind:

Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand

RadGrid1.MasterTableView.ClearEditItems()

If e.CommandName = RadGrid.InitInsertCommandName Then 'Click Add New Record button

Dim editColumn As GridEditCommandColumn = CType(RadGrid1.MasterTableView.GetColumn("EditCommandColumn"), GridEditCommandColumn)

editColumn.Visible = False

ElseIf (e.CommandName = RadGrid.RebindGridCommandName AndAlso e.Item.OwnerTableView.IsItemInserted) Then

e.Canceled = True

Else

Dim editColumn As GridEditCommandColumn = CType(RadGrid1.MasterTableView.GetColumn("EditCommandColumn"), GridEditCommandColumn)

If Not editColumn.Visible Then 'Click Cancel button (both Insert and Update mode)

editColumn.Visible = True

End If

Dim txt_pre_test_score As TextBox = DirectCast(e.Item.FindControl("tb_pre_test_score"), TextBox)

Dim txt_post_test_score As TextBox = DirectCast(e.Item.FindControl("tb_post_test_score"), TextBox)

Dim txt_cost As TextBox = DirectCast(e.Item.FindControl("tb_cost"), TextBox)

Dim txt_remarks As TextBox = DirectCast(e.Item.FindControl("tb_remarks"), TextBox)

Dim cmb_Result As DropDownList = DirectCast(e.Item.FindControl("comboResult"), DropDownList)

Dim dc As New dcLRDBDataContext

If e.CommandName = "PerformInsert" Then

ElseIf e.CommandName = "Update" Then

Dim lid As Integer = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("UserID")

HttpContext.Current.Session("EditUserID") = lid

Dim rec = (From p In dc.db_Training_Records Where p.UserID = lid).FirstOrDefault

If Not rec Is Nothing Then

rec.Cost = txt_cost.Text

rec.pre_test_score = txt_pre_test_score.Text

rec.post_test_score = txt_post_test_score.Text

rec.Remarks = txt_remarks.Text

rec.Result = cmb_Result.SelectedValue

rec.LastUpdateBy = HttpContext.Current.Session("UserID")

rec.LastUpdateDate = DateTime.Now

dc.SubmitChanges()

End If

Dim attachmentUpload As RadUpload = DirectCast(e.Item.FindControl("AttachmentUpload"), RadUpload)

If attachmentUpload.UploadedFiles.Count > 0 Then

Dim file As UploadedFile = attachmentUpload.UploadedFiles(0)

Dim stream As System.IO.Stream = file.InputStream

Dim binaryData As Byte() = New Byte(stream.Length - 1) {}

stream.Read(binaryData, 0, CInt(stream.Length))

'binaryData contains your uploaded content

'you can save to your database

stream.Seek(0, System.IO.SeekOrigin.Begin)

Dim newRecord1 As New db_Certificate

dc.db_Certificates.InsertOnSubmit(newRecord1)

newRecord1.BinaryData = binaryData

newRecord1.FileName = file.FileName

newRecord1.FileSize = file.ContentLength / 1024

newRecord1.Description = file.GetFieldValue("Description")

newRecord1.UploadBy = HttpContext.Current.Session("UserID")

newRecord1.UploadDate = DateTime.Now

newRecord1.LastUpdatedOn = DateTime.Now

newRecord1.LastUpdatedBy = HttpContext.Current.Session("UserID")

newRecord1.UserID = lid

dc.SubmitChanges()

End If

RadGrid1.MasterTableView.ClearEditItems()

RadGrid1.DataBind()

End If

dc.Dispose()

End If

End Sub

Grid

answered on 25 Nov 2013

6 answers

180 views

Signature Image Erased from Rad AsSync control after Firing Popup

    Hi sir,

       Please give me the Response to my Request.

      i am attaching Three ScreenShots Regarding my issue:

     (1). The 1st one is i have filled the form with all required details,

    (2).   The 2nd Screenshot showing after Clicking Save button ,Validation Summary Popup raised if i did not give the required field details

             now Signature image did not erased from RadAsyncupload control after firing Validation summary popup.

    (3).   The 3rd Screenshot showing Signature image Erased from RadAsyncupload control after firing Popup, for this popup i used RadWindowManager control for displying text from server side Code.

    Issue is: Signature image is Disappear(Erased) from control in 3rd screenshot scenario, after firing below text popup.

   Like Below: RadWindowManager1.RadAlert("Given check number has already generated, preferable number would be: #" + ++maxCheckNo, 340, 140, "Check SetUp", null);

General Discussions

answered on 25 Nov 2013

1 answer

77 views

RadGrid Filter Icons source link breaking

Hi,

I've got two filter icons at the bottom of the radgrid that hide the filter header or clears it out completely. When I run it on my local machine, the source link is accurate, finds the images just fine. When I moved my code to the server, the source link adds another layer to the link. So instead of looking in the root folder, it goes up a directory.

IE.
root/image <= where the image actually is
root/folder a/image <= is where the source points to when moved to the server

folder a is also the first layer of directory where the radgrid is, so ie:

root/folder a/folder b/default.aspx <= is where the aspx page is where it uses the radgrid

Where would I find the config to have the radgrid point it to the right direction?

Grid

answered on 25 Nov 2013

1 answer

175 views

RadGrid Columns Adding and Removing from Grid by Drag and Drop.

Hi,

It there any way to dynamically add/remove columns from a gird by drag and drop. As we do for Dynamic grouping in grid. Thanks in advance.

Thanks and Regards,
Rajender .A

Grid

answered on 25 Nov 2013

1 answer

89 views

RadEditor Upgrade Issue

Hi

I upgraded RadEditor to latest version [2013.1.403.35]. I am getting error in following properties. Please let me what is the new property names for new Editor version.

RadEditor.Editable= True
RadEditor..SaveInFile = False
RadEditor..ShowSubmitCancelButtons = False
RadEditor..ShowHtmlMode = False
RadEditor..EnableTab = True
RadEditor.ShowPreviewMode = False
RadEditor.ToolsHeight = Unit.Percentage(100)
RadEditor.UseClassicDialogs = True
RadEditor.ToolbarMode = EditorToolbarMode.Default

Please let me know the corresponding properties for new version.

Editor

answered on 25 Nov 2013

1 answer

35 views

RadEditor XHTML Error

I am using RadEditor.xhtml in my code get format from Editor and Store in Database. I upgraded my app from .NET 1.1 to 3.5.

This is not working and getting following error.

Public member 'Xhtml' on type 'MyRichTextEditor' not found.

Please let me know how to fix this issue.

Editor

answered on 25 Nov 2013

4 answers

226 views

Grid inside RadGrid

Hi,
Is it possible to show grid inside radgrid. The subgrid will show in other then 1st column say 4th or 5th column.

And one more thing can I add a tab right align and others are left align.

Please follow the attached screen shot of two requirement.

Thanks
Chandan

General Discussions

answered on 25 Nov 2013

1 answer

95 views

DATABIND in Social Share

I am trying to test your social share using databind and i am having issues. My first example is a working example of what i currently use. I am trying to go away from it and use your social share.
==================================== CURRENT SETUP WORKING ====================================

<div class="addthis_toolbox addthis_default_style addthis_16x16_style">
<a class="addthis_button_email"></a>
<a class="addthis_button_google"></a>
<a class="addthis_button_facebook"></a>
<a class="addthis_button_twitter"></a>
<a class="addthis_button_pinterest_pinit" <%="pi:pinit:layout"%>="horizontal" <%="pi:pinit:url"%>="<%# String.Format("http://www.amormemorials.com/Images/Products/{0}/Small/{1}/{2}.png", Eval("TypeEN"), Eval("Language"), Eval("ImageNumber").ToString())%>" <%="pi:pinit:media"%>="<%# String.Format("http://www.amormemorials.com/Images/Products/{0}/Small/{1}/{2}.png", Eval("TypeEN"), Eval("Language"), Eval("ImageNumber").ToString())%>"></a>

</div>
<script type="text/javascript">var addthis_config = { "data_track_addressbar": true };</script>
<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-528a29dd6c2933cf"></script>

=====================================================

Now i am trying your rad social share like this, and i am not able to get databinding to work.
=====================================NEW SETUP NOT WORKING ==========================================
<telerik:RadSocialShare ID="RadSocialShare1" runat="server" Skin="Windows7">
<CompactButtons>
<telerik:RadSocialButton SocialNetType="GoogleBookmarks" ToolTip="Share on GoogleBookmarks" />
</CompactButtons>
<MainButtons>
<telerik:RadFacebookButton ButtonType="FacebookLike" />
<telerik:RadPinterestButton ButtonType="PinIt" UrlToShare="<%# String.Format("http://www.amormemorials.com/Images/Products/{0}/Small/{1}/{2}.png", Eval("TypeEN"), Eval("Language"), Eval("ImageNumber").ToString())%>"
TitleToShare="<%# Eval("FullDescriptionEN") %>"
FromUrl="http://www.amormemorials.com" />
<telerik:RadPinterestButton ButtonType="Follow" UrlToShare="<%# String.Format("http://www.amormemorials.com/Images/Products/{0}/Small/{1}/{2}.png", Eval("TypeEN"), Eval("Language"), Eval("ImageNumber").ToString())%>" />
<telerik:RadCompactButton ToolTip="Show more" />
</MainButtons>
</telerik:RadSocialShare>

===================================================================
THANK YOU.

Even using <CompactButtons> i am not able to do databind.

<telerik:RadSocialShare ID="RadSocialShare1" runat="server" Skin="Windows7">
<CompactButtons>
<telerik:RadSocialButton SocialNetType="Pinterest" ToolTip="Share on Pinterest" UrlToShare="<%# String.Format("http://www.amormemorials.com/Images/Products/{0}/Small/{1}/{2}.png", Eval("TypeEN"), Eval("Language"), Eval("ImageNumber").ToString())%>" TitleToShare="title" />
</CompactButtons>
</telerik:RadSocialShare>

SocialShare

answered on 25 Nov 2013

12 answers

196 views

Column headings not aligned with columns when scrolled to far right

When you scroll to the far right in the Wash Library, the columns no longer are fully aligned with their column headings. Refer to the attachment for a visual reference.

Grid

answered on 25 Nov 2013

5 answers

143 views

Large Paging Optimizations

Hi All!

Can you please tell me what you would advise as the best way of displaying a large number of records (IE: a page size of 500 to 1000)?

Also, are there ways to optimize large quantities (IE: a page size of 10 and over 2000 items)?

Thanks,
Mark

Grid

answered on 25 Nov 2013

Top users last month