Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >='2017-06-30' and LeaveToDate <= '2017-06-30'
string strLALeaveFromDate = txtFromDate.Text; string strLALeaveToDate = txtToDate.Text; string strLALeaveHalfDayFrom; string strMP = txtmisspunchfrom.Text; string submit_cc = null; string submitTo = null; string CCmailid = string.Empty; ///////////Code To Restrict Duplicate Entry///////////////// if (ddlLeaveType.SelectedItem.Text == "Casual Leave" || ddlLeaveType.SelectedItem.Text == "Earned Leave" || ddlLeaveType.SelectedItem.Text == "Sick Leave" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Wedding Leave" || ddlLeaveType.SelectedItem.Text == "Maternity Leave" || ddlLeaveType.SelectedItem.Text == "Bereavement Leave" || ddlLeaveType.SelectedItem.Text == "Paternity Leave" || ddlLeaveType.SelectedItem.Text == "Floating Leave") { string chkalreadyapplied = "( Select LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >= '" + strLALeaveFromDate + "' and LeaveToDate <= '" + strLALeaveToDate + "' and EmpID = 'SS525' )"; //// MessageBox.Show(strLAEmpid + strLAEmpName + strLAEmpOffMailID + strLALeaveType + strLALeaveFromDate + strLALeaveHalfDayFrom + strLALeaveToDate + strLALeaveHalfDayTo + douLANoOfDays + strLAReason + strLALeaveStatus + strLALeaveAppliedOn + strLeaveAppliedTo); scon = new SqlConnection(conString); scmd = new SqlCommand(chkalreadyapplied, scon); scon.Open(); scmd.ExecuteNonQuery(); scon.Close(); if (txtFromDate.Text != strLALeaveFromDate) { } } else { MessageBox.Show("You Have Already Applied Leave on the Selected Date"); btnApply.Visible = false; }
lblLeaveApplyErrorMsg.Visible = false; string strLAEmpid = lblEmpID.Text; string strLAEmpName = lblEmpName.Text; string strLAEmpOffMailID = Session["offId"].ToString(); string strLALeaveType = ddlLeaveType.SelectedItem.Text; string strLALeaveFromDate = txtFromDate.Text; string strLALeaveHalfDayFrom; string strMP = txtmisspunchfrom.Text; string submit_cc = null; string submitTo = null; string CCmailid = string.Empty; ///////////Code To Restrict Duplicate Entry///////////////// if (ddlLeaveType.SelectedItem.Text == "Casual Leave" || ddlLeaveType.SelectedItem.Text == "Earned Leave" || ddlLeaveType.SelectedItem.Text == "Sick Leave" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Comp Off" || ddlLeaveType.SelectedItem.Text == "Wedding Leave" || ddlLeaveType.SelectedItem.Text == "Maternity Leave" || ddlLeaveType.SelectedItem.Text == "Bereavement Leave" || ddlLeaveType.SelectedItem.Text == "Paternity Leave" || ddlLeaveType.SelectedItem.Text == "Floating Leave") { string chkalreadyapplied = "( Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >= '" + strLALeaveFromDate + "' and LeaveToDate <= '" + strLALeaveFromDate + "' and EmpID = 'SS525' )"; //// MessageBox.Show(strLAEmpid + strLAEmpName + strLAEmpOffMailID + strLALeaveType + strLALeaveFromDate + strLALeaveHalfDayFrom + strLALeaveToDate + strLALeaveHalfDayTo + douLANoOfDays + strLAReason + strLALeaveStatus + strLALeaveAppliedOn + strLeaveAppliedTo); scon = new SqlConnection(conString); scmd = new SqlCommand(chkalreadyapplied, scon); scon.Open(); scmd.ExecuteNonQuery(); scon.Close(); if (ddlLeaveType.SelectedItem.Text == "Permission") { string permissionapply = "Insert into [Emp_Permission] ([Empid],[Empname],[Date of Permission],[Reason],[Fromtime],[Totime],[TimeDuration],[PerAppliedOn],[PerAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + ViewState["Pertimefrom"] + "','" + ViewState["Pertotime"] + "','" + ViewState["tmper"] + "','" + strLALeaveAppliedOn + "', '" + strLeaveAppliedTo + "' )"; SqlConnection percon = new SqlConnection(conString); SqlCommand percmd = new SqlCommand(permissionapply, percon); percon.Open(); percmd.ExecuteNonQuery(); percon.Close(); } if (ddlLeaveType.SelectedItem.Text == "Miss Punch") { string misspunchapply = "Insert into IntranetReleaseNew.dbo.Emp_MissPunch ([Empid],[Empname],[DateofMissPunch],[Reason],[TimeDurInHours],[MisspunchAppliedOn],[MisspunchAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + strMP + "','" + strLALeaveAppliedOn + "', '" + strLeaveAppliedTo + "' )"; SqlConnection misspuncon = new SqlConnection(conString); SqlCommand misspunchcmd = new SqlCommand(misspunchapply, misspuncon); misspuncon.Open(); misspunchcmd.ExecuteNonQuery(); misspuncon.Close(); } if (ddlLeaveType.SelectedItem.Text == "Work from Home") { string WFHapply = "Insert into [WorkFromHome] ([Empid],[Empname],[Date of WFH],[Reason],[Fromtime],[Totime],[TimeDuration],[WFHAppliedOn],[WFHAppliedTo]) values ('" + strLAEmpid + "','" + strLAEmpName + "','" + strLALeaveFromDate + "','" + strLAReason + "','" + ViewState["Pertimefrom"] + "','" + ViewState["Pertotime"] + "','" + ViewState["tmper"] + "','" + strLA
Select DISTINCT LeaveFromDate,LeaveToDate, EmpID ,LeaveType,LeaveStatus from IntranetRelease.dbo.LeaveApplication Where LeaveFromDate >='2017-06-30' and LeaveToDate <= '2017-06-30' and EmpID = 'SS525'
From Date ToDate No.of Days Status Reason 2017-06-28 2017-06-28 1 Accepted abc 2017-06-28 2017-06-28 1 Rejected abc
protected void gridEmpList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[10].Text = "9:5"; float Record = int.Parse(e.Row.Cells[10].Text); // String Record = e.Row.Cells[10].Text; foreach (TableCell cell in e.Row.Cells) { if (Record > 9) { cell.BackColor = Color.Orange; } } } }
float TotDur = int.Parse(e.Row.Cells[7].Text); foreach (TableCell cell in e.Row.Cells) { if (TotDur <= 9.0) { cell.BackColor = Color.Red; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { string lnkdServerName = ""; showErrorMsg.Visible = false; //if (chkOldDB.Checked == true) //{ // lnkdServerName = ConfigurationManager.AppSettings["LnkdSeverOld"]; // conn = connnew; //} //else // lnkdServerName = ConfigurationManager.AppSettings["LnkdSever"]; if (txtStartDate.Text == "") { txtStartDate.Focus(); return; } if (txtEndDate.Text == "") { txtEndDate.Focus(); return; } DateTime sd = Convert.ToDateTime(txtStartDate.Text); DateTime ed = Convert.ToDateTime(txtEndDate.Text); int countDate = Convert.ToInt32((ed - sd).TotalDays); showErrorMsg.Text = ""; if (countDate >= 31) { showErrorMsg.Style.Add("margin-left", "0px"); showErrorMsg.Visible = true; showErrorMsg.Text = "Date Range should not greater than 45 days"; showErrorMsg.ForeColor = Color.Red; return; } if (ed < sd) { Response.Write("<script>alert('From Date should be less than To Date')</script>"); return; } DataTable dtwithDates = new DataTable(); if (ddlStatus.SelectedIndex == 0) { if (ddlDept.SelectedIndex == 0 && ddlEmp.SelectedIndex == 0) { if (txtStartDate.Text != string.Empty && txtEndDate.Text != string.Empty) { if (txtStartDate.Text.Length == 10 && txtStartDate.Text.ToString().Substring(2, 1) == "/" && txtStartDate.Text.ToString().Substring(5, 1) == "/" && txtEndDate.Text.Length == 10 && txtEndDate.Text.ToString().Substring(2, 1) == "/" && txtEndDate.Text.ToString().Substring(5, 1) == "/") { if (ed > sd) { dtwithDates.Clear(); if (conn.State == ConnectionState.Closed) { conn.Open(); } } } } } } else if (ddlStatus.SelectedIndex == 1) { if (ddlDept.SelectedIndex == 0 && ddlEmp.SelectedIndex == 0) { if (txtStartDate.Text != string.Empty && txtEndDate.Text != string.Empty) { if (txtStartDate.Text.Length == 10 && txtStartDate.Text.ToString().Substring(2, 1) == "/" && txtStartDate.Text.ToString().Substring(5, 1) == "/" && txtEndDate.Text.Length == 10 && txtEndDate.Text.ToString().Substring(2, 1) == "/" && txtEndDate.Text.ToString().Substring(5, 1) == "/") { if (ed > sd) { dtwithDates.Clear(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmdwit
$(document).ready(function () { $("[id*=txtFromDate],[id*=txtToDate],[id*=chkHalfFrom]").blur(function () { var obj = {}; obj.date3 = $.trim($("[id*=txtFromDate]").val()); obj.date4 = $.trim($("[id*=txtToDate]").val()); obj.chek1 = chek1 = $('[id*=chkHalfFrom]').is(":checked"); if (obj.date3 != '' && obj.date4 != '' && !obj.chek1) { var temp = $.ajax({ type: "POST", url: 'LMSEmployee.aspx/GetCurrentTime', data: JSON.stringify(obj), contentType: "application/json; charset=utf-8", dataType: "json", }); temp.success(function (response) { if (response.d == "Apply") { $("[id *= btnApply]").attr('disabled', false); } else { $("[id *= btnApply]").attr('disabled', true); $("[id *= txtToDate]").val(''); alert(response.d); } if (obj.chek1) { $("[id *= btnApply]").attr('disabled', false); } }) } return false; }); });
[System.Web.Services.WebMethod] public static string GetDetails(DateTime date3, DateTime date4) { string conString = System.Configuration.ConfigurationManager.ConnectionStrings["TimeSheetConnectionString2"].ConnectionString; SqlConnection scon; SqlCommand scmd; SqlDataAdapter sda; SqlDataReader sdr; DataSet ds; DataTable dtab; DataTable table; if (HttpContext.Current != null) { date3 = System.DateTime.Now; date4 = System.DateTime.Now; // DateTime date1 = System.DateTime.Now.AddDays(-7); ; // DateTime date2 = System.DateTime.Now.AddDays(-7); //DateTime.TryParse(txtFromDate.Text, out date3); //DateTime.TryParse(txtToDate.Text, out date4); } string Id = "SS472"; string Leave = "Select EmpID ,LeaveType,LeaveFromDate,LeaveToDate,LeaveStatus from LeaveApplication Where LeaveFromDate >= '" + date3.AddDays(-7) + "' and LeaveToDate <= '" + date4.AddDays(-7) + "' and EmpID = '" + Id + "' "; scmd = new SqlCommand(Leave); sda = new SqlDataAdapter(scmd); ds = new DataSet(); ds.Clear(); sda.Fill(ds, "LeaveApplication"); table = ds.Tables[0]; string message = string.Empty; for (int i = 0; i < table.Rows.Count; i++) { if ((table.Rows[i]["LeaveStatus"].ToString() == "Accepted") || (table.Rows[i]["LeaveStatus"].ToString() == "Pending")) { message = "Leave Not Allowed"; } else if (table.Rows[i]["LeaveStatus"].ToString() == "Rejected") { message = ""; } } return message; }
[System.Web.Services.WebMethod] public string GetDetails() { DateTime date3 = System.DateTime.Now; DateTime date4 = System.DateTime.Now; // DateTime date1 = System.DateTime.Now.AddDays(-7); ; // DateTime date2 = System.DateTime.Now.AddDays(-7); DateTime.TryParse(txtFromDate.Text, out date3); DateTime.TryParse(txtToDate.Text, out date4); string Id = "SS472"; string Leave = "Select EmpID ,LeaveType,LeaveFromDate,LeaveToDate,LeaveStatus from LeaveApplication Where LeaveFromDate >= '" + date3.AddDays(-7) + "' and LeaveToDate <= '" + date4.AddDays(-7) + "' and EmpID = '" + Id + "' "; scon = new SqlConnection(conString); scmd = new SqlCommand(Leave, scon); scon.Open(); sda = new SqlDataAdapter(scmd); ds = new DataSet(); ds.Clear(); sda.Fill(ds, "LeaveApplication"); table = ds.Tables[0]; String Value=""; for (int i = 0; i < table.Rows.Count; i++) { if ((table.Rows[i]["LeaveStatus"].ToString() == "Accepted") || (table.Rows[i]["LeaveStatus"].ToString() == "Pending") || (table.Rows[i]["LeaveHalfDayFrom"].ToString() == "FN")) { Value = "Leave Not Allowed"; } else if (table.Rows[i]["LeaveStatus"].ToString()=="Rejected") { } } scon.Close(); return Value; }
<input id="btnGetResponses" type="button" value="Show Current Time" /> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $("#btnGetResponses").click(function () { $.ajax({ type: "POST", url: "LMSEmployee.aspx/GetDetails", data: '{}', contentType: "application/json; charset=utf-8", dataType: "json", success: function (response) { if (response.d == true) { alert("Abc"); } }, failure: function (response) { alert(response.d); } }); }); }); </script>
;with t1 as ( SELECT DeptID, COUNT(EmpID) AS TotalHeadCount FROM EmployeeDetails WHERE (datepart(yyyy,DOJ) between 2005 and 2017) and Status =0 group by DeptID ), t2 as ( SELECT DeptID,COUNT(EmpID) AS NewJoinees FROM EmployeeDetails AS EmployeeDetails_7 WHERE (DATEPART(yyyy, DOJ) = 2017) AND (DATEPART(mm, DOJ) = 03) and datepart(mm,DOJ)>= 01 and Status = 0 group by DeptID ), t3 as ( SELECT DeptID,COUNT(EmpID) AS Resigned FROM EmployeeDetails AS EmployeeDetails_7 WHERE (DATEPART(yyyy, deactivate) = 2017) AND (DATEPART(mm, deactivate) = 02) and datepart(mm,deactivate)>= 05 and Status =1 group by DeptID ) Select t1.DeptID, CASE WHEN TotalHeadCount IS NULL THEN '0' ELSE TotalHeadCount END AS TotalHeadCount,CASE WHEN NewJoinees IS NULL THEN '0' ELSE NewJoinees END AS NewJoinees,CASE WHEN Resigned IS NULL THEN '0' ELSE Resigned END AS Resigned, '' as ToBeHired, '' as OpenPositions, '' as Status from t1 full outer join t2 on t1.DeptID = t2.DeptID full outer join t3 on t1.DeptID = t3.DeptID Union Select 'ZTotal' as total, '' as TotalHeadCount, '' as NewJoinees, '' as Resigned, '' as ToBeHired, '' as OpenPositions, '' as Status
WITH CTE AS( SELECT TotalEmployee=case when (datepart(yyyy,DOJ) between 2005 and 2017)and datepart(mm,DOJ) <='12' and status=0 THEN COUNT(EmpID) ELSE 0 END, Resigned=case when (DATEPART(yyyy, deactivate) = 2017) AND (DATEPART(mm, deactivate) <= '04') and Status=1 THEN COUNT(EmpID) ELSE 0 END, NewJoinees=case when (DATEPART(yyyy, DOJ) = 2017) AND (DATEPART(mm, DOJ) = 02) and datepart(mm,DOJ)<='02' and status=0 THEN COUNT(EmpID) ELSE 0 END FROM EmployeeDetails AS EmployeeDetails_7 group by DOJ,deactivate,status ) SELECT 'Z' as DepartmentTotals,SUM(TotalEmployee) As TotalEmployee1,SUM(NewJoinees)AS NewJoinees1, SUM(Resigned) As Resigned1,'' AS Tobehired,'' As Position,'' as Status FROM CTE
SELECT Count(EmpID) As NewJoinees,Count(EmpID) As Resigned,Count(EmpID) As Total From EmployeeDetails WHERE (DATEPART(yyyy, DOJ) = 2017) AND (DATEPART(mm, DOJ) = 02) and datepart(mm,DOJ)<='02' and status=0 AND (DATEPART(yyyy, deactivate) = 2017) AND (DATEPART(mm, deactivate) <= '01') and Status=1 AND (datepart(yyyy,DOJ) between 2005 and 2017)and datepart(mm,DOJ) <='12' and status=0
<tr> <td>Sys Admin </td> <td> <%#Eval("SA") %> </td> <td> <%#Eval("NewJoineesSA") %> </td> <td> <%#Eval("ResignedSysA") %> </td> <td> <asp:TextBox ID="Textbox43" onkeypress="return IsNumeric(event);" runat="server" Width="120" MaxLength="4" ondrop="return false;" onpaste="return false;"></asp:TextBox> </td> <td> <asp:TextBox ID="Textbox44" onkeypress="return IsNumeric(event);" runat="server" Width="120" MaxLength="4" ondrop="return false;" onpaste="return false;"></asp:TextBox> </td> <td> <asp:TextBox ID="Textbox45" onkeypress="return IsNumeric(event);" runat="server" Width="120" MaxLength="4" ondrop="return false;" onpaste="return false;"></asp:TextBox> </td> </tr> <tr> <td>Total Headcount </td> <td> <%#Eval("TotalEmployee")%> </td> <td> <%#Eval("NewJoinees")%> </td> <td> <%#Eval("Resigned")%> </td> <td> <asp:TextBox ID="Textbox46" onkeypress="return IsNumeric(event);" runat="server" Width="120" MaxLength="4" ondrop="return false;" onpaste="return false;"></asp:TextBox> </td> <td> <asp:TextBox ID="Textbox47" onkeypress="return IsNumeric(event);" runat="server" Wi
https://www.codeproject.com/Questions/1184251/How-to-join-aspgrid-with-normal-tablerow
if (!IsPostBack) { for (int month = 1; month <= 12; month++) { ddlMonths.Items.Add(new ListItem(month.ToString().PadLeft(2, '0'), month.ToString().PadLeft(2, '0'))); } int year = (System.DateTime.Now.Year); for (int intCount = year; intCount >= 1980; intCount--) { ddlyear.Items.Add(intCount.ToString()); } } <td>Month </td> <td> <asp:DropDownList ID = "ddlMonths" runat="server"></asp:DropDownList> <%--<asp:TextBox ID="txtmonth" runat="server"></asp:TextBox>--%> </td> <td>Year </td> <td> <%--<asp:TextBox ID="txtyear" runat="server"></asp:TextBox>--%> <asp:DropDownList ID="ddlyear" runat="server"></asp:DropDownList> </td>
http://www.c-sharpcorner.com/uploadfile/srseelam/file-download-with-save-as-dialog-box-from-browser/
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"> </script> <script> function openDialog() { var input = $(document.createElement('input')); input.attr("type", "file"); input.trigger('click'); return false; } </script> <a Id="btnExport" onclick="openDialog()" Text="Export To Excel" >test</a>
protected void ExportToExcel(object sender, EventArgs e) { gvDetails.AllowPaging = false; this.bind(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Name.xls"); Response.ContentType = "application/excel"; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gvDetails.RenderControl(htw); string renderedGridView = sw.ToString(); System.IO.File.WriteAllText(@"D:\New folder\Name.xls", renderedGridView); Response.Write(sw.ToString()); Response.End(); } protected void ExportToPdf(object sender, EventArgs e) { gvDetails.AllowPaging = false; this.bind(); Response.ClearContent(); string fileName = "Name"; string dateFormat = "MMddyyyy"; string timeformat = "HHmmss"; string outPutFileName = string.Format("{0}_{1}_{2}.pdf", fileName, DateTime.Now.ToString(dateFormat), DateTime.Now.ToString(timeformat)); Response.AddHeader("content-disposition", "attachment; filename=" + outPutFileName); Response.ContentType = "application/pdf"; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gvDetails.RenderControl(htw); string renderedGridView = sw.ToString(); System.IO.File.WriteAllText(@"D:\New folder\Name.pdf", renderedGridView); Response.Write(sw.ToString()); Response.End(); } protected void ExportToWord(object sender, EventArgs e) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { gvDetails.AllowPaging = false; this.bind(); gvDetails.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document Doc = new Document(PageSize.A2, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(Doc); PdfWriter.GetInstance(Doc, Response.OutputStream); Doc.Open(); htmlparser.Parse(sr); Doc.Close(); Response.AddHeader("content-disposition", "attachment; filename=Name.doc"); Response.ContentType = "application/word"; HtmlTextWriter htw = new HtmlTextWriter(sw); gvDetails.RenderControl(htw); string renderedGridView = sw.ToString(); System.IO.File.WriteAllText(@"D:\New folder\Name.doc", renderedGridView); Response.Write(sw.ToString()); Response.End(); } } }
protected void ExportToWord(object sender, EventArgs e) { gvDetails.AllowPaging = false; this.bind(); Response.ClearContent(); string fileName = "Name"; string dateFormat = "MMddyyyy"; string timeformat = "HHmmss"; string outPutFileName = string.Format("{0}_{1}_{2}.xls", fileName, DateTime.Now.ToString(dateFormat), DateTime.Now.ToString(timeformat)); Response.AddHeader("content-disposition", "attachment; filename=" + outPutFileName); //Response.AddHeader("content-disposition", "attachment; filename=Name.doc"); Response.ContentType = "application/word"; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gvDetails.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); }
<ItemTemplate> <asp:Label ID="Label4" runat="server" CssClass="classsLabel4" Text='<%#Eval("Departmentid") %>'></asp:Label> <asp:HiddenField ID="hdnResultValue" Value="0" runat="server" /> </ItemTemplate>
<asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" multiple="multiple" runat="server" > </asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label CssClass="classsLabel4" ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:DropDownList ID="DropDownList3" multiple="multiple" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged" > </asp:DropDownList> </FooterTemplate> </asp:TemplateField>
<asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" multiple="multiple" runat="server" > </asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label CssClass="classsLabel4" ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:DropDownList ID="DropDownList3" multiple="multiple" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged" > </asp:DropDownList> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Edit/Delete" HeaderStyle-Width="5%"> <EditItemTemplate> <asp:ImageButton ID="imgbtnUpdate" onkeypress="return (function (a,b,c))" CommandName="Update" runat="server" ImageUrl="~/Images/update.png" ToolTip="Update" Height="20px" Width="20px" /> <asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/cancel.png" ToolTip="Cancel" Height="20px" Width="20px" /> </EditItemTemplate> <ItemTemplate> <asp:ImageButton ID="imgbtnEdit" onkeypress="return (function (a,b,c))" CommandName="Edit" runat="server" ImageUrl="~/Images/Insert.png" ToolTip="Edit" Height="20px" Width="20px" /> <asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/delete.png" ToolTip="Delete" Height="10px" Width="10px" /> </ItemTemplate> <FooterTemplate> <asp:ImageButton ID="imgbtnAdd" onkeypress="return (function (a,b,c))" runat="server" ImageUrl="~/Images/Add.png" CommandName="Add" Width="20px" Height="20px" ToolTip="Add new User" OnClientClick="GetGridFooterRowvalues()" /> </FooterTemplate> </asp:TemplateField> </Columns>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script> <link href="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js"></script> <link href="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/css/bootstrap-multiselect.css" rel="stylesheet" type="text/css" /> <script src="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/js/bootstrap-multiselect.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $('[id*=DropDownList2],[id*=DropDownList3]').multiselect({ includeAllOption: true, onChange: function (a, b, c) { var val = a.parent().val(); var text = ''; if (val) text = val.join(','); $(a).closest('div').find('.Label4').text(text); } }); }); </script> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="gvDetails" style="background-color:lightgreen; border-collapse: collapse; background-color: lightgreen; margin-top: -53px;" DataKeyNames="empid,name" runat="server" AutoGenerateColumns="false" HeaderStyle-BackColor="#61A6F8" ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White" CellPadding="10" CellSpacing="0" AllowPaging="true" PageSize="5" AllowSorting="True" OnRowDataBound="gvDetails_OnRowDataBound" OnRowCancelingEdit="gvDetails_RowCancelingEdit" OnRowDeleting="gvDetails_RowDeleting" OnRowEditing="gvDetails_RowEditing" OnRowUpdating="gvDetails_RowUpdating" OnRowCommand="gvDetails_RowCommand"> <Columns > <asp:TemplateField HeaderText="EmployeeID"> <ItemTemplate> <asp:Label ID="lblempid" runat="server" class="clsempid" Text='<%# Eval("empid")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtempid" MaxLength="5" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="EmployeeName"> <EditItemTemplate> <asp:TextBox ID="txtempname" runat="server" Text='<%#Eval("name") %>' /> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblempname" runat="server" Text='<%#Eval("name") %>' /> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtempname1" runat="server" AutoPostBack="true" onkeypress="hidedialog(this)" /> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" multiple="multiple" runat="server" >
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script> <link href="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js"></script> <link href="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/css/bootstrap-multiselect.css" rel="stylesheet" type="text/css" /> <script src="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/js/bootstrap-multiselect.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $('[id*=DropDownList2],[id*=DropDownList3]').multiselect({ includeAllOption: true, onChange: function (a, b, c) { var val = a.parent().val(); var text = ''; if (val) text = val.join(','); $(a).closest('div').find('.Label4').text(text); } }); }); </script> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="gvDetails" style="background-color:lightgreen; border-collapse: collapse; background-color: lightgreen; margin-top: -53px;" DataKeyNames="empid,name" runat="server" AutoGenerateColumns="false" HeaderStyle-BackColor="#61A6F8" ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White" CellPadding="10" CellSpacing="0" AllowPaging="true" PageSize="5" AllowSorting="True" OnRowDataBound="gvDetails_OnRowDataBound" OnRowCancelingEdit="gvDetails_RowCancelingEdit" OnRowDeleting="gvDetails_RowDeleting" OnRowEditing="gvDetails_RowEditing" OnRowUpdating="gvDetails_RowUpdating" OnRowCommand="gvDetails_RowCommand"> <Columns > <asp:TemplateField HeaderText="EmployeeID"> <ItemTemplate> <asp:Label ID="lblempid" runat="server" class="clsempid" Text='<%# Eval("empid")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtempid" MaxLength="5" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="EmployeeName"> <EditItemTemplate> <asp:TextBox ID="txtempname" runat="server" Text='<%#Eval("name") %>' /> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblempname" runat="server" Text='<%#Eval("name") %>' /> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="txtempname1" runat="server" AutoPostBack="true" onkeypress="hidedialog(this)" /> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" multiple="multiple" runat="se
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script> <link href="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js"></script> <link href="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/css/bootstrap-multiselect.css" rel="stylesheet" type="text/css" /> <script src="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/js/bootstrap-multiselect.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $('[id*=DropDownList2],[id*=DropDownList3]').multiselect({ includeAllOption: true }); }); </script>
<asp:TemplateField HeaderText="Skills"> <edititemtemplate> <asp:DropDownList ID="DropDownList2" multiple="multiple" runat="server" > <itemtemplate> <asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' > <footertemplate> <asp:DropDownList ID="DropDownList3" multiple="multiple" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged" > </pre
script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script> <link href="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js"></script> <link href="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/css/bootstrap-multiselect.css" rel="stylesheet" type="text/css" /> <script src="http://cdn.rawgit.com/davidstutz/bootstrap-multiselect/master/dist/js/bootstrap-multiselect.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $('[id*=DropDownList2]').multiselect({ includeSelectAllOption: true }); }); $(function () { $('[id*=DropDownList3]').multiselect({ includeSelectAllOption: true }); }); </script>
<asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" OnSelectedIndexChanged="dd2_selectedindexchanged" runat="server" > </asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' > </asp:Label> </ItemTemplate> <FooterTemplate> <asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged" > </asp:DropDownList> </FooterTemplate> </asp:TemplateField>
$(function () { $('[id*=DropDownList3]').multiselect({ includeSelectAllOption: true }); });
<asp:TemplateField HeaderText="Skills"> <EditItemTemplate> <asp:DropDownList ID="DropDownList2" runat="server" > </asp:DropDownList> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%#Eval("Departmentid") %>' > </asp:Label> </ItemTemplate> <FooterTemplate> <asp:DropDownList ID="DropDownList3" runat="server" OnSelectedIndexChanged="dd1_selectedindexchanged" > </asp:DropDownList> </FooterTemplate> </asp:TemplateField>