hi expert,

i am using the telerik rad grid in my projects can you please suggest the proper way for my problem

this is hierarchical grid(3 level) in the second and third level i use the "GridDropDownColumn" columns with my own datasource when i am in editing that row it show  the dorpdown when i change the drop down value in it the other column's values will be changed corresponding with some logic how can it possible and one more this i want to edit the multiple rows all the changes will be saved at final is it possible in this control. my code is  ,please look at the attached image also.

 &nbsp;<telerik:RadGrid ID="dgProduct" runat="server" AutoGenerateColumns="false" AllowAutomaticUpdates="true"
                                        AutoGenerateHierarchy="true" >
                                        <MasterTableView EditMode="InPlace" >
                                            <Columns>
                                                <telerik:GridBoundColumn DataField="PKProductID" HeaderText="PKProductID" Visible="false"><HeaderStyle BackColor="BlanchedAlmond" /></telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="SourceID" HeaderText="Style #" />
                                                <telerik:GridBoundColumn DataField="Language1Title" HeaderText="Title" />
                                                <telerik:GridBoundColumn DataField="Language1SubTitle" HeaderText="Sub Title" />
                                                <telerik:GridDropDownColumn HeaderText="Clearance" UniqueName="StyleClearance" DataSourceID="SourceCheck"
                                                    ListTextField="Text" ListValueField="Text" SortExpression="Text" DataField="ClearanceItem" />
                                                <telerik:GridDropDownColumn HeaderText="Active" UniqueName="StyleActive" DataSourceID="SourceCheck"
                                                    ListTextField="Text" ListValueField="Text" SortExpression="Text" DataField="Active" />
                                                <telerik:GridBoundColumn DataField="Price" HeaderText="Price" />
                                                <telerik:GridBoundColumn DataField="SalePrice" HeaderText="Sale Price" />
                                            </Columns>
                                            <DetailTables>
                                                <telerik:GridTableView DataMember="Colors" HierarchyLoadMode="ServerOnDemand" >
                                                    <Columns>
                                                        <telerik:GridBoundColumn DataField="FKProductid" HeaderText="FKProductid" Visible="false" />
                                                        <telerik:GridBoundColumn DataField="Language1Title" HeaderText="Title" ReadOnly="true" />
                                                         <telerik:GridBoundColumn DataField="PKGroupScaleItemID" HeaderText="Color Id" ReadOnly="true"  />
                                                           <telerik:GridDropDownColumn UniqueName="ColorSourceID" DataSourceID="SourceColors"
                                                            HeaderText="Colors" DataField="SourceID" SortExpression="ScaleLanguage1Name"
                                                            ListTextField="ScaleLanguage1Name" ListValueField="ScaleType" />
                                                        <telerik:GridDropDownColumn HeaderText="Active" UniqueName="ColorActive" DataSourceID="SourceCheck"
                                                            ListTextField="Text" ListValueField="Text" SortExpression="Text" DataField="Active" />
                                                    </Columns>
                                                    <DetailTables>
                                                        <telerik:GridTableView DataMember="Sizes" HierarchyLoadMode="ServerOnDemand"  Width="300px" >
                                                            <Columns>
                                                                <telerik:GridBoundColumn DataField="FKProductid" HeaderText="FKProductid" Visible="false" />
                                                                <telerik:GridBoundColumn DataField="Language1Title" HeaderText="Title" ReadOnly="true"  />
                                                                <telerik:GridBoundColumn DataField="SourceID" HeaderText="Size ID" ReadOnly="true" />
                                                                <telerik:GridDropDownColumn UniqueName="SizeSourceID" DataSourceID="SourceSizes"
                                                                    HeaderText="Sizes" DataField="SourceID" SortExpression="ScaleLanguage1Name" ListTextField="ScaleLanguage1Name"
                                                                    ListValueField="PKGroupScaleItemID" />
                                                                <telerik:GridBoundColumn DataField="BackOrderDays" HeaderText="Back Order Days" />
                                                                <telerik:GridBoundColumn DataField="SKU" HeaderText="SKU" />
                                                                <telerik:GridBoundColumn DataField="QuantityAvailable" HeaderText="Quantity" />
                                                                <telerik:GridDropDownColumn HeaderText="Active" UniqueName="SizeActive" DataSourceID="SourceCheck"
                                                                    ListTextField="Text" ListValueField="Text" SortExpression="Text" DataField="Active" />
                                                            </Columns>
                                                        </telerik:GridTableView>
                                                    </DetailTables>
                                                </telerik:GridTableView>
                                            </DetailTables>
                                            <EditFormSettings>
                                                <EditColumn Reorderable="false" Resizable="false" />
                                            </EditFormSettings>
                                        </MasterTableView>
                                        <ClientSettings>
                                            <ClientEvents OnRowClick="RowClick" OnRowDblClick="RowDblClick" />
                                            <ClientEvents OnColumnMouseOut=" />
                                        </ClientSettings>
                                    </telerik:RadGrid>

I have a databound grid and am needing to add an additional column that will show a link to a google map for the location designated for the record in each row.

firstly im not sure i am doing this in the correct place, second issue im having (using hard coded parameters) is that the URL is not including these parameter values, the URL just shows the querystring names but none of these has the additional values.

as far as i can see the url format string seems correct and the urlparameters variable is getting the string values set ok, but for some reason they are not replacing the palceholder values in the url.

finally how would i get at the actual datatable values i need once i have this hard coded version working correctly?

heres my code:

Private Sub FillGrid()
        Try

            Dim gc As GridBoundColumn
            Dim glc As GridHyperLinkColumn           

            glc = New GridHyperLinkColumn
            Me.uxGrid.Columns.Add(glc)
            glc.HeaderText = "Map"
            Dim urlparameters As String()           
            urlparameters = New String() {"b12jp", "1234", "32.54545", "-2.2342342"}
            glc.DataNavigateUrlFields = urlparameters
            glc.DataTextFormatString = "{2:D}"
            glc.DataTextFormatString = "{3:D}"
            glc.DataNavigateUrlFormatString = "GoogleMaps.htm?postcode={0}&id={1}&lat={2}&lng={3}"
            glc.UniqueName = ""
            glc.ItemStyle.HorizontalAlign = HorizontalAlign.Center
            glc.Text = "Map"
            glc.HeaderStyle.Width = Unit.Pixel(40)
            glc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center

            For Each col As DataColumn In _myData.Columns

                gc = New GridBoundColumn
                Me.uxGrid.Columns.Add(gc)
                gc.HeaderText = GetCaption(col.ColumnName)
                gc.UniqueName = col.ColumnName
                gc.DataField = col.ColumnName
                gc.Display = True
                gc.HeaderStyle.Width = Unit.Pixel(170)
                gc.ItemStyle.Wrap = True
            Next
           
        Catch ex As Exception
           
        End Try
    End Sub

Hi,

I'm trying to figure out how I can access the controls on a footer row outside the ItemDataBound event.

Objective:
I have a drop down list that has a OnSelected event. When the selection changes it needs to enable/disable controls that are in the footer row.

How can I accomplish this?

Hi,
I have created one usercontrol in Visual studio it contains Employee data here i performed Add,Delete,update,actions and i loaded this usercontrol in sharepoint site but i want to show toolbar for this form which contains Save,Edit like default sharepoint custom list how can i do for this.
here am sending my code please look at once

        protected void bt_add_Click1(object sender, EventArgs e)

        {

            Label6.Text = string.Empty;

            AddtoList();

            Label6.Visible = true;

        }

    

     

        protected void bt_view_Click(object sender, EventArgs e)

        {

            Gridview();

          

 

        }

        protected void bt_update_Click(object sender, EventArgs e)

        {

            Update();

            clear();

 

        }

        protected void btn_reset_Click(object sender, EventArgs e)

        {

            clearcontrols();

            Label6.Text = string.Empty;

           

        }

        protected void bt_delete_Click(object sender, EventArgs e)

        {

            Delete();

            txt_Item.Text = string.Empty;

        }

        protected void StuList_Grid_PageIndexChanged(object sender, GridPageChangedEventArgs e)

        {

            StuList_Grid.CurrentPageIndex = e.NewPageIndex;

            StuList_Grid.Visible = true;

            SPList taskList = SpListitems();

            DataTable tablelist = taskList.Items.GetDataTable();

            StuList_Grid.DataSource = tablelist;

            StuList_Grid.DataBind();

 

        }

        protected void Page_Load(object sender, EventArgs e)

        {

 

        }

      

        #endregion

        #region Methods

        //This method will display the sharepoint list items to Grid and

        //Show listitems in textboxes by id.

        private void Gridview()

        {

 

            if (txt_Item.Text == string.Empty)

            {

                try

                {

                    StuList_Grid.Visible = true;

                    Descending();

                    StuList_Grid.CurrentPageIndex = 0;

                    SPList taskList = SpListitems();

                    DataTable tablelist = taskList.Items.GetDataTable();

                    StuList_Grid.DataSource = tablelist;

                    StuList_Grid.DataBind();

                    Label6.Text = string.Empty;

                }

                catch (Exception ex)

                {

                    ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(),

                    "AlertScript", "(function(){var f = function(){alert('not viewed', 370,210);Sys.Application.remove_load(f) ;};Sys.Application.add_load(f) ;})();", true);

 

                }

            }

            else

            {

                 StuList_Grid.Visible = false;

                    SPList taskList = SpListitems();

                    int id = Convert.ToInt32(txt_Item.Text);

                    SPListItem item = null;

                    try

                    {

                     

                        item = taskList.GetItemById(id);

                    }

                    catch (Exception ex)

                    {

                        Label6.Text = "Item doesnot Exist";

                    

                    }

                    if (item != null)

                    {

                        if (item["StuName"] != null)

                        {

                            txt_name.Text = item["StuName"].ToString();

                        }

                        else

                            txt_name.Text = string.Empty;

                        if (item["Department"] != null)

                        {

                            txt_dept.Text = item["Department"].ToString();

                        }

                        else

                            txt_dept.Text = string.Empty;

                        if (item["Location"] != null)

                        {

                            txt_location.Text = item["Location"].ToString();

                        }

                        else

                            txt_location.Text = string.Empty;

                        if (item["ContactNumber"] != null)

                        {

                            txt_number.Text = item["ContactNumber"].ToString();

                        }

                        else

                            txt_number.Text = string.Empty;

                        Label6.Text = string.Empty;

                    }

           

            }

           

            }

 

        //This will add textbox values to sharepoint list.

        private void AddtoList()

        {

            try

            {

                SPList taskList = SpListitems();

                SPListItem listitem = taskList.Items.Add();

                listitem["StuName"] = txt_name.Text;

                listitem["Department"] = txt_dept.Text;

                listitem["Location"] = txt_location.Text;

                listitem["ContactNumber"] = txt_number.Text;

                listitem.Update();

                Label6.Text  = "Records Saved";

                clearcontrols();

                Descending();

                grid();

 

            }

            catch (Exception ex)

            {

                ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(),

                "AlertScript", "(function(){var f = function(){alert('not inserted', 370,210);Sys.Application.remove_load(f) ;};Sys.Application.add_load(f) ;})();", true);

 

 

            }

        }

 

      

        //This will update the list items by id

        private void Update()

        {

            try

            {

                if (txt_Item.Text == string.Empty)

                {

                    Label6.Text = "ID value is Required";

                  

                }

              

                SPList taskList = SpListitems();

 

                SPListItem item = null;

                int id = Convert.ToInt32(txt_Item.Text);

                try

                {

                    item = taskList.GetItemById(id);

                }

                catch (Exception ex)

                {

                    Label6.Text = "Item doesnot Exist";

                   

                }

                if (item != null)

                {

                    item["StuName"] = txt_name.Text;

                    item["Department"] = txt_dept.Text;

                    item["Location"] = txt_location.Text;

                    item["ContactNumber"] = txt_number.Text;

                    item.Update();

                    taskList.Update();

                    Label6.Text = "Updated";

                    grid();

                }

              

            }

 

            catch (Exception ex)

            {

 

                ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(),

                "AlertScript", "(function(){var f = function(){alert('Not Updated', 370,210);Sys.Application.remove_load(f) ;};Sys.Application.add_load(f) ;})();", true);

 

            }

 

        }

        //This will delete the list items by id

        private void Delete()

        {

            try

            {

                if (txt_Item.Text == string.Empty)

                {

                    Label6.Text = "ID value is Required";

                   

                }

                else

                {

                    SPList taskList = SpListitems();

 

                    SPListItem item = null;

                    int id = Convert.ToInt32(txt_Item.Text);

                    try

                    {

                        item = taskList.GetItemById(id);

                    }

                    catch (Exception ex)

                    {

                        Label6.Text = "Item Doesnot Exist";

                      

                    }

                    if (item != null)

                    {

                        item["StuName"] = txt_name.Text;

                        item["Department"] = txt_dept.Text;

                        item["Location"] = txt_location.Text;

                        item["ContactNumber"] = txt_number.Text;

                        item.Delete();

                        Label6.Text = "Deleted";

                        grid();

                    }

                }

 

            }

 

            catch (Exception ex)

            {

 

                ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(),

                "AlertScript", "(function(){var f = function(){alert('Not Deleted', 370,210);Sys.Application.remove_load(f) ;};Sys.Application.add_load(f) ;})();", true);

 

            }

 

        }

      

        //This will return value from method

        protected SPList SpListitems()

        {

            string strDashListRoot = "http://dev02:2000";

            SPSite osite = new SPSite(strDashListRoot);

            SPWeb oWeb = osite.OpenWeb();

            oWeb.AllowUnsafeUpdates = true;

            SPList taskList = oWeb.Lists["Name"];

            return taskList;

        }

       

        //This clear all textboxes and grid

        private void clearcontrols()

        {

            txt_name.Text = string.Empty;

            txt_dept.Text = string.Empty;

            txt_location.Text = string.Empty;

            txt_number.Text = string.Empty;

            txt_Item.Text = string.Empty;

            StuList_Grid.Visible = false;

        }

       

        //This clear all textboxes

        private void clear()

        {

            txt_name.Text = string.Empty;

            txt_dept.Text = string.Empty;

            txt_location.Text = string.Empty;

            txt_number.Text = string.Empty;

            txt_Item.Text = string.Empty;

        }

       

        //This to bind  the grid

        private void grid()

        {

            

            StuList_Grid.Visible = true;

            SPList taskList = SpListitems();

            StuList_Grid.CurrentPageIndex = 0;

            //StuList_Grid.CurrentPageIndex = StuList_Grid.PageCount - 1;

            DataTable tablelist = taskList.Items.GetDataTable();

            StuList_Grid.DataSource = tablelist;

            StuList_Grid.DataBind();

 

        }

       

        //This will display latest item first in grid id in descending order

        private void Descending()

        {

            GridSortExpression expression = new GridSortExpression();

            expression.FieldName = "ID";

            expression.SortOrder = GridSortOrder.Descending;

            StuList_Grid.MasterTableView.SortExpressions.AddSortExpression(expression);

        }

 

        #endregion

    }

}

 

Thanks&Regards
P.Durga

Hello Telerik,

There are lots of threads about RadGrid inside RadDocks. I'd like to ask about the reverse - RadDocks inside RadGrid.

Please see below:


Will this work?

I want to populate the grid dynamically with cells of RadDockZones. The reason I want to use RadGrid is I want to be able to easily resize the RadDockZones that are in each cell in a RadGrid.

And when the RadDockZones are created, dynamic RadDocks will be created and placed in any of the created RadDockZones.

Different web controls (textboxes, labels, dropdowns, checkboxes) will be dynamically created in a RadDock.

Will the RadDocks (with its contents) then be able to move to any RadDockZone in the RadGrid?

The size of the RadDockZone will be dependent on the size of the cell in the RadGrid.

Finally, the state of the docks will be saved to a database.

When this state is retrieved from the database, the whole RadGrid with its RadDockZones and its RadDocks will be reconstructed.

Can anyone point me in the right direction? Is there any alternative to using RadGrid and still be able to easily resize cells that have RadDocks in them?

Thanks!

Hi,
I am building an asp.net 2.0 application referencing telerik ajax. The Telerik.Web.UI can not be resolved with following warning,

Warning    8    The primary reference "Telerik.Web.UI" could not be resolved because it has an indirect dependency on the framework assembly "System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" which could not be resolved in the currently targeted framework. ".NETFramework,Version=v2.0". To resolve this problem, either remove the reference "Telerik.Web.UI" or retarget your application to a framework version which contains "System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

What should I do? Shall I replace Telerik.Web.UI with older version or something else?

Thanks,
York

I'm having quite the issue trying to DataBind a bool? value to the Enabled property slider in a GridTemplateColumn of a Grid.
Here is my setup:

This is not working at all. Every item in the slider still remains enabled. Note, while the "Static" bool's can be null, I tried this is with a bool value guaranteed not to be null using Enabled='<%# !(bool)DataBinder.Eval(Container, "DataItem.NormalBool") %>' , and it still doesn't work.
I even tried to do Text='<%# DataBinder.Eval(Container, "DataItem.SomeText") %>' and that didn't show up. Nothing seems to DataBind to the Sliders.

Any advice?
I know I can do all of this through the Grid's itemdatabound, but I'd prefer not to.

Hello,

I'm using a modal dialog which is a RadWindow. The page should present an alert using "radalert" if the user has not saved their work. When the save button is clicked a hidden field is updated "hdnIsModified". When the close button is clicked, the "ClosePage()" function is called which passes an argument to the calling page if the page has been modified. Before the page closes, "onBeforeWindowClose" is called to determine if the alert should be displayed.

The problem is that I'm getting an error message (Cant execute code from a freed script) if the user makes a change to a dropdown list inside the RadAjaxPanel, then clicks "save", then "Cancel". If the user does not change the dropdown list and only clicks "save", then "cancel", it works fine. The dropdown list causes an ajax request since it's inside the radajaxpanel. Any ideas why this could interfere with the RadAlert logic? The "Save" and "Cancel" buttons are not inside the RadAjaxPanel.


RadWindow as Modal:

I just upgraded to the latest version of the RadControls.

I upgraded through the Visual Studio 2010 Telerik menu.
The upgarde took it upon itself to modify the asp code.

Before the upgrade I had code like this...

After the upgrade I had code like this....

Which resulted in lots of errors aboout Unique names not allowed to have spaces.....space I did not put there!!
Why did the upgrade making these changes?
I now have hours of testing and fixing to do!!!!

My requirements are to have sorting, pagination and grouping of the data done on the server-side.  With advanced data-binding, and custom pagination, via the NeedDataSource event, I'm able to easily do the sorting on the entire dataset and use pagination information to slice the data to send to the client.  However the issue is how to deal with grouping on the server side so that the RadGrid can display it.

I've looked through the demos, tutorials, documentation, forum, etc. and haven't seen anything on it, so if I've missed something please let me know.  One reference I came across is in the "limitation" section of the http://www.telerik.com/help/aspnet/grid/grdbasicgrouping.html document.

Has anyone dealt with this issue, have any ideas or advice?