or
string[] args = Request.Form["radGridClickedRowIndex"].Split('_');
int indice = Convert.ToInt32(args[args.Length - 1]);
string UId = Request.Form["radGridClickedTableId"];
GridTableView tableView;
tableView = this.Page.FindControl(UId) as GridTableView;
string userName = ((tableView as GridTableView).Items[indice] as GridDataItem)["UserName"].Text;
string roleName = ((tableView as GridTableView).Items[indice] as GridDataItem)["RoleName"].Text;
Roles.RemoveUserFromRole(userName, roleName);
tableView.Rebind();
<
asp:RadioButton
ID
=
"RadioButtonWork"
runat
=
"server"
Checked
=
"true"
GroupName
=
"Invoice"
AutoPostBack
=
"true"
OnCheckedChanged
=
"RadioButtonsInvoice_OnCheckedChange"
/>
<
asp:RadioButton
ID
=
"RadioButtonInvoice"
runat
=
"server"
Checked
=
"false"
GroupName
=
"Invoice"
AutoPostBack
=
"true"
OnCheckedChanged
=
"RadioButtonsInvoice_OnCheckedChange"
/>
<
asp:RadioButton
ID
=
"RadioButtonHome"
runat
=
"server"
Checked
=
"false"
GroupName
=
"Invoice"
AutoPostBack
=
"true"
OnCheckedChanged
=
"RadioButtonsInvoice_OnCheckedChange"
/>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
EnableAJAX
=
"false"
>...</
telerik:RadAjaxManager
>
<
telerik:RadAjaxManagerProxy
ID
=
"RadAjaxManagerProxy1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadioButtonWork"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderInvoiceAddress"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderHomeAddress"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadioButtonInvoice"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderInvoiceAddress"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderHomeAddress"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadioButtonHome"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderInvoiceAddress"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"PlaceHolderHomeAddress"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManagerProxy
>
Hi All,
I actually have two questions:
How can I extend the width of the column in my RadGridview. Also, I only have one item in my gridview.I want to see the vertical lines, but i don't see any. may be because there is only one item in the whole gridview. Is it possible that I can see vertical line in my gridview. I have gridLines set to both
Thanks.
<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="CRMScheduler.ascx.vb" Inherits="CRM_TestClient.CRMScheduler" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="rad" %>
<
rad:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
rad:AjaxSetting
AjaxControlID
=
"RadAjaxManager1"
>
<
UpdatedControls
>
<
rad:AjaxUpdatedControl
ControlID
=
"RadAjaxManager1"
/>
</
UpdatedControls
>
</
rad:AjaxSetting
>
<
rad:AjaxSetting
AjaxControlID
=
"RadAjaxManager1"
>
<
UpdatedControls
>
<
rad:AjaxUpdatedControl
ControlID
=
"Scheduler"
/>
</
UpdatedControls
>
</
rad:AjaxSetting
>
<
rad:AjaxSetting
AjaxControlID
=
"Scheduler"
>
<
UpdatedControls
>
<
rad:AjaxUpdatedControl
ControlID
=
"Scheduler"
/>
</
UpdatedControls
>
</
rad:AjaxSetting
>
</
AjaxSettings
>
</
rad:RadAjaxManager
>
<
rad:RadScheduler
runat
=
"server"
ID
=
"Scheduler"
Width
=
"753px"
Height
=
"600px"
Skin
=
"Vista"
EnableExactTimeRendering
=
"true"
StartEditingInAdvancedForm
=
"true"
StartInsertingInAdvancedForm
=
"true"
DataKeyField
=
"Schedule_id"
DataStartField
=
"Start"
DataEndField
=
"End"
DataSubjectField
=
"Subject"
DataDescriptionField
=
"Description"
DataRecurrenceField
=
"RecurrenceRule"
DataReminderField
=
"Reminder"
DataRecurrenceParentKeyField
=
"RecurrenceParentSchedule_id"
AppointmentContextMenuSettings-EnableDefault
=
"false"
TimeSlotContextMenuSettings-EnableDefault
=
"false"
TimelineView-UserSelectable
=
"false"
>
<
AdvancedForm
Modal
=
"true"
/>
</
rad:RadScheduler
>
Imports System
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports Telerik.Web.UI
Public Class CRMScheduler
Inherits System.Web.UI.UserControl
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
' 2011-06-03 10:00:00
Scheduler.SelectedDate = Now()
Scheduler.SelectedView = SchedulerViewType.WeekView
Scheduler.DayStartTime = New TimeSpan(7, 0, 0)
Scheduler.DayEndTime = New TimeSpan(20, 0, 0)
Scheduler.WorkDayStartTime = New TimeSpan(8, 0, 0)
Scheduler.WorkDayEndTime = New TimeSpan(18, 0, 0)
Scheduler.FirstDayOfWeek = DayOfWeek.Monday
Scheduler.LastDayOfWeek = DayOfWeek.Saturday
BindSchedule()
End If
End Sub
Private Sub BindSchedule()
Dim ds As List(Of objCRM.Schedule) = objCRM.Schedule.SelectScheduleByDealer(Session("Dealer_id"))
For i As Int32 = 0 To ds.Count - 1
If ds(i).RecurrenceRule = "" Then
ds(i).RecurrenceRule = Nothing
End If
Next
Scheduler.DataSource = ds
Scheduler.DataBind()
End Sub
Private Sub Scheduler_AppointmentDataBound(sender As Object, e As Telerik.Web.UI.SchedulerEventArgs) Handles Scheduler.AppointmentDataBound
Dim RecurrenceRule As String = e.Appointment.RecurrenceRule
If e.Appointment.RecurrenceParentID = -1 Then
e.Appointment.RecurrenceParentID = Nothing
End If
End Sub
Private Sub Scheduler_AppointmentDelete(sender As Object, e As Telerik.Web.UI.AppointmentDeleteEventArgs) Handles Scheduler.AppointmentDelete
objCRM.Schedule.DeleteSchedule(e.Appointment.ID)
BindSchedule()
End Sub
Private Sub Scheduler_AppointmentInsert(sender As Object, e As Telerik.Web.UI.AppointmentInsertEventArgs) Handles Scheduler.AppointmentInsert
Dim User_id As Int32 = -1
Dim Subject As String = e.Appointment.Subject
Dim Description As String = e.Appointment.Description
Dim Start As String = e.Appointment.Start.ToString
Dim [End] As String = e.Appointment.End.ToString
Dim RecurrenceRule As String = e.Appointment.RecurrenceRule.ToString
Dim RecurrenceParentSchedule_id As String = IIf(e.Appointment.RecurrenceParentID Is Nothing, -1, CInt(e.Appointment.RecurrenceParentID))
Dim Reminder As String = e.Appointment.Reminders.ToString
Dim s As objCRM.Schedule = New objCRM.Schedule(Session("Dealer_id"), User_id, Subject, Description, Start, [End], RecurrenceRule, RecurrenceParentSchedule_id, Reminder)
BindSchedule()
End Sub
Private Sub Scheduler_AppointmentUpdate(sender As Object, e As Telerik.Web.UI.AppointmentUpdateEventArgs) Handles Scheduler.AppointmentUpdate
Dim s As objCRM.Schedule = New objCRM.Schedule(e.Appointment.ID)
' Dim User_id As Int32 = -1
s.Subject = e.ModifiedAppointment.Subject
s.Description = e.ModifiedAppointment.Description
s.Start = e.ModifiedAppointment.Start.ToString
s.[End] = e.ModifiedAppointment.End.ToString
s.RecurrenceRule = e.ModifiedAppointment.RecurrenceRule.ToString
s.RecurrenceParentSchedule_id = IIf(e.ModifiedAppointment.RecurrenceParentID Is Nothing, -1, CInt(e.ModifiedAppointment.RecurrenceParentID))
s.Reminder = e.ModifiedAppointment.Reminders.ToString
s.Update()
BindSchedule()
End Sub
Private Sub Scheduler_NavigationCommand(sender As Object, e As Telerik.Web.UI.SchedulerNavigationCommandEventArgs) Handles Scheduler.NavigationCommand
BindSchedule()
End Sub
End Class
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ucCitasMasivas.ascx.cs" Inherits="Schedules.Controls.ucCitasMasivas" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<
style
type
=
"text/css"
>
.style1
{
width: 372px;
}
</
style
>
<
div
style
=
"height: 100%; width:100%"
>
<
table
>
<
tr
>
<
td
class
=
"style1"
>
<
asp:Label
ID
=
"lblTipoCitas"
runat
=
"server"
Text
=
"Tipo de Citas Masivas: "
></
asp:Label
>
<
telerik:RadComboBox
ID
=
"cmbTipoCitas"
Runat
=
"server"
AutoPostback
=
"true"
Font-Bold
=
"true"
onselectedindexchanged
=
"cmbTipoCitas_SelectedIndexChanged"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
</
table
>
<
telerik:RadGrid
ID
=
"grdCitasMasivas"
runat
=
"server"
Skin
=
"Office2007"
PageSize
=
"50"
GridLines
=
"None"
AllowMultiRowEdit
=
"True"
onprerender
=
"grdCitasMasivas_PreRender"
AllowRowSelect
=
"True"
AllowMultiRowSelection
=
"True"
OnColumnCreated
=
"grdCitasMasivas_ColumnCreated"
onitemdatabound
=
"grdCitasMasivas_ItemDataBound"
onGridCreated
=
"grdCitasMasivas_ItemCreated"
>
<
MasterTableView
EditMode
=
"InPlace"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridClientSelectColumn
UniqueName
=
"Selected"
/>
<
telerik:GridDropDownColumn
UniqueName
=
"gddProveedor"
HeaderText
=
"Proveedor"
DropDownControlType
=
"RadComboBox"
/>
<
telerik:GridDropDownColumn
UniqueName
=
"gddSelectFecha"
HeaderText
=
"Fecha"
DropDownControlType
=
"RadComboBox"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
div
>
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Data;
using
System.Data.Common;
using
Telerik.Web.UI;
using
CFSE_Data;
using
Scheduler_Objects;
namespace
Schedules.Controls
{
public
partial
class
ucCitasMasivas : System.Web.UI.UserControl
{
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
grdCitasMasivas.ClientSettings.Selecting.AllowRowSelect =
true
;
DataSets.dsAppGroupType.spGetAppGroupType1DataTable dtAppGroups =
new
Schedules.DataSets.dsAppGroupType.spGetAppGroupType1DataTable();
DataSets.dsAppGroupTypeTableAdapters.spGetAppGroupType1TableAdapter GroupAdapter =
new
Schedules.DataSets.dsAppGroupTypeTableAdapters.spGetAppGroupType1TableAdapter();
GroupAdapter.Fill(dtAppGroups);
foreach
(System.Data.DataRow r
in
dtAppGroups.Rows)
{
cmbTipoCitas.Items.Add(
new
Telerik.Web.UI.RadComboBoxItem(r[1].ToString(), r[0].ToString()));
}
setGridView();
}
}
protected
void
grdCitasMasivas_PreRender(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
foreach
(GridItem i
in
grdCitasMasivas.MasterTableView.Items)
{
GridEditableItem edit = i
as
GridDataItem;
edit.Edit =
true
;
}
}
foreach
(GridDataItem item
in
grdCitasMasivas.Items)
{
item.Selected =
true
;
}
grdCitasMasivas.Rebind();
}
protected
void
cmbTipoCitas_SelectedIndexChanged(
object
sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
setGridView();
}
public
static
DataTable GetAppGroup(
int
GroupCode)
{
DataTable dtable =
null
;
DBManager db =
new
DBManager();
DbParameter p =
null
;
db.CommandName =
"Schedule.spGetAppgroupbyGrpid"
;
p = db.Provider.CreateParameter();
p.ParameterName =
"@P_Group_Code"
;
p.DbType = DbType.Int32;
p.Value = GroupCode;
db.CommandParameters.Add(p);
try
{
dtable = db.ExecuteQuery(
false
);
}
catch
(Exception ex)
{
dtable =
null
;
throw
new
Exception(
"Error en lectura de la base de datos. ["
+ ex.Message +
"]"
);
}
finally
{
db =
null
;
}
return
dtable;
}
public
static
DataTable GetProviders(
string
Taxonomy,
int
City_Id,
int
AppType)
{
DataTable dtable =
null
;
DBManager db =
new
DBManager();
db.CommandName =
"Schedule.uspGetProviderByTaxAndAvlMasiva"
;
DbParameter p = db.Provider.CreateParameter();
p.ParameterName =
"@Taxonomy"
;
p.DbType = DbType.String;
p.Value = Taxonomy;
DbParameter p2 = db.Provider.CreateParameter();
p2.ParameterName =
"@City_Id"
;
p2.DbType = DbType.Int32;
p2.Value = City_Id;
DbParameter p3 = db.Provider.CreateParameter();
p3.ParameterName =
"@AppType"
;
p3.DbType = DbType.Int32;
p3.Value = AppType;
db.CommandParameters.Add(p);
db.CommandParameters.Add(p2);
db.CommandParameters.Add(p3);
try
{
dtable = db.ExecuteQuery(
false
);
}
catch
(Exception ex)
{
dtable =
null
;
throw
new
Exception(
"Error en lectura de la base de datos. ["
+ ex.Message +
"]"
);
}
finally
{
db =
null
;
}
return
dtable;
}
public
static
String GetFechas(
int
Provider,
int
AppType)
{
String fechas = ProviderSites.GetAvailableDays(
"233"
, DateTime.Today.Year.ToString(), DateTime.Today.Month.ToString(),
"2"
);
//TODOL: set provider id
return
fechas;
}
protected
void
setGridView()
{
int
Groupid = Int32.Parse(cmbTipoCitas.SelectedValue.ToString());
grdCitasMasivas.DataSource = GetAppGroup(Groupid);
grdCitasMasivas.Rebind();
}
protected
void
grdCitasMasivas_ColumnCreated(
object
sender, GridColumnCreatedEventArgs e)
{
if
(e.Column.UniqueName ==
"Group_Code"
|| e.Column.UniqueName ==
"Order_Group_ID"
|| e.Column.UniqueName ==
"APP_TYPE_ID"
|| e.Column.UniqueName ==
"REPEAT_NUMBER"
)
{
e.Column.Display =
false
;
}
//columna descripcion es read only
if
(e.Column.UniqueName ==
"APP_TYPE_DESC"
)
{
GridBoundColumn col = (GridBoundColumn)e.Column;
col.ReadOnly =
true
;
}
}
protected
void
grdCitasMasivas_ItemDataBound(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridHeaderItem)
{
GridHeaderItem headerItem = (GridHeaderItem)e.Item;
headerItem.Cells[8].Text =
"Descripción "
;
}
if
(e.Item
is
GridEditableItem && e.Item.IsInEditMode)
{
GridEditableItem editedItem = e.Item
as
GridEditableItem;
GridEditManager editMan = editedItem.EditManager;
GridDropDownColumnEditor editor = editMan.GetColumnEditor(
"gddProveedor"
)
as
GridDropDownColumnEditor;
RadComboBox rcmb = editedItem[
"gddProveedor"
].Controls[0]
as
RadComboBox;
TextBox txtbx = (TextBox)editedItem.Controls[7].Controls[0];
int
AppType = Convert.ToInt32(txtbx.Text.ToString());
DataTable table = GetProviders(
"79"
, 65, AppType);
//TODO: Set tax and city id from viewstate
editor.DataSource = table;
editor.DataTextField =
"Site_Name"
;
editor.DataValueField =
"Site_ID"
;
editor.DataBind();
}
}
protected
void
grdCitasMasivas_ItemCreated(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridEditableItem && e.Item.IsInEditMode)
{
GridDropDownListColumnEditor gddProviders = (e.Item
as
GridEditFormItem).EditManager.GetColumnEditor(
"gddSelectFecha"
)
as
GridDropDownListColumnEditor;
gddProviders.ComboBoxControl.AutoPostBack =
true
;
gddProviders.ComboBoxControl.SelectedIndexChanged +=
new
RadComboBoxSelectedIndexChangedEventHandler(
this
.gddProviders_SelectedIndexChanged);
}
}
private
void
gddProviders_SelectedIndexChanged(
object
sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
GridEditableItem editedItem = (sender
as
RadComboBox).NamingContainer
as
GridEditableItem;
GridDropDownListColumnEditor gddFechas = editedItem.EditManager.GetColumnEditor(
"gddSelectFecha"
)
as
GridDropDownListColumnEditor;
DataTable ddFecha =
new
DataTable();
ddFecha.Columns.Add(
"Fechas"
);
ddFecha.Rows.Add(GetFechas(233,2));
gddFechas.DataSource = ddFecha;
gddFechas.DataBind();
gddFechas.ComboBoxControl.DataBind();
/*
RadComboBox gddFecha = editedItem["gddSelectFecha"].Controls[0] as RadComboBox;
*/
}
}
}
<
telerik:RadAjaxLoadingPanel
id
=
"lpBDC"
Runat
=
"server"
Transparency
=
"18"
CssClass
=
"AjaxLoadingProgress"
></
telerik:RadAjaxLoadingPanel
>
div.AjaxLoadingProgress
{
background
:
#DFE9F5
url
(../images/loading_small.gif)
no-repeat
center
center
;
}
<
telerik:RadAjaxLoadingPanel
id
=
"lpBDC"
Runat
=
"server"
Transparency
=
"18"
BackColor
=
"Red"
></
telerik:RadAjaxLoadingPanel
>