Telerik Forums
UI for ASP.NET AJAX Forum
9 answers
176 views
Heey guys

I have  a question is it possible to bind tow sql sources in one RadScheudler ?  An example with sql would really help  

My code 
<%@ Page Title="" Language="C#" MasterPageFile="~/ABBMaster.Master" AutoEventWireup="true" CodeBehind="UserScheduler.aspx.cs" Inherits="HolidayTracker.User.UserScheduler" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="MainRegionContentPlaceHolder" runat="server">
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            function Export(sender, e) {
                $find("<%= RadAjaxManager1.ClientID %>").__doPostBack(sender.name, "");
            }
 
        </script>
    </telerik:RadCodeBlock>
    <style type="text/css">
        .RadScheduler .rsExportButton {
            position: absolute;
            bottom: 0;
            right: 0;
            border: 0;
            height: 24px;
            width: 24px;
            background: url('exportButtonli.gif') no-repeat center center;
        }
 
        .RadScheduler .rsAllDayRow .rsExportButton {
            right: 20px;
            height: 16px;
            width: 16px;
            bottom: 20px;
            background: url('exportButton.gif');
        }
 
        #Label1Panel {
            display: inline !important;
        }
 
        .lblError {
            background: #CC0000;
            border: 1px solid darkred;
            color: white;
            font: bold 16px "Segoe UI", Arial, sans-serif;
            vertical-align: middle;
            display: none;
            height: 30px;
            line-height: 28px;
            position: absolute;
            padding-left: 5px;
            width: 743px;
            z-index: 1001;
            cursor: pointer;
            opacity: 0.9;
            -moz-opacity: 0.9;
            filter: alpha(opacity=90);
        }
 
        .rsCustomAppointmentContainer div {
            width: 100% !important;
        }
 
        .rsCustomAppointmentContainer h2 {
            overflow: hidden !important;
            white-space: nowrap !important;
            text-overflow: ellipsis !important;
        }
    </style>
 
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadScheduler1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl>
                    <telerik:AjaxUpdatedControl ControlID="Label1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <asp:Label ID="Label1" runat="server" CssClass="lblError"></asp:Label>
    <div style="margin: 5px 0">
        <asp:ImageButton runat="server" ID="Button2" ImageUrl="exportButton.gif" AlternateText="Export All to Lotus Notes"
            OnClientClick="Export(this, event); return false;" OnClick="Button2_Click"></asp:ImageButton>
    </div>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" InitialDelayTime="200">
    </telerik:RadAjaxLoadingPanel>
    <div class="exampleContainer">
        <telerik:RadScheduler runat="server" ID="RadScheduler1" Width="750px"
            DayStartTime="07:00:00" DayEndTime="18:00:00" DataSourceID="SqlDataSource1"
            DataKeyField="VacationDayId" DataSubjectField="Title" DataStartField="FromDate" DataEndField="ToDate"
            OnAppointmentUpdate="RadScheduler1_AppointmentUpdate"
            OnAppointmentInsert="RadScheduler1_AppointmentInsert"
            OnRecurrenceExceptionCreated="RadScheduler1_RecurrenceExceptionCreated">
            <AdvancedForm Modal="true"></AdvancedForm>
            <TimelineView UserSelectable="false"></TimelineView>
            <TimeSlotContextMenuSettings EnableDefault="true"></TimeSlotContextMenuSettings>
            <AppointmentContextMenuSettings EnableDefault="true"></AppointmentContextMenuSettings>
        </telerik:RadScheduler>
    </div>
 
    <asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=HolidayTrackerEntities" DefaultContainerName="HolidayTrackerEntities" EnableDelete="True" EnableFlattening="False" EnableInsert="True" EntitySetName="HtVacationDays"></asp:EntityDataSource>
 
 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HolidayTrackerConnectionString %>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [HtVacationDay]" DeleteCommand="DELETE FROM [HtVacationDay] WHERE [VacationDayId] = @original_VacationDayId" InsertCommand="INSERT INTO [HtVacationDay] ([Title], [FromDate], [UserId], [Hours], [ToDate], [RecurrenceRule], [RecurrenceRuleID]) VALUES (@Title, @FromDate, @UserId, @Hours, @ToDate, @RecurrenceRule, @RecurrenceRuleID)" UpdateCommand="UPDATE [HtVacationDay] SET [Title] = @Title, [FromDate] = @FromDate, [UserId] = @UserId, [Hours] = @Hours, [ToDate] = @ToDate, [RecurrenceRule] = @RecurrenceRule, [RecurrenceRuleID] = @RecurrenceRuleID WHERE [VacationDayId] = @original_VacationDayId">
        <DeleteParameters>
            <asp:Parameter Name="original_VacationDayId" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="FromDate" Type="DateTime" />
            <asp:Parameter Name="UserId" Type="Int32" />
            <asp:Parameter Name="Hours" Type="Double" />
            <asp:Parameter Name="ToDate" Type="DateTime" />
            <asp:Parameter Name="RecurrenceRule" Type="String" />
            <asp:Parameter Name="RecurrenceRuleID" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="FromDate" Type="DateTime" />
            <asp:Parameter Name="UserId" Type="Int32" />
            <asp:Parameter Name="Hours" Type="Double" />
            <asp:Parameter Name="ToDate" Type="DateTime" />
            <asp:Parameter Name="RecurrenceRule" Type="String" />
            <asp:Parameter Name="RecurrenceRuleID" Type="String" />
            <asp:Parameter Name="original_VacationDayId" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
   
</asp:Content>

Thanks for help and fast answer
Plamen
Telerik team
 answered on 28 Nov 2012
3 answers
119 views
Hello,

I'm using the scheduler with a few custom attributes to handle some additional fields. Here's an example below.

When I perform the insert (the edit works the same way), I am handling the "AppointmentInsert" event and accessing the values with e.Appointment.Attributes("CustomAttribute").

For the AdminNotes and PublicNotes, this gets a value, for the AllocationGroupID and SlotCode, it just comes back as an empty string. Everything is otherwise identical and I can't figure it out here...

Anybody have any ideas?

Thanks,

Mike
Private Sub roomSlots_AppointmentInsert(sender As Object, e As Telerik.Web.UI.AppointmentInsertEventArgs) Handles roomSlots.AppointmentInsert
    Dim newSlot As New ProgramSlotInfo
    Dim ctlSlots As New ProgramSlotController
    With newSlot
        .ConferenceID = ConferenceID
        .StartTime = e.Appointment.Start
        .EndTime = e.Appointment.End
        .LocationRoomID = LocationRoomID
        .SlotCode = e.Appointment.Attributes("SlotCode")
        .AdminNotes = e.Appointment.Attributes("AdminNotes")
        .PublicNotes = e.Appointment.Attributes("PublicNotes")
        .AllocationGroupID = e.Appointment.Attributes("AllocationGroupID")
    End With
    ctlSlots.AddProgramSlot(newSlot)
End Sub


<telerik:RadScheduler runat="server" ID="roomSlots" AllowEdit="True" AllowDelete="True"
    AllowInsert="True" EnableDatePicker="False" SelectedView="WeekView" ShowAllDayRow="False"
    Width="100%" DataKeyField="ProgramSlotID"
    DataSubjectField="SlotCode" DataStartField="StartTime" DataEndField="EndTime" StartInsertingInAdvancedForm="true"
    EnableCustomAttributeEditing="true" CustomAttributeNames="PublicNotes,SlotCode,AdminNotes,AllocationGroupID" MinutesPerRow="60">
    <AdvancedInsertTemplate>
        <h2 class="dnnFormSectionHead"><asp:Label runat="server" ID="lblAddSlotHeader" resourcekey="AddSlotHeader" Text="Add New Slot"></asp:Label></h2>
        <div class="dnnForm">
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblStartTime" text="Start" resourcekey="StartLabel"></dnn:label>
                <telerik:RadDateTimePicker runat="server" ID="startTime" SelectedDate='<%#bind("Start") %>' TimeView-Interval="00:15:00" TimeView-Columns="4" TimeView-StartTime="6:00:00"></telerik:RadDateTimePicker>
            </div>
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblEndTime" text="End" resourcekey="EndLabel"></dnn:label>
                <telerik:RadDateTimePicker runat="server" ID="endTime" SelectedDate='<%#bind("End") %>' TimeView-Interval="00:15:00" TimeView-Columns="4" TimeView-StartTime="6:00:00"></telerik:RadDateTimePicker>
            </div>
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblSlotCode" text="Slot Code" resourcekey="SlotCodeLabel"></dnn:label>
                <asp:TextBox runat="server" ID="txtSlotCode" Text='<%# Bind("SlotCode") %>'></asp:TextBox>
            </div>
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblAllocationGroup" text="Allocation Group" resourcekey="AllocationGroupLabel"></dnn:label>
                <telerik:RadComboBox runat="server" ID="cboAllocationGroup" DataTextField="GroupName" DataValueField="AllocationGroupID" DataSourceID="dsAllocationGroups" selectedValue='<%#bind("AllocationGroupID") %>'></telerik:RadComboBox>
            </div>
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblPublicNotes" text="Public Notes" resourcekey="PublicNotesLabel"></dnn:label>
                <asp:TextBox runat="server" ID="txtPublicNotes" TextMode="MultiLine" Text='<%#Bind("PublicNotes") %>'></asp:TextBox>
            </div>
            <div class="dnnFormItem">
                <dnn:label runat="server" id="lblAdminNotes" text="Administrative Notes" resourcekey="AdminNotesLabel"></dnn:label>
                <asp:TextBox runat="server" ID="TextBox1" TextMode="MultiLine" Text='<%#Bind("AdminNotes") %>'></asp:TextBox>
            </div>
 
            <asp:LinkButton runat="server" ID="lnkCreateSlot" CommandName="Insert" Text="Create Slot" CssClass="dnnPrimaryAction"></asp:LinkButton>
            <asp:LinkButton runat="server" ID="lnkCancelInsert" CommandName="Cancel" Text="Cancel" CssClass="dnnSecondaryAction"></asp:LinkButton>
        </div>
    </AdvancedInsertTemplate>
Plamen
Telerik team
 answered on 28 Nov 2012
2 answers
88 views
Hello

Sorry if this is obviously available info elsewhere, but I checked the help docs and change logs and couln't see it.

Anyway, I'm (still!) stuck using an older version of the ASP.NET AJAX controls (2010 Q3 SP2), and was wondering what the officially supported browsers are/were.  I'm guessing that it's simply the latest versions if IE amd Firefox as of the time, plus IE6, but just wanted to confirm?

If so, and for future reference, is that a general case -- that on release the supported versions of each browser are up to the latest version on release?

Cheers.


Ian C
Ian
Top achievements
Rank 1
 answered on 28 Nov 2012
3 answers
170 views
Hi
I am using VS 2008 with your latest release and .net 3.5 and C#.  I have a radgrid whith data columns defined using templates as follows:

<

 

telerik:GridTemplateColumn   

 

        <ItemTemplate>

 

 

            <asp:Label ID="ShortActivityDescription"

 

 

                runat="server"

 

 

               Text='<%# Eval("ShortActivityDescription")%>'>

 

 

            </asp:Label>

 

 

        </ItemTemplate>

 

 

</telerik:GridTemplateColumn>

I originally load the grid (server side) during page load using the OnNeedDatasouce method defined in the RadGrid definition.  Thereafter, I am using javascript and webservice(s) to do the insert, update, and delete logic and database IO.  The webservice returns a list of data records to the calling javascript function.  the successful completion method then does the following code (exactly like your demo example):

 

 

function Get_West_Activity_Grid_Complete(result)

 

{

 

if (result != null)

 

    {

 

 

    var tableView = $find("<%= Grid_West.ClientID %>").get_masterTableView();

 

    tableView.set_dataSource(result);

    tableView.dataBind();

 

 


    var
grid = $find("<%= Grid_West.ClientID %>");

 

    grid.repaint();

 

    }

}

 

The data gets added, changed, or deleted to/from the database but the grid does not refresh reflecting the changed data.  The data properties in the web service result list contain the correct data and number of list objects are correct.  The List properties identifiers(names) match the label id in the item template.  The grid has the EnableAJAX property set to true.

I have researched the Forum material, user documentation and clientside api material and cannot see what I am doing wrong.  I have read thru the following sources:

Grid / WebService Binding
Grid / .NET 3.5 Client-side Data Binding - automatic binding to WCF and ADO.NET services
Grid / Declarative Binding
Grid / Programmatic Binding
Grid / Client-side Binding and Caching

Please help

Daniel
Telerik team
 answered on 28 Nov 2012
5 answers
177 views
hi ,i want to make one of the  columns unselectable  so the user can't select row by clicking on that column  or unselect  or darg mouse to select multi rows in same time (this column have no effect to select or unselect row or rows)
Ashraf
Top achievements
Rank 2
 answered on 28 Nov 2012
4 answers
112 views
I am getting an error that is just causing me all sorts of consternation finding a solution to.  My code was working until I made some changes and posted it back onto the production server.  The biggest problem here is that I don't get the error to occur on my dev machine so I can't use my debugger for any help.

I have an ASPX website with a Telerik RadGrid (version 2011.2.915.40) with another couple of RadGrids inside of the main 
NestedViewTemplate.  I have checked all throughout my code looking for a place where this conversion from
nvarchar to int may be taking place yet i can't find it.  I don't understand why this error is occurring and 
would be most grateful to anyone that has run into something like this before and can give me a heads up
on what might be happening.  Please see error message below.

Thanks,

James


Javascript error on Browser:
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E)
Timestamp: Wed, 21 Nov 2012 21:11:39 UTC
Message: Sys.WebForms.PageRequestManagerServerErrorException: Conversion failed when converting the nvarchar value 'CO00024843' to data type int.
Line: 3
Char: 74741
Code: 0
URI: https://localhost/IPM/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bAjaxControlToolkit%2c+Version%3d4.1.60919.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d28f01b0e84b6d53e%3aen-US%3aee051b62-9cd6-49a5-87bb-93c07bc43d63%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%3aen-US%3a9799c67b-558a-475d-bf30-a0ccf0dbb8b7%3a16e4e7cd%3af7645509%3a22a6274a%3aed16cbdc%3a24ee1bba%3a19620875%3a874f8ea2%3af46195d3%3a490a9d4e%3abd8f85e4%3a58366029%3ae330518b%3a1e771326%3ac8618e41%3ae4f8f289

CodeBehind error:  System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'CO00024843' to data type int.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callb
Eyup
Telerik team
 answered on 28 Nov 2012
14 answers
818 views
Hi,

I've enabled the Header context menu for column and would like to hide/disable some of the columns that appear in the list. What is the best way to do this, are there any samples?

Thanks
Badrinarayanan
Top achievements
Rank 1
 answered on 28 Nov 2012
1 answer
288 views
Hi Friends,
I need to perform insert,update,delete operation in radgrid by passing values from  external textboxes and external button click event in SQL DB statement.
Examples given in radgrid demo is on client side and also external form template mode.so its not useful,pls dont post me as refer this link in telerik demo.

In this code,I created radgrid.And an External textbox and external  radbuttons .On row select i pass the radgrid selected row  values to external textboxes using javascript.Now i need is when i click update ,insert,delete button ,based on textbox value,radgrid needs to binded,


I fir


Pls anyone  help on this matter ,here my code
<head runat="server">
    <title>Sales Dashboard</title>
    <link rel="shortcut icon" href="favicon.ico" />
    <link href="styles.css" rel="stylesheet" type="text/css" />
    <link href="Skins/TreeView.SalesBlack.css" rel="stylesheet" type="text/css" />
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            function RowSelected(sender, args) {
 
            
                document.getElementById("<%= tag_name.ClientID %>").innerHTML =
                  "Resource Name";
                document.getElementById("<%= tag_mobile.ClientID %>").innerHTML =
                  "Mobile No";
                document.getElementById("<%= tag_email.ClientID %>").innerHTML =
                  "E-Mail";
                document.getElementById("<%= tag_primary.ClientID %>").innerHTML =
                  "Primary Skill";
                document.getElementById("<%= tag_createdby.ClientID %>").innerHTML =
                  "Created By";
                 
 
                document.getElementById("<%= lbl_name.ClientID %>").innerHTML =
                  args.getDataKeyValue("ResourceName");
                document.getElementById("<%= lbl_mobile.ClientID %>").innerHTML =
                  args.getDataKeyValue("MobileNo");
                document.getElementById("<%= lbl_email.ClientID %>").innerHTML =
                  args.getDataKeyValue("EMail");
 
                document.getElementById("<%= lbl_primary.ClientID %>").innerHTML =
                  args.getDataKeyValue("PrimarySkill");
                document.getElementById("<%= lbl_createdby.ClientID %>").innerHTML =
                  args.getDataKeyValue("CreatedBy");
                 
                var txt_name = $find("txt_name");
                txt_name.set_value(args.getDataKeyValue("ResourceName"));
 
                var txt_mobile = $find("txt_mobile");
                txt_mobile.set_value(args.getDataKeyValue("MobileNo"));
 
 
                var txt_email = $find("txt_email");
                txt_email.set_value(args.getDataKeyValue("EMail"));
 
                var txt_primary = $find("txt_primary");
                txt_primary.set_value(args.getDataKeyValue("PrimarySkill"));
 
                var txt_createdby = $find("txt_createdby");
                txt_createdby.set_value(args.getDataKeyValue("CreatedBy"));
 
 
                var textbox = $find("txt_name");
                textbox.set_visible(false);
 
                var textbox1 = $find("txt_mobile");
 
                textbox1.set_visible(false);
 
                var textbox2 = $find("txt_email");
 
                textbox2.set_visible(false);
 
                var textbox4 = $find("txt_primary");
 
                textbox4.set_visible(false);
                var textbox3 = $find("txt_createdby");
 
                textbox3.set_visible(false);
 
                 
 
                document.getElementById("<%= lbl_name.ClientID %>").style.display = 'block';
                document.getElementById("<%= lbl_mobile.ClientID %>").style.display = 'block';
 
                document.getElementById("<%= lbl_email.ClientID %>").style.display = 'block';
                document.getElementById("<%= lbl_primary.ClientID %>").style.display = 'block';
 
                document.getElementById("<%= lbl_createdby.ClientID %>").style.display = 'block';
 
                document.getElementById("<%= edit.ClientID %>").style.display = "block";
 
            }
        </script>
        <script type="text/javascript">
            function edit(button, args) {
                debugger;
                var textbox = $find("txt_name");
                textbox.set_visible(true);
 
                var textbox1 = $find("txt_mobile");
                textbox1.set_visible(true);
                var textbox2 = $find("txt_email");
                textbox2.set_visible(true);
 
                var textbox4 = $find("txt_primary");
                textbox4.set_visible(true);
                var textbox3 = $find("txt_createdby");
                textbox3.set_visible(true);
 
                
 
                document.getElementById("<%= lbl_name.ClientID %>").style.display = 'none';
                document.getElementById("<%= lbl_mobile.ClientID %>").style.display = 'none';
                document.getElementById("<%= lbl_email.ClientID %>").style.display = 'none';
                document.getElementById("<%= lbl_primary.ClientID %>").style.display = 'none';
                document.getElementById("<%= lbl_createdby.ClientID %>").style.display = 'none';
                var btn = $find("edit");
                 btn.set_value = ("Update");
 
 
                button.set_autoPostBack(false);
//                var textbox = $find("txt_name");
//                textbox.set_visible(true);
//                var txtDate = $find("txt_name");
//                txtDate.set_value(args.getDataKeyValue("ResourceName"));
            }
 
        </script>
    </telerik:RadCodeBlock>
    <style type="text/css">
        .align
        {
            text-align: right;
        }
    </style>
    <style type="text/css">
    .edit
    {
        display:none;
    }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
        </Scripts>
    </telerik:RadScriptManager>
    <telerik:RadStyleSheetManager runat="server" ID="RadStyleSheetManager1" />
    <telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" DecoratedControls="Scrollbars" />
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <div style="width: 60%; height: 100%; float: left;">
        <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" ShowFooter="True"
            Style="outline: 0"  GroupingEnabled="true" ShowGroupPanel="true" AutoGenerateColumns="False"
            AllowSorting="True"  PageSize="15" Width="90%"  GridLines="None" CellPadding="0"
            OnNeedDataSource="RadGrid1_NeedDataSource" Skin="Black"
            >
            <MasterTableView ClientDataKeyNames="ResourceName,MobileNo ,EMail ,CreatedBy ,PrimarySkill"
                AutoGenerateColumns="false" ShowFooter="true" AllowFilteringByColumn="true" PagerStyle-Mode="NextPrevAndNumeric"
                TableLayout="Fixed">
                <Columns>
                    <telerik:GridBoundColumn DataField="ResourceName" HeaderText="Resource Name" UniqueName ="ResourceName" CurrentFilterFunction="equalto"
                        FilterDelay="1000" ShowFilterIcon="false" HeaderStyle-Width="120px" FilterControlWidth="105px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="MobileNo" HeaderStyle-Width="110px" HeaderText="Mobile"
                        FilterControlWidth="70px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="EMail" UniqueName ="email" HeaderStyle-Width="190px" HeaderText="E-Mail"
                        FilterControlWidth="120px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="CreatedBy" HeaderText="Created By" CurrentFilterFunction="equalto"
                        FilterDelay="1000" ShowFilterIcon="false" FilterControlWidth="70px">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="PrimarySkill" UniqueName ="CurrentDesign" HeaderStyle-Width="190px" HeaderText="Primary Skill"
                        FilterControlWidth="0px">
                    </telerik:GridBoundColumn>
                      
 
                    
                </Columns>
            </MasterTableView>
            <ClientSettings  EnablePostBackOnRowClick="true" EnableRowHoverStyle="true" AllowDragToGroup="true"
                AllowColumnsReorder="true" ReorderColumnsOnClient="true" ColumnsReorderMethod="Reorder">
               
               <Selecting AllowRowSelect ="true"  />
              
                  <ClientEvents OnRowSelected="RowSelected"></ClientEvents>
                                        
                <Animation AllowColumnReorderAnimation="true" AllowColumnRevertAnimation="true">
                </Animation>
 
                  <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True" />
            </ClientSettings>
        </telerik:RadGrid>
    </div>
    <div style="width: 40%; height: 80%; float: right;">
>
                                     
        <table style="margin: 50% auto auto 1px">
            <tr>
                <td>
                    <asp:Panel  ID="panel1" runat="server">
                        <table>
                            <tr>
                                <td>
                                    <asp:Label ID="tag_name" Font-Bold="True"  ForeColor="#B5B5B5" Font-Size="Small" runat="server"></asp:Label>
                                </td>
                                <td>
                                    <asp:Label ID="lbl_name" runat="server" ForeColor="WhiteSmoke" Font-Bold="True" Font-Size="Large"></asp:Label>
                                    <telerik:RadTextBox  ID="txt_name" runat="server" ForeColor="WhiteSmoke"  Skin="Black" Font-Size="Large">
                                    </telerik:RadTextBox>
                                     
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:Label ID="tag_mobile" ForeColor="#B5B5B5" runat="server" Font-Bold="True" Font-Size="Small"></asp:Label>
                                </td>
                                <td>
                                    <asp:Label ID="lbl_mobile" ForeColor="WhiteSmoke" Font-Size="Large" runat="server"></asp:Label>
                                     <telerik:RadTextBox ID="txt_mobile" runat ="server" ForeColor ="WhiteSmoke" Font-Size="Large" Skin ="Black"   ></telerik:RadTextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:Label ID="tag_email" ForeColor="#B5B5B5" runat="server" Font-Bold="True" Font-Size="Small"></asp:Label>
                                </td>
                                <td>
                                    <asp:Label ID="lbl_email" ForeColor="WhiteSmoke" Font-Size="Large" runat="server"></asp:Label>
                                         <telerik:RadTextBox ID="txt_email" runat ="server" ForeColor ="WhiteSmoke" Font-Size="Large"  Skin ="Black"  ></telerik:RadTextBox>
                                     
                                </td>
                            </tr>
                             
                            <tr>
                                <td>
                                    <asp:Label ID="tag_primary" ForeColor="#B5B5B5" runat="server" Font-Bold="True"
                                        Font-Size="Small"></asp:Label>
                                </td>
                                <td>
                                    <asp:Label ID="lbl_primary" ForeColor="WhiteSmoke" Font-Size="Large" runat="server"></asp:Label>
                                         <telerik:RadTextBox ID="txt_primary" runat ="server"
                                        ForeColor ="WhiteSmoke" Font-Size="Large"    Skin="Black"
                                         ></telerik:RadTextBox>
                                     
                                </td>
 
 
 
                            </tr>
 
                            <tr>
                                <td>
                                    <asp:Label ID="tag_createdby" ForeColor="#B5B5B5" runat="server" Font-Bold="True"
                                        Font-Size="Small"></asp:Label>
                                </td>
                                <td>
                                    <asp:Label ID="lbl_createdby"  ForeColor="WhiteSmoke" Font-Size="Large" runat="server"></asp:Label>
                                         <telerik:RadTextBox ID="txt_createdby" runat ="server" ForeColor ="WhiteSmoke" Font-Size="Large"    Skin="Black" ></telerik:RadTextBox>
                                     
                                </td>
                            </tr>
                            <tr>
                                <td>
                                <telerik:RadButton ID="edit" Width="35px" Text="Edit" style="display :none;"     OnClientClicked="edit"
                                        runat ="server" Skin="Forest"
                                         >
                                          
                                          
                                         </telerik:RadButton>
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
 

My cs code is :

public partial class DMSdashboard : System.Web.UI.Page
    {
        SqlConnection conn = null;
        SqlDataReader reader = null;
        protected void Page_Load(object sender, EventArgs e)
        {
             
            
                 
 
             
        }
 
 
 
 
        private SqlDataReader ReadRecords(string query)
        {
            String con = @"Data Source=CHN374\SQLEXPRESS;Initial Catalog=Telerik;Integrated Security=true";
            conn = new SqlConnection(con);
            conn.Open();
            SqlCommand cmd = new SqlCommand(query, conn);
            reader = cmd.ExecuteReader();
            return reader;
        }
 
        protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
 
 
            RadGrid1.DataSource = GetDataTable("select RecId, ResourceName ,MobileNo ,ContactNo ,EMail ,CreatedBy ,PrimarySkill,SecondarySkill from ResourceDocket");
             
        }
 
        public DataTable GetDataTable(string query)
        {
            String constring = @"Data Source=CHN374\SQLEXPRESS;
                        Initial Catalog=MyDB;
                        Integrated Security=True";
            SqlDataAdapter adapter = new SqlDataAdapter();
            DataTable myDataTable = new DataTable();
            using (SqlConnection con = new SqlConnection(constring))
            {
                adapter.SelectCommand = new SqlCommand(query, con);
                adapter.Fill(myDataTable);
            }
            return myDataTable;
        }
        protected void update_button_Click(object sender, EventArgs e)
        {
 
 
 
        }
 
  protected void insert_button_Click(object sender, EventArgs e)
        {
 
 
 
        }
  protected void delete_button_Click(object sender, EventArgs e)
        {
 
 
 
        }
 

    }
}

I need how to perform insert,update,delete on this external button click from values of  textbox1,textbox2 etc.. and pass it onto radgrid



I search it in many places proper solution is not found on website,Pls anyone help on this issue immediately,I posted two days before,still i never get any reply.If its not possible tell me its not possible.I wasted my time with this,
Andrey
Telerik team
 answered on 28 Nov 2012
9 answers
385 views
In IE7/IE8 RadGrid rows collapsing doesn't work in client mode using GroupByExpression.
Rows collapsing produces an "row overlapping" effect: hidden rows appear visible over the previous data.
Could anyone help me?
Tnx in advance
Radoslav
Telerik team
 answered on 28 Nov 2012
13 answers
259 views
How are you
I want to ask about important issue that i need to solve it as soon as possible
My scenario is RadGrid inside RadWindow, When I maximize The RadWindow, i need to maximIze RadGrid to fit the content of RadWindow also, when i return RadWindow to its normal size, i want RadGrid to return to its normal size
Also, PageSize DropDownList not working when Maximizing RadWindow;it works only when The RadWindow is in its normal size
My RadGrid uses UseStaticHeaders property to equal true and had fixed Width and Height
My RadWindow Markup is
<telerik:RadWindow ID="RadDeploymentWindow" Title="<%$ Resources:Text, DeploymentWizard %>" 
    runat="server" VisibleOnPageLoad="false" VisibleStatusbar="false" Width="535px" 
    Modal="true" Height="350px" Behaviors="Close,Move,Maximize,Reload " Skin="Windows7" 
    IconUrl="~/Images/icons/Enterprise.png"> 
    <ContentTemplate>
My RadGrid Markup is
<telerik:RadGrid ID="DeploymentGrid" Skin="Office2007" runat="server" AutoGenerateColumns="False"
                                        AllowSorting="True" PageSize="10" ShowStatusBar="True" CellSpacing="0" GridLines="Both"
                                        AllowPaging="True" OnNeedDataSource="RadGrid_NeedDataSource" Height="225px" Width="516px"
                                        <ClientSettings
                                            <Scrolling AllowScroll="true" UseStaticHeaders="true" /> 
                                        </ClientSettings
                                        <ExportSettings IgnorePaging="true" ExportOnlyData="true" OpenInNewWindow="true"
                                            HideStructureColumns="true" Excel-Format="Html" FileName="ErrorsAndWarnings"
                                        </ExportSettings
                                        <MasterTableView DataKeyNames="ObjectID" AutoGenerateColumns="false" CommandItemDisplay="Top"
                                            CommandItemSettings-ShowAddNewRecordButton="false" CommandItemSettings-ShowRefreshButton="false"
                                            <CommandItemSettings ShowExportToWordButton="true" ShowExportToExcelButton="true" /> 
                                            <ItemStyle Wrap="false" /> 
                                            <Columns
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="ObjectID"
                                                    HeaderText="ID"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="ObjectType"
                                                    HeaderText="Type"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="Name" HeaderText="Name"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="Attribute"
                                                    HeaderText="Attribute"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="Error" HeaderText="Description"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="ProposedSoluation"
                                                    HeaderText="Proposed Solution"
                                                </telerik:GridBoundColumn
                                                <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" DataField="Severity"
                                                    HeaderText="Severity"
                                                </telerik:GridBoundColumn
                                            </Columns
                                        </MasterTableView
                                        <ClientSettings
                                            <Resizing AllowColumnResize="True"></Resizing>                                             
                                        </ClientSettings
                                    </telerik:RadGrid>

Rohan
Top achievements
Rank 1
 answered on 28 Nov 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?