while accessing the addnew control insert button in my rad grid. my grid disappears. I don't know how to fix this prob. If any body knows pls let me know. This is my snippet:



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Models.aspx.cs" Inherits="TBS_HelpDesk.Views.Assets.Models"
    MasterPageFile="~/Views/Shared/MasterPage.Master" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="aboutContent" ContentPlaceHolderID="MainContent" runat="server">
    <div style="width: 500px; height: 600px;">
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadComboBox1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadComboBox1" UpdatePanelHeight="" />
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelHeight="" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
                <telerik:AjaxSetting AjaxControlID="RadGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadComboBox1" UpdatePanelHeight="" />
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelHeight="" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
        <telerik:RadComboBox ID="RadComboBox1" runat="server" Width="200" AutoPostBack="true"
            AppendDataBoundItems="true" OnSelectedIndexChanged="RadComboBox1_SelectedIndexChanged">
        </telerik:RadComboBox>
        <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="True" AllowAutomaticUpdates="True"
            GridLines="None" AllowPaging="True" AllowSorting="True" Skin="Office2007" OnItemCommand="RadGrid1_ItemCommand"
            AutoGenerateColumns="False" >
            <MasterTableView CommandItemDisplay="Top" EditMode="PopUp" EnableHeaderContextMenu="true">
                <PagerStyle BackColor="#D8EBFC" />
                <HeaderStyle CssClass="dataheadcolor" />
                <RowIndicatorColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                </RowIndicatorColumn>
                <ExpandCollapseColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                </ExpandCollapseColumn>
                <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
                <Columns>
                    <telerik:GridEditCommandColumn ButtonType="ImageButton" />
                    <telerik:GridNumericColumn DataField="Model_ID" HeaderText="Model Id" SortExpression="Model_ID"
                        UniqueName="Model_ID">
                    </telerik:GridNumericColumn>
                    <telerik:GridBoundColumn DataField="Model_Name" HeaderText="Model Name" SortExpression="Model_Name"
                        UniqueName="Model_Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Model_Description" DataType="System.Boolean"
                        HeaderText="Model Description" SortExpression="Model_Description" UniqueName="Model_Description">
                    </telerik:GridBoundColumn>
                    <telerik:GridButtonColumn CommandName="Delete" ButtonType="ImageButton" UniqueName="DeleteColumn"
                        CommandArgument="Child" ConfirmDialogType="RadWindow" ConfirmText="Are You Sure Want To Delete This Record?"
                        ConfirmTitle="Delete Confirm" />
                </Columns>
                <EditFormSettings ColumnNumber="3" CaptionFormatString="Model Create">
                    <EditColumn UniqueName="EditCommandColumn1">
                    </EditColumn>
                    <FormTemplate>
                        <table cellspacing="2" cellpadding="1" width="100%" border="1">
                            <tr>
                                <td>
                                    <asp:Label runat="server" Text="Manuf" ID="label1"></asp:Label>
                                </td>
                                <td>
                                    <asp:TextBox Width="200px" ID="Model_ID" AutoCompleteType="Disabled" runat="server"
                                        Text='<%# Bind("Model_ID") %>'></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Model Name
                                </td>
                                <td>
                                    <asp:TextBox Width="200px" ID="Model_Name" AutoCompleteType="Disabled" runat="server"
                                        Text='<%# Bind("Model_Name") %>'></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Model Description
                                </td>
                                <td>
                                    <asp:TextBox Width="200px" ID="Model_Description" AutoCompleteType="Disabled" runat="server"
                                        Text='<%# Bind("Model_Description") %>'></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:Button ID="Button1" runat="server" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                        CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
                                    </asp:Button>
                                    <asp:Button ID="Button2" runat="server" Text="Cancel" CausesValidation="false" CommandName="Cancel">
                                    </asp:Button>
                                </td>
                            </tr>
                        </table>
                    </FormTemplate>
                </EditFormSettings>
            </MasterTableView>
        </telerik:RadGrid>
    </div>
</asp:Content>











using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace TBS_HelpDesk.Views.Assets
{
    public partial class Models : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                LoadManufacturers();
            }
        }
        protected void LoadManufacturers()
        {
            DataTable dtTable = new DataTable();
            string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
            SqlDataAdapter sqladp = new SqlDataAdapter();
            SqlConnection sqlconn = new SqlConnection(conn);
            sqlconn.Open();

            try
            {
                string selectQuery = "SELECT * FROM [ASSETMANUFACTURERS] order by Manuf_ID asc";
                sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
                sqladp.Fill(dtTable);

                RadComboBox1.DataValueField = "Manuf_ID";
                RadComboBox1.DataTextField = "Manuf_Name";
                RadComboBox1.DataSource = dtTable;
                RadComboBox1.DataBind();
                RadComboBox1.Items.Insert(0, new RadComboBoxItem("- Select Manufacturers Name -"));

            }
            finally
            {
                sqlconn.Close();
            }
        }
        protected void LoadModels(string Manuf_ID)
        {
            SqlConnection connection = new SqlConnection(
      ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ConnectionString);

            SqlDataAdapter adapter = new SqlDataAdapter("SELECT Model_ID,Model_Name,Model_Description FROM AssetModels WHERE Model_Manuf_ID=@Manuf_ID ORDER By Model_Manuf_ID", connection);
            adapter.SelectCommand.Parameters.AddWithValue("@Manuf_ID", RadComboBox1.SelectedValue);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            RadGrid1.DataSource = dt;
            RadGrid1.DataBind();
        }

        protected void RadComboBox1_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            LoadModels(e.Text);
        }
        //protected void RadGrid1_RowDataBound1(object sender, GridViewRowEventArgs e)
        //{
        //    if (e.Row.RowType == DataControlRowType.DataRow)
        //    {
        //        e.Row.Attributes.Add("id", e.Row.RowIndex.ToString());
        //        e.Row.Attributes.Add("onclick", "MarkRow(" + e.Row.RowIndex.ToString() + ");");
        //    }
        //}
        protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
        {

            SqlConnection connection = new SqlConnection(
      ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ConnectionString);

            DataTable dtTable = new DataTable();
            string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
            SqlDataAdapter sqladp = new SqlDataAdapter();
            SqlConnection sqlconn = new SqlConnection(conn);
            SqlCommand sqlcmd = new SqlCommand();

            if (e.CommandName == RadGrid.PerformInsertCommandName)
            {
                GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;

                RadNumericTextBox Model_ID = (e.Item as GridEditFormInsertItem)["Model_ID"].Controls[0] as RadNumericTextBox;
                TextBox Model_Name = (e.Item as GridEditFormInsertItem)["Model_Name"].Controls[0] as TextBox;
                TextBox Model_Description = (e.Item as GridEditFormInsertItem)["Model_Description"].Controls[0] as TextBox;


                try
                {
                    sqlconn.Open();
                    string insertQuery = "INSERT INTO [AssetModels] ([Model_Manuf_ID],[Model_ID],[Model_Name], [Model_Description]) VALUES ('" + RadComboBox1.SelectedValue + "','" + Model_ID.Text + "','" + Model_Name.Text + "','" + Model_Description.Text + "')";
                    sqlcmd.CommandText = insertQuery;
                    sqlcmd.Connection = sqlconn;
                    sqlcmd.ExecuteNonQuery();

                    SqlDataAdapter adapter = new SqlDataAdapter("SELECT Model_ID,Model_Name,Model_Description FROM AssetModels WHERE Model_Manuf_ID=@Manuf_ID ORDER By Model_ID", connection);
                    adapter.SelectCommand.Parameters.AddWithValue("@Manuf_ID", RadComboBox1.SelectedValue);
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    RadGrid1.DataSource = dt;
                    RadGrid1.DataBind();
                }
                catch (Exception ex)
                {
                    RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
                }
                RadGrid1.MasterTableView.IsItemInserted = false;
                RadGrid1.DataBind();
                e.Canceled = true;
            }
            else if (e.CommandName == RadGrid.UpdateCommandName)
            {
                GridEditableItem editedItem = e.Item as GridEditableItem;

                RadNumericTextBox Model_ID = (e.Item as GridEditableItem)["Model_ID"].Controls[0] as RadNumericTextBox;
                TextBox Model_Name = (e.Item as GridEditableItem)["Model_Name"].Controls[0] as TextBox;
                TextBox Model_Description = (e.Item as GridEditableItem)["Model_Description"].Controls[0] as TextBox;

                try
                {
                    sqlconn.Open();
                    string updateQuery = "UPDATE [AssetModels] SET [Model_Name] = '" + Model_Name.Text + "', [Model_Description] = '" + Model_Description.Text + "' WHERE [Model_ID] = '" + Model_ID.Text + "'";
                    sqlcmd.CommandText = updateQuery;
                    sqlcmd.Connection = sqlconn;
                    sqlcmd.ExecuteNonQuery();
                    SqlDataAdapter adapter = new SqlDataAdapter("SELECT Model_ID,Model_Name,Model_Description FROM AssetModels WHERE Model_Manuf_ID=@Manuf_ID ORDER By Model_ID", connection);
                    adapter.SelectCommand.Parameters.AddWithValue("@Manuf_ID", RadComboBox1.SelectedValue);
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    RadGrid1.DataSource = dt;
                    RadGrid1.DataBind();
                    sqlconn.Close();
                }
                catch (Exception ex)
                {
                    RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));

                }
                RadGrid1.EditIndexes.Clear();
                RadGrid1.DataBind();
                e.Canceled = true;
            }
            else if (e.CommandName == RadGrid.DeleteCommandName)
            {
                GridDataItem item = (GridDataItem)e.Item;
                string Model_Manuf_ID = item["Model_Manuf_ID"].Text;

                try
                {
                    sqlconn.Open();
                    string deleteQuery = "DELETE FROM [AssetModels] WHERE [Model_Manuf_ID] ='" + Model_Manuf_ID + "'";
                    sqlcmd.CommandText = deleteQuery;
                    sqlcmd.Connection = sqlconn;
                    sqlcmd.ExecuteNonQuery();
                    string selectQuery = "SELECT Model_Manuf_ID, Manuf_Name, Manuf_Description, Manuf_Inactive FROM [AssetModels] order by Model_Manuf_ID asc";
                    sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
                    sqladp.Fill(dtTable);
                    RadGrid1.DataSource = dtTable;
                    sqlconn.Close();
                }
                catch (Exception ex)
                {
                    RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
                    e.Canceled = true;
                }

            }
        }
    }
}

I'm trying to use the RadFilter to work around the following limitation:

"RadGrid's filtering does not support "Between" FilterFunction when the RadGrid is bound to the EntityDataSource."

What I need is a Filter showing only one field (Date) that appears on startup. Much of the Filter UI should be hidden, including the TimePickers. I've attached a picture of what the desired result.

Any ideas how I can build a stripdown version of the RadFilter like this?

Thanks,

Ken
Microsoft MVP [ASP.NET]
ASPInsider

Hi,
I've created a custom module with a RadGrid in the backed to manage the module's items. I have a LinkButton inside a RadGrid GridTemplateColumn which I use to send a PDF document from a database to the user. I ran into the issue described in this thread:
http://www.telerik.com/community/forums/aspnet/ajax/radgrid-response-binarywrite-asp-net-ajax.aspx
I used the solution suggested in that thread adding an event like this one to the grid page:

protected void RadGrid1_ItemCreated(object sender, Telerik.WebControls.GridItemEventArgs e)

    {

        if (e.Item is GridDataItem)

        {

            Button btn = (e.Item as GridDataItem)["TemplateColumn"].FindControl("Button1") as Button;

            ScriptManager1.RegisterPostBackControl(btn);

        }

        if (e.Item is GridCommandItem)

        {

            Button btncmd = (e.Item as GridCommandItem).FindControl("Button2") as Button;

            ScriptManager1.RegisterPostBackControl(btncmd);

        }

    }

This seemed to fix the problem, but then I noticed if I make the grid sortable and I click on a column header to sort the items, then I click on any item's LinkButton, I get again the Sys.WebForms.PageRequestManagerParserErrorException. Same happens if I enable grouping and group the items by any column.

This is the LinkButton codebehind:

protected void ItemsGrid_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)

    {

        if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)

        {

            Guid candidaturaId = new Guid(ItemsGrid.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString());

 

        // create a new instance of ContactsManager with default provider

        CandidatureManager cm = new CandidatureManager();

 

        // get the desired candidatura and set the values of the form

        ICandidatura candidatura = cm.GetCandidatura(candidaturaId);

 

            string ext = Path.GetExtension(candidatura.AllegatoFilename).ToLower();

            CustomDownload cd =

                new CustomDownload

                {

                    Filename = candidatura.AllegatoFilename,

                    MimeType = (ext == ".pdf") ? MediaTypeNames.Application.Pdf : "application/unknown",

                    Data = candidatura.Allegato.ToArray(),

                };

 

            ScriptManager sm = (ScriptManager)Page.FindControl("TheScriptManager");

 

            Response.ClearHeaders();

            Response.ClearContent();

            Response.AddHeader("Accept-Ranges", cd.Data.Length.ToString());

            Response.AddHeader("Content-Disposition", "attachment;filename=" + cd.Filename);

            Response.ContentType = cd.MimeType;

            if (cd.Data.Length > 0)

                Response.BinaryWrite(cd.Data);

            Response.End();

        }

    }

Thank you,
Alessio Scalerandi

Hi All,

Please go through the below link in Firefox 4.
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/headercontextmenu/defaultcs.aspx
When I Show/Hide the columns using Context Menu it is not auto - adjusting the width of the grid. It leaves an empty space
at the right hand side.Though it is working fine in IE(Internet Explorer) and lower versions of Firefox.
Can you please suggest how to get rid of this space so that it auto-adjusts itself.
Expecting for an early reply.

Thanks,
Amrita Mandal

I have recently took over a project from someone else and am experiencing some inconsistencies when it comes to getting/setting html in firefox. 

When i use get_html i want to always have my content wrapped in HTML tags. So if i type a few words it should be wrapped a <p> tag when i use get_html. This works for hte most part but with a couple inconsistencies:

1) When i set my HTML using set_html , if my content is empty i must set "<p>&nbsp;</p>"  or else setting it to empty text will just return straight text when i use get_html if i just type a few words without any styling/line breaks.
2) Setting it to <p>&nbsp;</p> when the content is empty works fine when i use get_html. Everything is wrapped in a <p> tag how i want it but if i highlight/delete the content then start again sometimes (but not always) the <p> tags disappear and i get straight text and no HTML. 
3) If i use <p></p> in Firefox when i have no content to set the return results are "<p></p>" then my text, but in IE the text appears inside the <p> tag. 

I really just want to enforce always having formatted HTML when i use get_html. No text should be coming back outside of html tags. 

I have the following ContentFilters set up:
ContentFilters="ConvertCharactersToEntities,ConvertFontToSpan,ConvertToXhtml,FixUlBoldItalic,OptimizeSpans,RemoveScripts"

Also not sure if this is a big deal but the editor is in a jquery dialog and the content is set on button click like so:


i know there are some known issues with the version of firefox i am using (3.6.15) and the editor as you can tell by the focus trick needed to get it to work. I just want to see if there are any other ways to go about doing what i want. thanks

I've noticed in Firefox 3.6.16 that after I click a noncheck button on the toolbar meant for single clicking purposes, an outline is formed around the button, and doesn't go away until I click somewhere else on the browser.  Is there a way to make it so the button doesn't stay outlined after I click it, so that it merely goes back to how it looked before it was clicked.  I've also noticed this doesn't happen in Internet Explorer.

I have two ListView's on a page and I want to associate one with the other. That is, selecting an item in the first list view will then display related data in the second list view. I've Googled, but can't find a good example of this scenario.

Is there an example or sample code I can review to help me figure this out?

Thanks!
Mark

Hello,

Can someone please tell me why my datasource is not updating when using the RadGrid?  I have read countless forum posts and still have been unable to solve the issue.  I wanted to use the AutomaticUpdate/Delete feature, because it appeared to be "simple".  I am using the grid to display a user's shopping cart contents.  All I want to be able to do is allow them to update the quantity of an item in the cart, or remove it....period.

Below is my code.  I have stripped it down to bare bones in hopes to find the problem, but still no luck.  This is driving me NUTS!

Any help would be greatly appreciated.

Thanks,
Jim



Code-behind:

We'd have a system custom module for the editor that would contain large save/close buttons (not toolbar sizes) we'd like to show only when the editor is in full screen.  I can detect the full screen toggling, but need a way to show/hide the module via javascript.  Basically the same functionality that the Module Manager button does without the user clicking on that button and selecting/deselecting our module.

Any way to do this?

I seem to be having a problem controlling the visibility of a RadMenuItem using inline code. I have an "Admins Only" dropdown I want to display only if a session variable test is true. I swear this used to work, but as of 2010Q3 it is not. The sample line is:



The page loads up fine, but no matter the content of the session variable (empty, "1", "2", nothing), the menu is always displayed.

Any suggestions?