Questions on UI for ASP.NET AJAX Forum

1 answer

135 views

Sorting and Filter text box size not working

I am unable to get sorting to work for this grid as well as to control the size of the filter text boxes for this grid.
I think the problem is associated with the way I select the datasource but I do not know how to fix it and I need to allow selecting the Sql table to the user.

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DropDownList1.DataSource = SqlDataSource2;

DropDownList1.DataBind();

}

SetDataSource();

}

protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)

{

if (DropDownList1.SelectedIndex > 0)

{

SetDataSource();

RadGrid1.Rebind();

}

private void SetDataSource()

{

if (DropDownList1.SelectedIndex > 0)

{

string tableInUse = DropDownList1.SelectedItem.Text;

RadGrid1.DataSource = SqlDataSource1;

SqlDataSource1.DeleteCommand = "DELETE FROM [" + tableInUse + "] WHERE [Id] = @Id";

SqlDataSource1.InsertCommand = "INSERT INTO [" + tableInUse + "] ([Code], [Description], [Bkgroup], [Stgroup], [Quantity], [BomNote], [UnitEng], [AlternCost]) VALUES (@Code, @Description, @Bkgroup, @Stgroup, @Quantity, @BomNote, @UnitEng, @AlternCost)";

SqlDataSource1.SelectCommand = "SELECT prod.Id, prod.Code, prod.Description, prod.Bkgroup, prod.Stgroup, prod.Quantity," +

"prod.BomNote, prod.UnitEng, prod.AlternCost, comp.Unit, comp.Cost, comp.NoteComp " +

"FROM " + tableInUse + " prod " +

"left JOIN Components comp ON comp.Code = prod.Code";

SqlDataSource1.UpdateCommand = "UPDATE [" + tableInUse + "] SET [Code] = @Code, [Description] = @Description, [Bkgroup] = @Bkgroup, [Stgroup] = @Stgroup, [Quantity] = @Quantity, [BomNote] = @BomNote, [UnitEng] = @UnitEng, [AlternCost] = @AlternCost WHERE [Id] = @Id";

}

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

RadGrid1.DataSource = SqlDataSource1;

}

protected void Button1_Click(object sender, EventArgs e)

{

RadGrid1.MasterTableView.TableLayout = GridTableLayout.Auto;

RadGrid1.AllowFilteringByColumn = true;

RadGrid1.MasterTableView.AllowFilteringByColumn = true;

RadGrid1.Rebind();

}

protected void Button2_Click(object sender, EventArgs e)

{

RadGrid1.MasterTableView.TableLayout = GridTableLayout.Auto;

RadGrid1.AllowFilteringByColumn = false;

RadGrid1.MasterTableView.AllowFilteringByColumn = false;

RadGrid1.Rebind();

}

      protected void RadGrid1_ItemCreated1(object sender, GridItemEventArgs e)

       {

       if (e.Item is GridFilteringItem)

        {

            GridFilteringItem filteringItem = e.Item as GridFilteringItem;

            //set dimensions for the filter textbox  

            TextBox box = filteringItem["Code"].Controls[0] as TextBox;

            box.Width = Unit.Pixel(30);

        }

    }

If I try to use the Item_created event to control the size of the filter text boxes, I get a null reference exception.

<div>

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" AppendDataBoundItems="true" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged1" DataTextField="Name" DataValueField="Name">

<asp:ListItem Text="-Select a BOM" />

</asp:DropDownList>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:BOMConnectionString %>" SelectCommand="SELECT [Name] FROM [IndexTabb]"></asp:SqlDataSource>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Filter On" />

<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Filter Off" />

<br />

<telerik:RadGrid ID="RadGrid1" runat="server" Culture="it-IT" AllowPaging="True" AllowSorting="True" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" OnNeedDataSource="RadGrid1_NeedDataSource" OnItemCreated="RadGrid1_ItemCreated1">

<ExportSettings ExportOnlyData="True">

<Pdf PageWidth="">

</Pdf>

</ExportSettings>

<ClientSettings>

<Scrolling AllowScroll="True" UseStaticHeaders="True" />

</ClientSettings>

<MasterTableView CommandItemDisplay="Top" DataKeyNames="Code" InsertItemPageIndexAction="ShowItemOnCurrentPage" AllowNaturalSort="False">

<CommandItemSettings ShowExportToExcelButton="True" />

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton">

<HeaderStyle Width="30px" />

</telerik:GridEditCommandColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" Text="Delete" CommandName="Delete" FilterControlAltText="Filter column1 column" ConfirmDialogType="RadWindow" ConfirmText="Do you really want to delete this project and all its content?" UniqueName="Cancel">

<HeaderStyle Width="30px" />

</telerik:GridButtonColumn>

</Columns>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1" FilterControlAltText="Filter EditCommandColumn1 column"></EditColumn>

</EditFormSettings>

<PagerStyle AlwaysVisible="True" />

</MasterTableView>

<PagerStyle AlwaysVisible="True" />

</telerik:RadGrid>

<br />

</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BOMConnectionString %>">

</asp:SqlDataSource>

And sorting is not working. When I click on the header of the column I can see the small arrow changing up or down but nothing happens.
How can I get control of the filter text boxes size and make the sorting working in this context?
Any help will be appreciated.

Grid

answered on 02 Oct 2014

1 answer

139 views

Does the Gantt do quarters for heading?

Needing to do a gantt chart based on fy and quarters.
Any suggestions.

Gantt

answered on 02 Oct 2014

1 answer

149 views

Multiline not displaying correctly in FF

hi

This my code:

<telerik:RadTextBox ID="RadTextBox1" Runat="server" Resize="None" Rows="1" TextMode="MultiLine" Width="160px"> </telerik:RadTextBox>

As you can see, the Rows attribute is set to 1, which means it should display as 1 row in the browser. But it is not getting it right in FF 32.0. It works fine in IE 11 and chrome.

How do i solves this? Thanks a lot.

Input

answered on 02 Oct 2014

2 answers

393 views

Vertical column headers in Grid?

Hi, is it possible to have column headers with vertical text in RadGrid? Right now we do this by putting the text in images, but that solution is not very flexible if the text needs to change.

Grid

answered on 02 Oct 2014

3 answers

97 views

Problems with stepping out from HTML markup

Hi,

we are trying to use RadEditor within DotNetNuke CMS and here is the problem.
We are saving small parts of HTML in templates to help content manager insert UI elements quicker.
But after pasting template content manager can't step out to the end of HTML makeup.
Example.
We have HTML template for button:
<a href="/some-page" class="green_btn">
<span class="bg">
<span class="icon"></span>
<span class="txt">Some text</span>
</span>
</a>
After insertion the cursor is placed at the end of "Some text" (see pic.1 attached) inside button. We need to skip to the end of HTML and continue to enter regular text (see pic.2 with desired cursor position).
How we can do this? I mean - may be there is hot key for that? Or do we have to wrap templates in paragraphs or put but <br/>s in templates?
Click on the white space after button doesn't help. "End" and "Ctrl+End" keys can't help too.

Editor

answered on 02 Oct 2014

3 answers

680 views

[Solved] Hide/Show RadGrid Column Filter from code behind

Is there a way that I can conditionally hide a column filter in a RadGrid from the code behind based on the data column name when the RadGrid is set to AutoGenerateColumns="true"?

Example:
I assign a datatable as the RadGrid's datasource. I want to intercept some RadGrid event to see if column "TEST" was added, and if so, then hide the filter for that column in the RadGrid.

Thank you,

-Scott

Grid

answered on 01 Oct 2014

6 answers

519 views

Character Limit in RadEditor

Hi,
I have a RadEditor in my page. I want to limit the maximum number of characters entered. I need not to dispaly the message if the maximum character is reached. But i need to block the characters entered by the user if it reached the maximum length. Please give the solution for this problem.

Thanks,
Velkumar

Editor

answered on 01 Oct 2014

2 answers

113 views

[Solved] RadInputManager IndexSizeError in Firefox 32

I'd post this as a support ticket, but our support just ran out last week (of course)...

This seems to be a new issue with 2014.2.724.45, as the exact same code is working on our production site but is giving this error in Firefox on our Beta site

IndexSizeError: Index or size is negative or greater than the allowed amount

The error shows up in the if(c.originalMaxLength) line below

updateValue:function(d){var c=$get(this._id);

var e;

var f=c.value;

if(c.originalMaxLength){c.maxLength=c.originalMaxLength;

}if(typeof(d)=="undefined"){e=c.value;

This is showing up on our Login page that uses telerik:RadInputManager to make the user name and password fields required.

<telerik:RadInputManager runat="server" ID="rim">

<telerik:TextBoxSetting BehaviorID="textRequired">

<Validation IsRequired="true" />

<TargetControls>

<telerik:TargetInput ControlID="UserName" />

<telerik:TargetInput ControlID="Password" />

</TargetControls>

</telerik:TextBoxSetting>

</telerik:RadInputManager>

If I comment out the RadInputManager, the page works fine, although without validation. If I leave the code in, we get the error message in the Firebug console in Firefox 32.0.3 and the password box won't accept any typing at all. It works fine in IE and Chrome.

Live beta site example at https://beta.connectionsonline.net/

I noticed that Mozilla has a similar issue listed as a bug with Firefox 30 and 31, but I'm not sure if it is related: https://bugzilla.mozilla.org/show_bug.cgi?id=987227

Input

answered on 01 Oct 2014

1 answer

411 views

Telerik Reporting using objectDataSource

Hai all,

i want to change all my reports into telerik reports using typed dataset please help me how to do for that what i did is

1.first i create a Dataset1.xsd file in that i added a TableAdapter DataTable1 there i am getting somefileds and GetData()
2.then i created a Report1.cs(Telerik Report Q1 2014) there i added a objectdatasource in that i selected Select Available data source types tab ther i added my DataTable1 and in Choose Datasource Member i selecte GetData() and i click on finsih button
but when i select on Telerik=>Reporting=>DataExplorer its showing NoDatasource

how to use these datatable in my reports how to do please give me one sample example how to do its urgent

thanks in advance

General Discussions

answered on 01 Oct 2014

10 answers

850 views

Checkbox in editform

Please somebody help me about using simple checkbox in edit forms. I always get famous DBnull error. I need simple sample using sql server and data type integer. I spent more than one week and still no result. when I correct update events, then addnew throws error. when I correct addnew part, orher parts fail. I tried everything on sql site. int column type, bit column type, nullable, everything. I tried to change combobox to get rid of checkbox, another selected value, dbnull, etc etc errors rise. I won't give any error message, it is famous problem.

Just need one column of RadGrid to add, and update record to sql table which has only one column with type of integer. I need it to use form templates.

Why this is so difficult.
best regards.

Grid

answered on 01 Oct 2014