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  

My cs code is :


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,

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

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
My RadGrid Markup is

I'm using Telerik RadEditor. Whenever I click on "Image Manager" it is opening DialogHandler.aspx in popup. How can I set the height of that popup?...Please help..its help.

Hi,

I am using RadGrid in an Ajax updated pop up created using bPopup plugin for jQuery (http://dinbror.dk/bpopup/). I have the RadGrid and other controls in an Ajax UpdatePanel. The grid loads fine and shows the data. However when I click on a page number shown in the pager at the bottom of the grid it causes a full post-back, the page gets reloaded and the popup disappears. When I click the popup image button again I see the page number changed in the grid.

I looked at various threads regarding UpdatePanel and RadGrid and tried the following. None of it has helped.
1. Wrap the RadGrid in RadAjaxPanel.
2. Set grid viewstate = false when inside an update panel.
3. Set the update mode of update panel to conditional for all update panels on the page
4. Set RenderMode of the RadAjaxPanel and UpdatePanel to Inline.

Please help out.

Thanks and Regards,
Sameeksha

I just installed the Telerik free trial ASP.NET AJAX controls for Visual Studio 2010 Web Express.

I added the controls to the toolbar, and I can drop controls on the forms...

Problem is:

1) It always says Telerik.web.ui.[ControlName].... is not defined:
For Example: Type 'Telerik.Web.UI.Skins.RadButton' is not defined.

2) I cannot select the skins either...

Attempts thus far:

1) Added reference to all the .DLL's directly from the project
2) I was going to add a handler to the web.config, but not sure if this is still applicable in newer versions of the controls.

Not sure what I need to do next?

Hi all,
         In the code below Item Command of grid with IdrgAttendenceDetails is not getting fired when a link button present in a template column which is created dynamically in code behind is clicked. Please have a look at the code and specify a answer for it thank you.

using System;

using System.Collections;

using System.Collections.Specialized;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Drawing;

using System.Diagnostics;

using Telerik.Web;

using Telerik.Web.UI;

using System.Data.SqlClient;

using MSI.Emailing;

using MSI.Logging;

using AttendenceManagement.Business_Layer;

 

namespace AttendenceManagement.Controls

{

    public partial class AttendenceDetailsGrid : System.Web.UI.UserControl

    {

        #region Properties Declarations

        /// <summary>

        /// Business Layer Objects Declared to Reterive or Save Data To DataBase.

        /// </summary>

        AttendenceDetailsDAO objAttendenceDetailsDAO = new AttendenceDetailsDAO();

        AttendenceDetailsEntities objAttendenceDetailsEntities = new AttendenceDetailsEntities();

        AttendenceDAO objAttendenceDAO = new AttendenceDAO();

        AttendenceEntities objAttendenceEntities = new AttendenceEntities();

        LoggingClass objLogging = new LoggingClass();

        Emailclass objEmailclass = new Emailclass();

        DataSet dsDetails = new DataSet();

        string strEmployeeId;

        #endregion

 

        #region Events

        protected void Page_Load(object sender, EventArgs e)

        {

            try

            {

                rdpFrom.MaxDate = DateTime.Now.AddDays(-1);

                rbClose.Image.IsBackgroundImage = true;

                rbClose.Image.ImageUrl = "~/CSS/TelerikCustomSkins/Grid/cancelbtn.png";

 

                if (!IsPostBack)

                {

                    rdpFrom.SelectedDate = DateTime.Now.AddMonths(-1);

 

                }

                LoadAttendenceGrid(true);

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Click Event to Select and Load Employee Attendence Details.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rbtnSelect_Click(object sender, EventArgs e)

        {

            try

            {

                LoadAttendenceGrid(true);

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

        /// <summary>

        ///Attendence Grid ItemCommnad Event Fired to Load AttendenceDetailsPopup for a Particular Date of an Employee.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rgAttendenceDetails_ItemCommand(object sender, GridCommandEventArgs e)

        {

            try

            {

                rtbxComments.Text = string.Empty;

                string strMSIID;

                DateTime dtDate;

                if (e.CommandName == "AttendenceCheck")

                {

                    if (e.Item is GridDataItem)

                    {

                        GridDataItem item = (GridDataItem)e.Item;

 

                        strMSIID = item["Emp_ID"].Text;

                        CommonDAO objCommonDao = new CommonDAO();

                        DataSet dsUserDetails = objCommonDao.GetUserDetails(strMSIID);

                        if (dsUserDetails != null)

                        {

                            if (dsUserDetails.Tables.Count > 0)

                            {

                                if (dsUserDetails.Tables[0].Rows.Count > 0)

                                {

                                    lblEmployeeNameValue.Text = (string)dsUserDetails.Tables[0].Rows[0]["Employee_Name"];

                                }

                            }

                        }

                        lblEmployeeIdValue.Text = strMSIID;

                        dtDate = Convert.ToDateTime(e.CommandArgument.ToString());

                        lblDateValue.Text = dtDate.ToString("dd-MM-yyyy");

                        rwdAttendenceDetails.VisibleOnPageLoad = true;

                        objAttendenceDetailsEntities.EmployeeId = "0" + strMSIID; //Concatenating EmployeeId with 0 as defined in Database.

                        objAttendenceDetailsEntities.Date = dtDate;

                        Session["MSIId"] = strMSIID;

                        Session["Date"] = dtDate;

                        rcbxType.SelectedValue = "0";

                        LoadAttendenceGridPopUp();

                        LoadAttendenceGrid(false);

 

                        if (Session["AttendencePage"] != null)

                        {

                            if (Session["AttendencePage"].ToString() == "Attendence")

                            {

                                lblEmployeeNameValue.Enabled = false;

                                lblEmployeeIdValue.Enabled = false;

                                lblDateValue.Enabled = false;

                                rgMyAttendenceDetails.Enabled = false;

                                rtbxComments.Enabled = false;

                                rcbxType.Enabled = false;

                                objAttendenceEntities.MSIId = Session["MSIId"].ToString();

                                objAttendenceEntities.AttDate = Convert.ToDateTime(Session["Date"]);

                                DataSet dsAttType = new DataSet();

                                dsAttType = objAttendenceDAO.GetAttendenceType(objAttendenceEntities);

                                if (dsAttType != null)

                                {

                                    if (dsAttType.Tables.Count > 0)

                                    {

                                        if (dsAttType.Tables[0].Rows.Count > 0)

                                        {

                                            string strTypeName = (string)dsAttType.Tables[0].Rows[0]["Att_Type"];

                                            objAttendenceEntities.TypeName = strTypeName;

                                            DataSet dsTypeId = new DataSet();

                                            dsTypeId = objAttendenceDAO.GetTypeId(objAttendenceEntities);

                                            if (dsTypeId != null)

                                            {

                                                if (dsTypeId.Tables.Count > 0)

                                                {

                                                    if (dsTypeId.Tables[0].Rows.Count > 0)

                                                    {

                                                        rcbxType.SelectedValue = (string)dsTypeId.Tables[0].Rows[0]["TypeId"];

                                                    }

                                                }

                                            }

                                        }

                                    }

                                }

                            }

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Attendence Grid ItemDataBound Event Fired to set the Backcolor of the Control present in a Particular Cell of the Grid.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rgAttendenceDetails_ItemDataBound(object sender, GridItemEventArgs e)

        {

            try

            {

                //Not Header row

                if (e.Item.RowIndex > 0)

                {

                    for (int i = 1; i < e.Item.Cells.Count; i++)

                    {

                        if (e.Item.Cells[i].Controls.Count > 0)

                        {

                            LiteralControl lbl = (LiteralControl)e.Item.Cells[i].Controls[1];

                            LinkButton lnk = (LinkButton)e.Item.Cells[i].Controls[0];

                            if (lbl != null && lnk != null)

                            {

                                AttendenceDetailsDAO.AttendenceType objAttendenceType = AttendenceDetailsDAO.GetValueFromDescription(lbl.Text);

                                if (default(AttendenceDetailsDAO.AttendenceType) != objAttendenceType && objAttendenceType != AttendenceDetailsDAO.AttendenceType.Absent && objAttendenceType != AttendenceDetailsDAO.AttendenceType.HalfDayAbsent)

                                {

                                    lnk.Visible = false;

                                    e.Item.Cells[i].BackColor = AttendenceDetailsDAO.GetBackGroundColor(objAttendenceType);

                                }

                                else

                                {

                                    lbl.Visible = false;

                                    e.Item.Cells[i].BackColor = AttendenceDetailsDAO.GetBackGroundColor(objAttendenceType);

                                }

                            }

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Click Event to Save the Status of the Employee For a Particular Date Selected for an Employee from the Attendence Details to DB.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rbOk_Click(object sender, EventArgs e)

        {

            try

            {

                objAttendenceEntities.MSIId = Session["MSIId"].ToString();

                objAttendenceEntities.AttDate = Convert.ToDateTime(Session["Date"]);

                objAttendenceEntities.CodeValue = rcbxType.Text;

                DataSet dsCodeId = new DataSet();

                dsCodeId = objAttendenceDAO.GetCodeId(objAttendenceEntities);

                if (dsCodeId != null && dsCodeId.Tables.Count > 0 && dsCodeId.Tables[0].Rows.Count > 0)

                {

                    foreach (DataRow row in dsCodeId.Tables[0].Rows)

                    {

                        objAttendenceEntities.AttTypeId = int.Parse(row["Code_ID"].ToString());

                    }

                }

                objAttendenceEntities.Comments = rtbxComments.Text;

                objAttendenceEntities.CreatedUserId = UserDetails.User.EmployeeId;

                objAttendenceDAO.SaveAttendenceDetails(objAttendenceEntities);

 

 

                if (rcbxType.Text == "Work From Home")

                {

                    string strLeadEmail = string.Empty;

                    for (int i = 0; i < UserDetails.Leads.Count; i++)

                    {

                        strLeadEmail += UserDetails.Leads[i].Lead_Email + ",";

                    }

                    if (strLeadEmail != string.Empty)

                    {

                        strLeadEmail = strLeadEmail.Substring(0, strLeadEmail.Length - 1);

                    }

                    objEmailclass.SendMailMessage(strLeadEmail, null, "Test", "Testing");

                }

                else

                {

                    string strAdminEmail = string.Empty;

                    strAdminEmail = UserDetails.Admin.Admin_Email_Id;

                    objEmailclass.SendMailMessage(strAdminEmail, null, "Test", "Testing");

                }

 

                if (rcbxType.Text == "Swipe Error")

                {

                    objAttendenceEntities.LastChangedUserId = UserDetails.User.EmployeeId;

                    objAttendenceDAO.UpdateAttendenceDetails(objAttendenceEntities);

                }

 

                LoadAttendenceGrid(true);

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Click Event By Admin or Leads to Approve the Status of a Particular Date Attendence of a Employee.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rbApprove_Click(object sender, EventArgs e)

        {

            try

            {

                objAttendenceEntities.MSIId = Session["MSIId"].ToString();

                objAttendenceEntities.AttDate = Convert.ToDateTime(Session["Date"]);

                objAttendenceEntities.LastChangedUserId = UserDetails.User.EmployeeId;

                objAttendenceDAO.UpdateAttendenceIsApproved(objAttendenceEntities);

 

                string strUserEmailId;

                CommonDAO objCommonDao = new CommonDAO();

                DataSet dsUserDetails = objCommonDao.GetUserDetails(Session["MSIId"].ToString());

                if (dsUserDetails != null)

                {

                    if (dsUserDetails.Tables.Count > 0)

                    {

                        if (dsUserDetails.Tables[0].Rows.Count > 0)

                        {

                            strUserEmailId = (string)dsUserDetails.Tables[0].Rows[0]["Email_Id"];

                            objEmailclass.SendMailMessage(strUserEmailId, null, "Test", "Approved");

                        }

                    }

                }

 

                LoadAttendenceGrid(true);

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Click Event By Admin or Leads to Reject the Status of a Particular Date Attendence of a Employee.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void rbReject_Click(object sender, EventArgs e)

        {

            try

            {

                objAttendenceEntities.MSIId = Session["MSIId"].ToString();

                objAttendenceEntities.AttDate = Convert.ToDateTime(Session["Date"]);

                objAttendenceEntities.LastChangedUserId = UserDetails.User.EmployeeId;

                objAttendenceDAO.UpdateAttendenceIsApproved(objAttendenceEntities);

 

                string strUserEmailId;

                CommonDAO objCommonDao = new CommonDAO();

                DataSet dsUserDetails = objCommonDao.GetUserDetails(Session["MSIId"].ToString());

                if (dsUserDetails != null)

                {

                    if (dsUserDetails.Tables.Count > 0)

                    {

                        if (dsUserDetails.Tables[0].Rows.Count > 0)

                        {

                            strUserEmailId = (string)dsUserDetails.Tables[0].Rows[0]["Email_Id"];

                            objEmailclass.SendMailMessage(strUserEmailId, null, "Test", "Rejected");

                        }

                    }

                }

 

                LoadAttendenceGrid(true);

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        protected void rgMyAttendenceDetails_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

        {

            try

            {

                rgMyAttendenceDetails.DataSource = new int[] { };

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

 

        #endregion

 

        #region Methods

        /// <summary>

        /// Method to Load the Attendence Details Grid for a Select no of Employees.

        /// </summary>

        /// <param name="forceLoad"></param>

        private void LoadAttendenceGrid(bool forceLoad)

        {

            try

            {

                strEmployeeId = GetSelectedEmployees();

                objAttendenceDetailsEntities = new AttendenceDetailsEntities();

                rgAttendenceDetails.Columns.Clear();

                lblFromdatewithyear.Text = rdpFrom.SelectedDate.Value.Date.ToShortDateString();

                lblTodatewithyear.Text = rdpFrom.SelectedDate.Value.AddMonths(1).AddDays(-1).Date.ToShortDateString();

                if (Session["HomePage"] != null)

                {

                    if (Session["HomePage"].ToString() == "Home")

                    {

                        objAttendenceDetailsEntities.EmployeeId = UserDetails.User.MSIId;

                    }

                }

 

                else if (strEmployeeId != string.Empty)

                {

                    objAttendenceDetailsEntities.EmployeeId = strEmployeeId;

                }

                if (objAttendenceDetailsEntities.EmployeeId != null)

                {

 

                    objAttendenceDetailsEntities.FromDate = Convert.ToDateTime(rdpFrom.SelectedDate);

                    objAttendenceDetailsEntities.ToDate = Convert.ToDateTime(rdpFrom.SelectedDate.Value.AddMonths(1).AddDays(-1));

 

                    string[] strEmplId = objAttendenceDetailsEntities.EmployeeId.Split(',');

 

                    DataTable dtEmplyees = new DataTable();

 

                    //If it needs to be loaded again from database

                    if (forceLoad == true)

                    {

                        Session["AttData"] = objAttendenceDetailsDAO.GetFullAttendenceDetails(objAttendenceDetailsEntities);

                    }

 

                    dtEmplyees = (DataTable)Session["AttData"];

                    if (dtEmplyees != null)

                    {

                        dtEmplyees.DefaultView.Sort = "Att_Date";

                    }

                    rgAttendenceDetails.AutoGenerateColumns = false;

                    rgAttendenceDetails.MasterTableView.AutoGenerateColumns = false;

 

                    DataTable dtAttendence = new DataTable();

                    DataColumn dc = new DataColumn();

                    DataColumn dcCol2 = new DataColumn();

                    GridBoundColumn boundColumn = new GridBoundColumn();

 

                    GridTemplateColumn clNew;

 

                    for (int iLength = 0; iLength < strEmplId.Length; iLength++)

                    {

                        DataRow[] dr = dtEmplyees.Select("Emp_ID='" + strEmplId[iLength] + "'", "Att_Date");

 

                        if (dr.Length > 0)

                        {

 

                            DataRow drRow = dtAttendence.NewRow();

 

                            if (dr.Length + 1 != dtAttendence.Columns.Count)

                            {

                                boundColumn = new GridBoundColumn();

                                boundColumn.HeaderText = "Employee Id";

                                boundColumn.DataField = "Emp_ID";

                                boundColumn.UniqueName = "Emp_ID";

                                dc.ColumnName = "Emp_ID";

                                dtAttendence.Columns.Add(dc);

                                rgAttendenceDetails.MasterTableView.Columns.Add(boundColumn);

                            }

 

                            //To bind EmployeeId without 0 as the first Character.

                            if (strEmplId[iLength].StartsWith("0"))

                            {

                                drRow[dc.ColumnName] = strEmplId[iLength].Substring(1);

                            }

                            else

                            {

                                drRow[dc.ColumnName] = strEmplId[iLength];

                            }

                            for (int i = 0; i < dr.Length; i++)

                            {

                                if (dr.Length + 1 != dtAttendence.Columns.Count)

                                {

                                    dcCol2 = new DataColumn();

                                    dtAttendence.Columns.Add(dcCol2);

                                    dcCol2.ColumnName = dr[i]["Att_Date"].ToString();

                                }

 

                                //AttendenceDetailsDAO.AttendenceType objAttendanceType = (AttendenceDetailsDAO.AttendenceType)Enum.Parse(typeof(AttendenceDetailsDAO.AttendenceType), dr[i]["Status"].ToString());

                                AttendenceDetailsDAO.AttendenceType objAttendanceType = AttendenceDetailsDAO.GetValueFromDescription(dr[i]["Status"].ToString());

 

                                clNew = new GridTemplateColumn();

                                clNew.HeaderText = dr[i]["Day"].ToString();

                                string strcolName = dcCol2.ColumnName;

                                clNew.ItemTemplate = new MyTemplate(strcolName, ListItemType.Item, dr[i]["Att_Date"].ToString());

                                clNew.UniqueName = dcCol2.ColumnName;

                                clNew.DataField = dcCol2.ColumnName;

                                clNew.ItemStyle.ForeColor = Color.Blue;

 

                                if (dr.Length != rgAttendenceDetails.Columns.Count - 1)

                                {

                                    rgAttendenceDetails.MasterTableView.Columns.Add(clNew);

                                }

                                drRow[dr[i]["Att_Date"].ToString()] = AttendenceDetailsDAO.GetEnumDescription(objAttendanceType);

 

                            }

                            dtAttendence.Rows.Add(drRow);

                        }

                    }

                    //If there is no rows then

                    if (dtAttendence.Rows.Count > 0)

                    {

                        rgAttendenceDetails.DataSource = dtAttendence;

                        rgAttendenceDetails.DataBind();

                        rgAttendenceDetails.Visible = true;

                    }

                }

                else

                {

                    rgAttendenceDetails.DataSource = new int[] { };

                    rgAttendenceDetails.DataBind();

                    rgAttendenceDetails.Visible = false;

                }

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Method to Select Employees from the Employee RadCombobox.

        /// </summary>

        /// <returns></returns>

        private string GetSelectedEmployees()

        {

 

            try

            {

                string EmpIds = string.Empty;

 

                foreach (RadComboBoxItem item in rcbxEmployee.CheckedItems)

                {

                    EmpIds += item.Text + ",";

 

                }

                if (EmpIds != string.Empty)

                {

                    EmpIds = EmpIds.Substring(0, EmpIds.Length - 1);

                }

 

                return EmpIds;

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Method To Load Type into RadCombobox from DB Present in the AttendenceDetailsPopup.

        /// </summary>

        private void LoadRadCmboxType()

        {

            try

            {

                dsDetails = objAttendenceDetailsDAO.GetTypes();

                rcbxType.DataSource = dsDetails;

                foreach (DataRow dr in dsDetails.Tables[0].Rows)

                {

                    rcbxType.DataTextField = "TypeName";

                    rcbxType.DataValueField = "TypeId";

                }

                rcbxType.DataBind();

                rcbxType.Items.Insert(0, new RadComboBoxItem(string.Empty));//Adding a Empty Item to the dropdown.

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

 

        /// <summary>

        /// Method To Load The MyAttendenceDetails grid Present in the AttendenceDetailsPopup.

        /// </summary>

        private void LoadAttendenceGridPopUp()

        {

            try

            {

 

                DataSet AttdataSet = new DataSet();

                AttdataSet = objAttendenceDetailsDAO.GetAttPunchedInandOutDtls(objAttendenceDetailsEntities);

                DataTable dtAttendence = new DataTable();

                DataRow drAttendence = null;

 

                dtAttendence.Columns.Add("PunchIn", typeof(string));

                dtAttendence.Columns.Add("PunchOut", typeof(string));

                dtAttendence.Columns.Add("PunchIn2", typeof(string));

                dtAttendence.Columns.Add("PunchOut2", typeof(string));

                dtAttendence.Columns.Add("PunchIn3", typeof(string));

                dtAttendence.Columns.Add("PunchOut3", typeof(string));

                dtAttendence.Columns.Add("PunchIn4", typeof(string));

                dtAttendence.Columns.Add("PunchOut4", typeof(string));

 

                drAttendence = dtAttendence.NewRow();

                if (AttdataSet != null && AttdataSet.Tables.Count > 0 && AttdataSet.Tables[0].Rows.Count > 0)

                {

 

                    if (AttdataSet.Tables[0].Rows.Count > 0)

                    {

                        drAttendence["PunchIn"] = AttdataSet.Tables[0].Rows[0]["Punch_In"].ToString().Remove(5);

                        drAttendence["PunchOut"] = AttdataSet.Tables[0].Rows[0]["Punch_Out"].ToString().Remove(5);

                    }

                    else if (AttdataSet.Tables[0].Rows.Count > 1)

                    {

                        drAttendence["PunchIn2"] = AttdataSet.Tables[0].Rows[1]["Punch_In"].ToString().Remove(5);

                        drAttendence["PunchOut2"] = AttdataSet.Tables[0].Rows[1]["Punch_Out"].ToString().Remove(5);

                    }

                    else if (AttdataSet.Tables[0].Rows.Count > 2)

                    {

                        drAttendence["PunchIn3"] = AttdataSet.Tables[0].Rows[2]["Punch_In"].ToString().Remove(5);

                        drAttendence["PunchOut3"] = AttdataSet.Tables[0].Rows[2]["Punch_Out"].ToString().Remove(5);

                    }

                    else if (AttdataSet.Tables[0].Rows.Count > 3)

                    {

                        drAttendence["PunchIn4"] = AttdataSet.Tables[0].Rows[3]["Punch_In"].ToString().Remove(5);

                        drAttendence["PunchOut4"] = AttdataSet.Tables[0].Rows[3]["Punch_Out"].ToString().Remove(5);

                    }

                    dtAttendence.Rows.Add(drAttendence);

                }

                if (dtAttendence.Rows.Count > 0)

                {

                    rgMyAttendenceDetails.DataSource = dtAttendence;

                    rgMyAttendenceDetails.DataBind();

                }

                else

                {

                    rgMyAttendenceDetails.DataSource = new int[] { };

                    rgMyAttendenceDetails.DataBind();

                }

                LoadRadCmboxType();

            }

            catch (Exception ex)

            {

                objLogging.WriteToErrorLog(ex.Message);

                throw ex;

            }

        }

        #endregion

 

        #region Template Declarations

        /// <summary>

        /// RadGrid Template Class

        /// </summary>

        private class MyTemplate : ITemplate, IBindableTemplate

        {

            protected LinkButton lnkButton;

            protected LiteralControl lControl;

            private string colname;

            private ListItemType lstItemType;

            private string controlId;

            private string literalId;

            private string lnkbuttonId;

            private string commandArgument;

            public MyTemplate(string CName, ListItemType type, string commandArgument)

            {

                this.colname = CName;

                this.lstItemType = type;

                literalId = "lbl_" + type.ToString() + "_" + CName;

                lnkbuttonId = "lnk_" + type.ToString() + "_" + CName;

                this.commandArgument = commandArgument;

            }

 

            public void InstantiateIn(System.Web.UI.Control container)

            {

                switch (lstItemType)

                {

                    case ListItemType.Item:

 

                        lnkButton = new LinkButton();

                        controlId = "lnk_" + colname;

                        lnkButton.ID = controlId;

                        lnkButton.CommandName = "AttendenceCheck";

                        lnkButton.CommandArgument = commandArgument;

                        lnkButton.DataBinding += new EventHandler(lnkButton_DataBinding);

                        // lnkButton.Click += new EventHandler(lnkButton_Click);

                        container.Controls.Add(lnkButton);

 

                        lControl = new LiteralControl();

                        controlId = "lbl_" + colname;

                        lControl.ID = controlId;

                        lControl.DataBinding += new EventHandler(lControl_DataBinding);

                        container.Controls.Add(lControl);

 

                        break;

                }

            }

 

            public void lnkButton_DataBinding(object sender, EventArgs e)

            {

                LinkButton lnk = (LinkButton)sender;

                GridDataItem container = (GridDataItem)lnk.NamingContainer;

                lnk.Text = ((DataRowView)container.DataItem)[colname].ToString();

            }

 

            public void lControl_DataBinding(object sender, EventArgs e)

            {

                LiteralControl ltlControl = (LiteralControl)sender;

                GridDataItem container = (GridDataItem)ltlControl.NamingContainer;

                ltlControl.Text = ((DataRowView)container.DataItem)[colname].ToString();

            }

 

            public System.Collections.Specialized.IOrderedDictionary ExtractValues(System.Web.UI.Control container)

            {

                OrderedDictionary od = new OrderedDictionary();

 

                od.Add("ProviderName", ((LinkButton)((GridDataItem)container).FindControl(controlId)).Text);

 

                return od;

            }

        }

        #endregion

    }

}