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?

Hi all,

Is it possible to combine the 2 features (Multi columns and Check box) out of the box? I do not want to use checkbox and hidden fields in the item templates of the combo box in order to manage the multi selection feature. Please find the attached snap shoot of what i'm trying to achieve.

If this is doable it will be great providing me with working sample.

Regards,
Taiseer

Hello,

I'm currently using the RadGrid control with a delete button I've added to the "CommandItemTemplate" section. When the user selects certain rows and clicks delete, a client side event is called "delete_click". This function iterates over each selected row to build up an array of parameters which should include the primary key of the row. I'm currently using hidden columns to hold certain values needed in this function. Certain values are IsUserAdmin, userRole, and userId - but none of these should be displayed as a column in the grid.The primary key (data key) is userId.... "<MasterTableView DataKeyNames='userId'>

Question #1: Is there a better approach for associating these values with a row instead of hidden columns? You can see in the example below, to access the row's column "IsUserAdmin", I access the column by it's unique name. This is a column in the grid that is hidden. Can I associate this without using a hidden column as a better approach? 

Below is an example of how I access the cells for each selected row. 

         var grid = $find("<%=grdSummary.ClientID %>");
         var MasterTable = grid.get_masterTableView();
         var selectedRows = MasterTable.get_selectedItems();
         var parms = new Array();
         for (var i = 0; i < selectedRows.length; i++) {
         {  
          var row = selectedRows[i];
           parm = new ScheduleSummaryParms();
           // Retrieve Cell by column
           parm.IsAdmin = MasterTable.getCellByColumnUniqueName(row, "userIsAdmin").innerHTML; 
           parm.userRole = MasterTable.getCellByColumnUniqueName(row, "userIsAdmin").innerHTML;        
          parms[i] = parm;
         }

Question #2: Is there a way to access the row's primary key. I've been thinking about adding a hidden column for the primary key, but I thought there had to be a better way. I've seen examples using "getDataKeyValue", but this doesnt seem to work. 

Thanks!!

Hi,
   I have been trying to get this resolved. I have a grid with a GridCalculatedColumn, this column combines two Data fields and shows them together. I want to specify the Grid Sort Expression for this column in the grid so when the grid initially comes up its sorted by this column and the little sorting image in the column header is placed there to show the user the default column thats sorted. What should I put in the GridSortExpression's FieldName?  I can not seem to get this, It seems with a grid bound column the image appears since its a single datafield but how can I do the same thing with a grid calculated column *Updated* I actually have noticed the same issue with GridTemplateColumns as well, please let me know, thanks in advance!!