Comments by Member 10928697

Member 10928697 18-Mar-16 8:38am View

In the abave loop im used in windows form .now im use this loop in webapplication so how to convert (Details_Grid[0, i].Value.ToString() == "True")

Member 10928697 6-Oct-15 2:15am View

ok sir.

Member 10928697 7-Jul-15 7:08am View

This browser does not support HTML5 FileReader this error occured sir.

Member 10928697 29-Apr-15 1:36am View

i have to use css3 but its working in chrome but is happend in IE sir.

Member 10928697 29-Apr-15 1:11am View

Header style and footer and Textboxes was changed sir.

Member 10928697 29-Apr-15 1:09am View

ok i have to change css sir and i have execute in google chrome its working but total design changed in IE sir.

Member 10928697 13-Apr-15 9:35am View

Thanku

Member 10928697 10-Mar-15 7:41am View

ya thanku its working.

Member 10928697 10-Mar-15 7:23am View

ok

Member 10928697 10-Mar-15 7:15am View

0x800a01b6 - Javascript runtime error:Object doesn't support property or method 'datepicker'

Member 10928697 10-Mar-15 7:06am View

in my project requirement i have to use updatepanel sir..date pickker was not appear in textbox sirsir.

Member 10928697 10-Mar-15 6:35am View

can i modified sir but its not executed

Member 10928697 10-Mar-15 6:35am View

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

<style type="text/css">
.auto-style9 {
width: 81px;
}
.auto-style10 {
width: 51px;
}
</style>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js" type="text/javascript"></script>

<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"

type="text/javascript"></script>

<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css"

rel="Stylesheet"type="text/css"/>

<script type="text/javascript">

$(function () {

$("#<%= txtStartDate.ClientID %>").datepicker({

numberOfMonths: 2,

onSelect: function (selected) {

var dt = new Date(selected);

dt.setDate(dt.getDate() + 1);

$("#<%= txtLastDate.ClientID %>").datepicker("option", "minDate", dt);

}

});

$("#<%= txtLastDate.ClientID %>").datepicker({

numberOfMonths: 2,

onSelect: function (selected) {

var dt = new Date(selected);

dt.setDate(dt.getDate() - 1);

$("#<%= txtStartDate.ClientID %>").datepicker("option", "maxDate", dt);

}

});

});

</script>
<asp:UpdatePanel ID="UpdatePanel" runat="server">
<contenttemplate>
<td>
<asp:Label ID="lblStartDate" runat="server" Text="Start Date:">
</td>
<td>
<asp:TextBox ID="txtStartDate" runat="server" >
</td>

<td>
<asp:Label ID="lblEndDate" runat="server" Text="End Date:">
</td>
<td>
<asp:TextBox ID="txtLastDate" runat="server" Width="80px">

</td>

Member 10928697 6-Feb-15 2:44am View

Thank u soo much.

Member 10928697 5-Jan-15 4:21am View

Question

Member 10928697 18-Dec-14 6:58am View

Thank u soomuch sir its working.

Member 10928697 18-Dec-14 5:53am View

i'll try sir..but its not working...i have some doubt sir...After enter the text or before enter the text ,holding ctrl key and press right arrow key sir

Member 10928697 18-Dec-14 5:37am View

its work on "GoogleCrome' sir not work in 'IE"

Member 10928697 18-Dec-14 5:35am View

im using infragestic

Member 10928697 18-Dec-14 5:35am View

<head runat="server">
<title></title>
<link href="~/Content/base.css" rel="stylesheet" type="text/css" />
<link href="~/Content/default_jquery_ui.css" rel="stylesheet" type="text/css" />
<link href="~/Content/Grid.css" rel="stylesheet" type="text/css" />
<link href="~/Content/Mozilla.css" rel="stylesheet" media="screen, projection" type="text/css" />

<link href="~/Content/layout.css" rel="stylesheet" type="text/css" />
<link href="~/Content/MenuStyle.css" rel="stylesheet" type="text/css" />
<link href="~/Content/treeview.css" rel="stylesheet" type="text/css" />
<link href='~/Content/MessageBox.css' rel="stylesheet" type="text/css" />

<%-- <script src="Scripts/jquery-1.7.2.min.js" type="text/javascript"></script>
<script src="Scripts/jquery-ui.js" type="text/javascript"></script>--%>
<script src="Scripts/ConstantFooter/jquery.constantfooter.js" type="text/javascript"></script>
<script src="Scripts/Common.js" type="text/javascript"></script>
<script src="Scripts/jquery.caret.1.02.min.js" type="text/javascript"></script>
<script src="../Scripts/Common.js" type="text/javascript"></script>

<link href="styles/style.css" rel="stylesheet" type="text/css" />
<link href="styles/new_css.css" rel="stylesheet" type="text/css" />
<link href="ClientScripts/TMcss.css" rel="stylesheet" type="text/css" />
<link href="styles/Assetmgt.css" rel="stylesheet" type="text/css" />
<link href="styles/left.css" rel="stylesheet" type="text/css" />
<link href="styles/GridViewStyle.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" lang="javascript" src="ClientScripts/CL.js"></script>
<script type="text/javascript" lang="javascript" src="ClientScripts/AM.js"></script>
<script type="text/javascript" lang="javascript" src="ClientScripts/ALactb.js"></script>
<script type="text/javascript" lang="javascript" src="ClientScripts/TMjs.js"></script>

<script src="JqueryUI/jquery-1.4.1.min.js"></script>
<script src="JqueryUI/jquery.autocomplete.js" type="text/javascript"></script>
<link href="styles/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<link href="~/Content/MainLayout.css" rel="stylesheet" />
<script type="text/javascript">
function getPaging(id,level) {
if (level == 2) {
var ast = "", proj = "", dpr = "", dprD = "";
try { ast = document.getElementById("<%=txtAsset.ClientID %>").value; } catch (e) { }
try { proj = document.getElementById("<%= txtproject.ClientID %>").value; } catch (e) { }
try { dpr = document.getElementById("<%=txtDprNo.ClientID %>").value; } catch (e) { }
try {
dprD = document.getElementById("<%=txtDprDate.ClientID %>").value;
} catch (e) { }
document.getElementById("<%=hdnF.ClientID %>").value = "0";
if (ast == "") {
alert('Please Select Asset...!');
}
else if (proj == "") {
alert('Please Select Project...!');
}
else if (dpr == "") {
alert('Please Select DPR Number...!');
}
else if (dprD == "") {
alert('Please Select DPR Date...!');
}
else {
document.getElementById("<%=hdnF.ClientID %>").value = "1";
parent.mainFrame.location = "RedirectToModule.aspx?modid=" + id + "&ast=" + ast + "&proj=" + proj + "&dpr=" + dpr + "&dprD=" + dprD;
}
}
else if (level == 1){
parent.mainFrame.location = "RedirectToModule.aspx?modid=" + id;

Member 10928697 18-Dec-14 5:30am View

I want in my grid identity column first row first cell id's was autogenarate sir.
but in my form Can i enter the values click the save button after that display the identity sir..please check my above code sir.

Member 10928697 18-Dec-14 5:24am View

reverse order mean...when i enter Computer its taken retupmoc sir.

Member 10928697 24-Nov-14 22:56pm View

Member 10928697 24-Nov-14 1:14am View

can i write the program on Infragistics control sir in HTML5...
im using this link sir http://www.infragistics.com/samples/aspnet/data-grid/filtering-excel-style......i have to write program ,its working sir but check box was not checked its my problem sir its understood sir.

Member 10928697 24-Nov-14 1:07am View

http://www.infragistics.com/samples/aspnet/data-grid/filtering-excel-style
----------------------------------------------------------------------------
i have to use this link sir...my problem is check box was not checked in my code

Member 10928697 24-Nov-14 0:43am View

http://www.infragistics.com/samples/aspnet/data-grid/filtering-excel-style
----------------------------------------------------------------------------
i have to use this link sir...my problem is check box was not checked

Member 10928697 21-Nov-14 1:05am View

Thanku soo much..

Member 10928697 13-Nov-14 8:08am View

ok

Member 10928697 5-Nov-14 4:46am View

ok sir i'll follow.

Member 10928697 5-Nov-14 4:37am View

thank u sir its working.

Member 10928697 5-Nov-14 4:24am View

ok i'll try sir

Member 10928697 5-Nov-14 4:04am View

i have error in toolkitscriptmanager...which place am using toolkitscriptmanager sir....below update panel .

Member 10928697 5-Nov-14 3:43am View

Ajax Tabcontainer sir.

Member 10928697 5-Nov-14 3:36am View

avoid the loading purpose sir.

Member 10928697 5-Nov-14 3:32am View

ok

Member 10928697 5-Nov-14 2:32am View

sorry ...updatepanel also not workink in chrome sir.

Member 10928697 5-Nov-14 2:22am View

with out updatepanel its working sir...but i want updatepanel also.

Member 10928697 5-Nov-14 2:20am View

ok i'll tyr

Member 10928697 5-Nov-14 2:13am View

i did't have error message sir...can't display with in the tabcontainer design and tabcontainer also
------------------------------------------------------------------------------------
its work on moxilla and IE sir

Member 10928697 5-Nov-14 1:48am View

ok

Member 10928697 5-Nov-14 1:30am View

yes sir.

Member 10928697 25-Sep-14 0:51am View

ho sorry i con't see.

Member 10928697 25-Sep-14 0:43am View

its working

Member 10928697 25-Sep-14 0:42am View

thanku sir its working....

Member 10928697 25-Sep-14 0:37am View

keypress mean ..im using gridview a bove search box sir...in the search box iam enter the1st letter like customer id or city or name , display the full customername and city and customer name sir that is keypress event...can i send source code sir.

Member 10928697 22-Sep-14 4:42am View

ok..i'll send my code .

Member 10928697 22-Sep-14 0:57am View

once observe below code sir..defnetly u can understand...
https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=Custom%20filtering%20-%20range%20search

Member 10928697 22-Sep-14 0:54am View

im using in the below link sir...i want gridview above one search box...in the search box search only gridview rows...in the below code only working to table sir.
http://www.ajaxshake.com/demo/EN/982/323715d4/easy-jquery-table-jquery-datatables.html

Member 10928697 22-Sep-14 0:27am View

How to Implement the Data Table Jquery Plug In for the Grid View

Member 10928697 20-Sep-14 1:44am View

i want answer sir..question is same bt below link was different sir is it right.

Member 10928697 20-Sep-14 1:31am View

i want gridview above searchbox sir....in the above code using only data tables....

Member 10928697 13-Sep-14 7:45am View

<asp:TextBox ID="txtCourseFee" runat="server" Width="172px"
onkeypress="CheckNumeric(event);" ValidationGroup="vchk">
------------------------------
im add sir bt its not work.

Member 10928697 13-Sep-14 6:33am View

yes sir

Member 10928697 13-Sep-14 2:12am View

onkeypress="CheckNumeric(event);

Member 10928697 9-Sep-14 6:06am View

thank u this link helpfull my project.thanku soomuch

Member 10928697 9-Sep-14 5:05am View

thanku its work

Member 10928697 9-Sep-14 4:50am View

How can I add a picture in address bar of the browser when my page is browsed?

Member 10928697 9-Sep-14 4:50am View

sorry sir.

Member 10928697 9-Sep-14 4:43am View

im doing some web project sir...can i execute one form ...after my menu bar is ....http://localhost:55090/CompanyInfo.aspx?ModuleName=Master.....i want in the menu bar....varshinfotech http://localhost:55090/CompanyInfo.aspx?ModuleName=Master.

Member 10928697 9-Sep-14 4:28am View

How to add my company name in address bar-------after form execution in asp.net

Member 10928697 9-Sep-14 4:22am View

im doing some web project...can i execute one form ...my menu bar is ....http://localhost:55090/CompanyInfo.aspx?ModuleName=Master.....i want....varshinfotech http://localhost:55090/CompanyInfo.aspx?ModuleName=Master.

Member 10928697 8-Sep-14 6:46am View

now have to send mu source code sir.k

Member 10928697 8-Sep-14 6:44am View

i have to send link sir.

Member 10928697 8-Sep-14 2:55am View

ok

Member 10928697 8-Sep-14 1:17am View

im send fully code sir...not reach complete code to u.

Member 10928697 8-Sep-14 0:55am View

<div>
<asp:GridView ID="gvLeaveTypes" runat="server" AllowPaging="true"
AllowSorting="true" AutoGenerateColumns="False" ForeColor="#333333" Width="100%"
Height="50%" onrowediting="gvLeaveTypes_RowEditing"
PageSize="10" CellPadding="4" CellSpacing="3" GridLines="None" onrowdeleting="gvLeaveTypes_RowDeleting"
onpageindexchanging="gvLeaveTypes_PageIndexChanging" OnDataBound="gvLeaveTypes_DataBound" >
<columns>
<asp:TemplateField HeaderText="LeaveCode" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>
<asp:Label ID="lblLeaveCode" runat="server" Text='<%#Eval("lv_type_code") %>'>
<asp:Label ID="lbllv_type_id" runat="server" Text='<%#Eval("lv_type_id") %>' Visible="false">

<asp:TemplateField HeaderText ="Leave Type" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>

<asp:Label ID="lblLeaveType" runat="server" Text='<%#Eval("lv_type_name") %>'>

<asp:TemplateField HeaderText="Days" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>
<asp:Label ID="lblDays" runat="server" Text='<%#Eval("lv_type_days") %>'>

<asp:TemplateField HeaderText="Edit" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.png"
ToolTip="Edit" Height="25px" Width="25px" CommandArgument='<%#Eval("lv_type_id") %>' />

<itemstyle horizontalalign="Center">

<asp:TemplateField HeaderText="Delete" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Delete" runat="server"
ImageUrl="~/Images/Delete.png" ToolTip="Delete" Height="25px" Width="25px" CommandArgument='<%#Eval("lv_type_id") %>' OnClientClick="return ConfirmOnDelete('');"/>

<itemstyle horizontalalign="Center">

<footerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="Aqua" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<editrowstyle backcolor="#ff99ff">
<alternatingrowstyle backcolor="White">

</div>

Member 10928697 8-Sep-14 0:54am View

ok sir..

Member 10928697 8-Sep-14 0:44am View

protected void gvLeaveTypes_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
int index = e.NewEditIndex;

Label lblLeaveCode = (Label)gvLeaveTypes.Rows[index].FindControl("lblLeaveCode");
Label lbllv_type_id = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
Label lblLeaveType = (Label)gvLeaveTypes.Rows[index].FindControl("lblLeaveType");
Label lblDays = (Label)gvLeaveTypes.Rows[index].FindControl("lblDays");

mdpLeaveTypes.Show();
txtCode.Text = lblLeaveCode.Text;
txtLeaveType.Text = lblLeaveType.Text;
txtNoOfDays.Text = lblDays.Text;

btnSave.Text = "Update";
Session["lv_type_id"] = lbllv_type_id.Text;

}
catch (Exception ex) { }
}
-----------------------------------------------------------------------------------------------------------------
protected void gvLeaveTypes_RowDeleting(object sender, GridViewDeleteEventArgs e)
{

int index = e.RowIndex;
Label lbllv_type_id = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
Label lblLeaveCode = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
BBEL.lv_type_id = Convert.ToInt32(lbllv_type_id.Text);
BBEL.comp_id = Convert.ToInt16(Session["comp_id"]);

if (BBLL.DeleteLeaveTypes(BBEL) == true)
{

ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "LeaveTypes", "alert('LeaveTypes details deleted successfully');", true);
}
GridFill();

}
--------------------------------------------------------------------------------------------------------------------
protected void gvLeaveTypes_DataBound(object sender, EventArgs e)
{
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
for (int i = 0; i < gvLeaveTypes.Columns.Count - 2; i++)
{
TableHeaderCell cell = new TableHeaderCell();
TextBox txtSearch = new TextBox();
txtSearch.Attributes["placeholder"] = gvLeaveTypes.Columns[i].HeaderText;
txtSearch.CssClass = "search_textbox";
cell.Controls.Add(txtSearch);
row.Controls.Add(cell);
}
gvLeaveTypes.HeaderRow.Parent.Controls.AddAt(1, row);

Member 10928697 8-Sep-14 0:41am View

<%@ Page Language="C#" MasterPageFile="~/Main.Master" AutoEventWireup="true" CodeBehind="LeaveTypes.aspx.cs" Inherits="vpayroll.LeaveTypes" Title="Untitled Page" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
function close_window(url){
var newWindow = window.open('', '_self', ''); //open the current window
window.close(url);
}
}
});
});
});
</script>

<script type="text/javascript">
function CheckNumeric(e) {

if (window.event) // IE
{
if ((e.keyCode < 48 || e.keyCode > 57) & e.keyCode != 8 ) {
event.returnValue = false;
alert('Please Enter Numbers');
return false;

}
}
else { // Fire Fox
if ((e.which < 48 || e.which > 57) & e.which != 8) {
e.preventDefault();
alert('Please Enter Numbers');
return false;

}
}
}
</script>

<div class="div">
Leave Types
<span style="color: #FFFFFF; font-style: normal; font-weight: normal">Search:</span>
<asp:DropDownList ID="Srch_Type" runat="server" Width="9%" />
<asp:TextBox ID="Srch_Text" runat="server" Width="7%">
<asp:ImageButton ID="Srch_Btn" runat="server" ImageAlign="Baseline" ImageUrl="Images/Search_Icon_16x16.png" />

<div style="vertical-align: middle; float: right; text-align: right;">
<asp:ImageButton ID="btnNew" runat="server" ImageUrl="~/Images/Add.png" Width="7%"
Height="16px" onclick="btnNew_Click" />

<asp:LinkButton ID="lkbSave" runat="server" Font-Bold="True" Text="New Leave Type"
Font-Underline="False" ForeColor="White" CssClass="LinkButton" onclick="lkbSave_Click">

</div>
</div>

<div>
<asp:GridView ID="gvLeaveTypes" runat="server" AllowPaging="true"
AllowSorting="true" AutoGenerateColumns="False" ForeColor="#333333" Width="100%"
Height="50%" onrowediting="gvLeaveTypes_RowEditing"
PageSize="10" CellPadding="4" CellSpacing="3" GridLines="None" onrowdeleting="gvLeaveTypes_RowDeleting"
onpageindexchanging="gvLeaveTypes_PageIndexChanging" OnDataBound="gvLeaveTypes_DataBound" >
<columns>
<asp:TemplateField HeaderText="LeaveCode" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>
<asp:Label ID="lblLeaveCode" runat="server" Text='<%#Eval("lv_type_code") %>'>
<asp:Label ID="lbllv_type_id" runat="server" Text='<%#Eval("lv_type_id") %>' Visible="false">

<asp:TemplateField HeaderText ="Leave Type" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>

<asp:Label ID="lblLeaveType" runat="server" Text='<%#Eval("lv_type_name") %>'>

<asp:TemplateField HeaderText="Days" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<itemtemplate>
<asp:Label ID="lblDays" runat="server" Text='<%#Eval("lv_type_days") %>'>

Member 10928697 8-Sep-14 0:39am View

using in the below link..
https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=How%20to%20search%20gridview%20records%5Cdata%20with%20textbox%20using%20javascript%20in%20asp.net

Member 10928697 8-Sep-14 0:38am View

ok

Member 10928697 4-Sep-14 6:18am View

<td style="padding:10px">
<asp:ImageButton ID="Imgemp" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Emp.png" OnClick="Imgemp_Click" /><br />Employee
</td>
<td style="padding:10px">
<asp:ImageButton ID="Imgdept" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Departments.png" OnClick="Imgdept_Click" /><br />Department
</td><td></td>
<td class="auto-style3" style="padding:10px">
<asp:ImageButton ID="Imgpgrade" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/PayGrade.png" Height="36px" OnClick="Imgpgrade_Click" Width="54px" /><br />Paygrade
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgTimeSheet" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/TimeSheet.png" OnClick="ImgTimeSheet_Click" /><br />Timesheet
</td>
<td style="padding:10px">
<asp:ImageButton ID="Img1stHSal" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/1st_HalfSalary.png" OnClick="Img1stHSal_Click" /><br />1stHalfSalary
</td>
<td style="padding:10px">
<asp:ImageButton ID="Img2ndHSal" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/2nd_HalfSalary.png" OnClick="Img2ndHSal_Click" /><br />2ndHalfSalary
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgBonus" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Bonus.png" OnClick="ImgBonus_Click" /><br />Bonus
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgCpf" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Cpf Funds.png" OnClick="ImgCpf_Click" /><br />CPFSub
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgLeaveBank" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/LeaveBank.png" OnClick="ImgLeaveBank_Click" /><br />LeaveBank
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgLeaveSum" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/LeaveSummary.png" Height="32px" Width="37px" OnClick="ImgLeaveSum_Click" /><br />LeaveSummary
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgLeaveReq" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Leave Request.png" OnClick="ImgLeaveReq_Click" /><br />LeaveRequest
</td>
<td style="padding:10px">
<asp:ImageButton ID="ImgExit" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Exit.png" AlternateText="Exit" OnClientClick="window.close()" />
</td>
</tr>
</table>
</td>
</tr>

Member 10928697 4-Sep-14 6:09am View

yes sir..add in body part

Member 10928697 4-Sep-14 6:04am View

its not working sir..can i click the exit image button just blink the form sir.its not work....plz check javascript code.

Member 10928697 4-Sep-14 5:58am View

can i delete sir.

Member 10928697 4-Sep-14 5:56am View

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Main.master.cs" Inherits="vpayroll.Main" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Src="Controls/ImageMenu.ascx" TagName="ImageMenu" TagPrefix="uc1" %>
<%@ Register Src="Controls/MenuWithImages.ascx" TagName="MenuWithImages" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link href="Styles/Accordian.css" rel="stylesheet" type="text/css" />
<link href="Styles/styles.css" rel="stylesheet" type="text/css" />
<link href="javascript:window.close()">Close Window />

<%--<script language="javascript" type="text/javascript">
//function to disable browser back button
function DisableBackButton() {
window.history.forward();
}
setTimeout("DisableBackButton()", 0);
window.onunload = function () { null };
function CloseWindow() {
window.close();
}
</script>--%>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
$(window).unload(function () {

alert("Bye now!");

});
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ADVANCE-Facilities Pte Ltd.</title>
<asp:ContentPlaceHolder ID="head" runat="server">

<style type="text/css">
.auto-style1 {
width: 63px;
}
.auto-style2 {
width: 49px;
}
.auto-style3 {
width: 54px;
}
.auto-style5 {
width: 73px;
}
.auto-style6 {
width: 74px;
}
.auto-style7 {
width: 53px;
}
.auto-style8 {
width: 62px;
}
.auto-style9 {
width: 96px;
}
</style>
</head>
<body>
<form id="form1" runat="server" style="background-color: White;" >
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

<div style="border: thick groove #0099FF; width: 99%;">
<table width="100%" bgcolor="#5F9EA0">
<tr>
<td>
<asp:Label runat="server" ForeColor="White" ID="lblName" Text="VARSH INFOTECH Pte Ltd."
Font-Bold="True" Font-Size="X-Large">
</td>
<td align="right">
<asp:Label ID="lblCompany" runat="server" ForeColor="White" Font-Bold="True">
<br />
<asp:Label ID="lblUser" runat="server" ForeColor="White" Font-Bold="True">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<uc2:MenuWithImages ID="MenuWithImages2" runat="server" />
</td>
</tr>
<tr>
<td align="center">
<table>
<tr align="center">
<td style="padding:10px">
<asp:ImageButton ID="Imgemp" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Emp.png" OnClick="Imgemp_Click" /><br />Employee
</td>
<td style="padding:10px">
<asp:ImageButton ID="Imgdept" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Departments.png" OnClick="Imgdept_Click" /><br />Department

Member 10928697 4-Sep-14 5:52am View

Deleted

Member 10928697 4-Sep-14 5:47am View

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Main.master.cs" Inherits="vpayroll.Main" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Src="Controls/ImageMenu.ascx" TagName="ImageMenu" TagPrefix="uc1" %>
<%@ Register Src="Controls/MenuWithImages.ascx" TagName="MenuWithImages" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link href="Styles/Accordian.css" rel="stylesheet" type="text/css" />
<link href="Styles/styles.css" rel="stylesheet" type="text/css" />
<link href="javascript:window.close()">Close Window />

<%--<script language="javascript" type="text/javascript">
//function to disable browser back button
function DisableBackButton() {
window.history.forward();
}
setTimeout("DisableBackButton()", 0);
window.onunload = function () { null };
function CloseWindow() {
window.close();
}
</script>--%>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
$(window).unload(function () {

alert("Bye now!");

});
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ADVANCE-Facilities Pte Ltd.</title>
<asp:ContentPlaceHolder ID="head" runat="server">

<style type="text/css">
.auto-style1 {
width: 63px;
}
.auto-style2 {
width: 49px;
}
.auto-style3 {
width: 54px;
}
.auto-style5 {
width: 73px;
}
.auto-style6 {
width: 74px;
}
.auto-style7 {
width: 53px;
}
.auto-style8 {
width: 62px;
}
.auto-style9 {
width: 96px;
}
</style>
</head>
<body>
<form id="form1" runat="server" style="background-color: White;" >
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

<div style="border: thick groove #0099FF; width: 99%;">
<table width="100%" bgcolor="#5F9EA0">
<tr>
<td>
<asp:Label runat="server" ForeColor="White" ID="lblName" Text="VARSH INFOTECH Pte Ltd."
Font-Bold="True" Font-Size="X-Large">
</td>
<td align="right">
<asp:Label ID="lblCompany" runat="server" ForeColor="White" Font-Bold="True">
<br />
<asp:Label ID="lblUser" runat="server" ForeColor="White" Font-Bold="True">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<uc2:MenuWithImages ID="MenuWithImages2" runat="server" />
</td>
</tr>
<tr>
<td align="center">
<table>
<tr align="center">
<td style="padding:10px">
<asp:ImageButton ID="Imgemp" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Emp.png" OnClick="Imgemp_Click" /><br />Employee
</td>
<td style="padding:10px">
<asp:ImageButton ID="Imgdept" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Departments.png" OnClick="Imgdept_Click" /><br />Department</

Member 10928697 4-Sep-14 5:41am View

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Main.master.cs" Inherits="vpayroll.Main" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Src="Controls/ImageMenu.ascx" TagName="ImageMenu" TagPrefix="uc1" %>
<%@ Register Src="Controls/MenuWithImages.ascx" TagName="MenuWithImages" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link href="Styles/Accordian.css" rel="stylesheet" type="text/css" />
<link href="Styles/styles.css" rel="stylesheet" type="text/css" />
<link href="javascript:window.close()">Close Window />

<%--<script language="javascript" type="text/javascript">
//function to disable browser back button
function DisableBackButton() {
window.history.forward();
}
setTimeout("DisableBackButton()", 0);
window.onunload = function () { null };
function CloseWindow() {
window.close();
}
</script>--%>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
$(window).unload(function () {

alert("Bye now!");

});
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ADVANCE-Facilities Pte Ltd.</title>
<asp:ContentPlaceHolder ID="head" runat="server">

<style type="text/css">
.auto-style1 {
width: 63px;
}
.auto-style2 {
width: 49px;
}
.auto-style3 {
width: 54px;
}
.auto-style5 {
width: 73px;
}
.auto-style6 {
width: 74px;
}
.auto-style7 {
width: 53px;
}
.auto-style8 {
width: 62px;
}
.auto-style9 {
width: 96px;
}
</style>
</head>
<body>
<form id="form1" runat="server" style="background-color: White;" >
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

<div style="border: thick groove #0099FF; width: 99%;">
<table width="100%" bgcolor="#5F9EA0">
<tr>
<td>
<asp:Label runat="server" ForeColor="White" ID="lblName" Text="VARSH INFOTECH Pte Ltd."
Font-Bold="True" Font-Size="X-Large">
</td>
<td align="right">
<asp:Label ID="lblCompany" runat="server" ForeColor="White" Font-Bold="True">
<br />
<asp:Label ID="lblUser" runat="server" ForeColor="White" Font-Bold="True">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<uc2:MenuWithImages ID="MenuWithImages2" runat="server" />
</td>
</tr>
<tr>
<td align="center">
<table>
<tr align="center">
<td style="padding:10px">
<asp:ImageButton ID="Imgemp" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Emp.png" OnClick="Imgemp_Click" /><br />Employee
</td>
<td style="padding:10px">
<asp:ImageButton ID="Imgdept" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Departments.png" OnClick="Imgdept_Click" /><br />Department</

Member 10928697 4-Sep-14 5:39am View

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Main.master.cs" Inherits="vpayroll.Main" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Src="Controls/ImageMenu.ascx" TagName="ImageMenu" TagPrefix="uc1" %>
<%@ Register Src="Controls/MenuWithImages.ascx" TagName="MenuWithImages" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link href="Styles/Accordian.css" rel="stylesheet" type="text/css" />
<link href="Styles/styles.css" rel="stylesheet" type="text/css" />
<link href="javascript:window.close()">Close Window />

<%--<script language="javascript" type="text/javascript">
//function to disable browser back button
function DisableBackButton() {
window.history.forward();
}
setTimeout("DisableBackButton()", 0);
window.onunload = function () { null };
function CloseWindow() {
window.close();
}
</script>--%>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
$(window).unload(function () {

alert("Bye now!");

});
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>ADVANCE-Facilities Pte Ltd.</title>
<asp:ContentPlaceHolder ID="head" runat="server">

<style type="text/css">
.auto-style1 {
width: 63px;
}
.auto-style2 {
width: 49px;
}
.auto-style3 {
width: 54px;
}
.auto-style5 {
width: 73px;
}
.auto-style6 {
width: 74px;
}
.auto-style7 {
width: 53px;
}
.auto-style8 {
width: 62px;
}
.auto-style9 {
width: 96px;
}
</style>
</head>
<body>
<form id="form1" runat="server" style="background-color: White;" >
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

<div style="border: thick groove #0099FF; width: 99%;">
<table width="100%" bgcolor="#5F9EA0">
<tr>
<td>
<asp:Label runat="server" ForeColor="White" ID="lblName" Text="VARSH INFOTECH Pte Ltd."
Font-Bold="True" Font-Size="X-Large">
</td>
<td align="right">
<asp:Label ID="lblCompany" runat="server" ForeColor="White" Font-Bold="True">
<br />
<asp:Label ID="lblUser" runat="server" ForeColor="White" Font-Bold="True">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<uc2:MenuWithImages ID="MenuWithImages2" runat="server" />
</td>
</tr>
<tr>
<td align="center">
<table>
<tr align="center">
<td style="padding:10px">
<asp:ImageButton ID="Imgemp" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Emp.png" OnClick="Imgemp_Click" /><br />Employee
</td>
<td style="padding:10px">
<asp:ImageButton ID="Imgdept" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/Menu_Images/Departments.png" OnClick="Imgdept_Click" /><br />Department</

Member 10928697 4-Sep-14 5:37am View

i will send my html code will u modifide sir.

Member 10928697 4-Sep-14 5:34am View

can i send my html code .will u modifide sir.

Member 10928697 4-Sep-14 5:32am View

i will send my html code will u modifide sir.

Member 10928697 4-Sep-14 5:23am View

can i appy a bove code...just blinking my file...its not work

Member 10928697 4-Sep-14 3:07am View

i want exit button code in jquery.

Member 10928697 4-Sep-14 2:28am View

exit button code in javascript plz tell me

Member 10928697 4-Sep-14 2:27am View

exit button in javascript plz tell me

Member 10928697 4-Sep-14 1:54am View

ok..i want exit image button code in javascript to the main menu plz tell me.

Member 10928697 3-Sep-14 8:34am View

exit is not a button sir...it's an icon...when i execute the program...when i click exit icon after that close the window sir.....i want that code in javascript/jquery

Member 10928697 3-Sep-14 8:12am View

ok sir...i want exit button code in javascript or jquery plz tellme.

Member 10928697 3-Sep-14 7:52am View

ok sir...i want exit button code in javascript or jquery plz tellme.

Member 10928697 28-Aug-14 4:35am View

thank u sir.

Member 10928697 28-Aug-14 3:14am View

escaped )
---------executed sir

Member 10928697 28-Aug-14 3:11am View

Create Procedure ir8a88
(
@sal_Year int,
@comp_id int,
@emp_code varchar(50)
)
As
Begin

select sal_det_id, comp_id, sal_id, sal_isdeduct, sal_det_desc, sal_det_hrs,sal_det_amt as sal_det_amt,sal_det_cpf from salary_details where sal_det_deleted = 0
and sal_isdeduct = 1 and sal_id IN ( select sal_id from salary_master where sal_deleted = 0 and sal_Year =@sal_Year and comp_id = @comp_id and emp_code =@emp_code
End

Member 10928697 28-Aug-14 3:00am View

error occured in end poition sir

Member 10928697 28-Aug-14 2:57am View

its ok sir..im join in my company just 4mnts..problem is mine.its ok

Member 10928697 28-Aug-14 2:52am View

we can clearly observed above query sir.previous query, this query was was not same sir...feilds are different.if u understand tell me or live it.

Member 10928697 28-Aug-14 2:46am View

yes

Member 10928697 28-Aug-14 2:40am View

same question but query was different sir.

Member 10928697 28-Aug-14 1:28am View

In the bove select query is ok but i wantwith out values..only parameters.

Member 10928697 27-Aug-14 8:12am View

k sir
no need vpcn sir.
salary_marter table is
------------------------

sal_id int Unchecked
comp_id int Checked
emp_code nvarchar(50) Checked
sal_year int Checked
sal_month int Checked
sal_paydate datetime Checked
sal_type nvarchar(20) Checked
sal_salary decimal(18, 2) Checked
sal_comp_cpf decimal(18, 2) Checked
sal_emp_cpf decimal(18, 2) Checked
sal_earn_additional decimal(18, 2) Checked
sal_comp_cpf_additional decimal(18, 2) Checked
sal_emp_cpf_additional decimal(18, 2) Checked
sal_total_income decimal(18, 2) Checked
sal_total_deductions decimal(18, 2) Checked
sal_netpay decimal(18, 2) Checked
sal_agency nvarchar(20) Checked
sal_fund decimal(18, 2) Checked
sal_status nvarchar(10) Checked
sal_approved bit Checked
sal_approved_by nvarchar(50) Checked
sal_approved_date datetime Checked
sal_canceled_by nvarchar(50) Checked
sal_canceled_date datetime Checked
sal_createdby nvarchar(50) Checked
sal_createddate datetime Checked
sal_updatedby nvarchar(50) Checked
sal_updateddate datetime Checked
sal_deleted bit Checked
sal_sdl decimal(18, 2) Checked
sal_fwl decimal(18, 2) Checked
sal_bonus decimal(18, 2) Checked
sal_bonusdate datetime Checked
sal_bonus_comp_cpf decimal(18, 2) Checked
sal_bonus_emp_cpf decimal(18, 2) Checked
sal_exported bit Checked
sal_exported_date datetime Checked
sal_1half_pay decimal(18, 2) Checked
sal_payleave decimal(18, 2) Checked
sal_remarks nvarchar(250) Checked
sal_isemail_sent bit Checked
dept_code nvarchar(50) Checked
sal_paymode nvarchar(20) Checked
sal_usedby nvarchar(200) Checked
sal_project1 nvarchar(30) Checked
sal_project1Time decimal(18, 2) Checked
sal_project1Price decimal(18, 2) Checked
sal_project2 nvarchar(30) Checked
sal_project2Time decimal(18, 2) Checked
sal_project2Price decimal(18, 2) Checked
sal_project3 nvarchar(30) Checked
sal_project3Time decimal(18, 2) Checked
sal_project3Price decimal(18, 2) Checked
sal_project4 nvarchar(30) Checked
sal_project4Time decimal(18, 2) Checked
sal_project4Price decimal(18, 2) Checked
sal_project5 nvarchar(30) Checked
sal_project5Time decimal(18, 2) Checked
sal_project5Price decimal(18, 2) Checked
sal_1half_cpf decimal(18, 2) Checked
Unchecked

Member 10928697 27-Aug-14 8:04am View

in the above code is windows form..convert the above code in sql query formet sir.

Member 10928697 27-Aug-14 7:32am View

How to write stored procedure in the below query
------------------------------------------------
Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "'" ;
if (vpcn.gbHalfSalary == true)
{
Sqlstr += " and sal_type = '" + vpcn.cSalary_2Half + "' ";
}
strBonus = cfs.get_data(Sqlstr);
plz tell me query

Member 10928697 27-Aug-14 7:27am View

Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "'" ;
if (vpcn.gbHalfSalary == true)
{
Sqlstr += " and sal_type = '" + vpcn.cSalary_2Half + "' ";
}
strBonus = cfs.get_data(Sqlstr);
plz tell me query

Member 10928697 23-Aug-14 3:02am View

Add abovelink Edit & Delete also..

Member 10928697 23-Aug-14 3:00am View

Search GridView records (data) on TextBox KeyPress using

Member 10928697 22-Aug-14 4:58am View

i can search the data using textbox it is worked....but in gridview i can save the data, after that in gridview last row was not updated ,not deleted... onlt update delete options..
can i use below code sir.
-------------------------------------------------------------------------------------------
javascript
-----------
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="js/quicksearch.js"></script>
<script type="text/javascript">
$(function () {
$('.search_textbox').each(function (i) {
$(this).quicksearch("[id*=gvProjects] tr:not(:has(th))", {
'testQuery': function (query, txt, row) {
return $(row).children(":eq(" + i + ")").text().toLowerCase().indexOf(query[0].toLowerCase()) != -1;
}
});
});
});
</script>"
------------------------------------------------------------------------------------
protected void gvProjects_DataBound(object sender, EventArgs e)
{
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
for (int i = 0; i < gvProjects.Columns.Count-2; i++)
{
TableHeaderCell cell = new TableHeaderCell();
TextBox txtSearch = new TextBox();
txtSearch.Attributes["placeholder"] = gvProjects.Columns[i].HeaderText;
txtSearch.CssClass = "search_textbox";
cell.Controls.Add(txtSearch);
row.Controls.Add(cell);
}
gvProjects.HeaderRow.Parent.Controls.AddAt(1, row);
}

Member 10928697 22-Aug-14 3:35am View

Can I Use In The Below Link To My From.......But Gridview Delete & Edit Last Row Does Not Work Plz Slow Them.
--------------------------------------------------------------------------------------------
Insert Update Edit Delete record in GridView using Javascript in ASP.Net

Member 10928697 20-Aug-14 7:50am View

sry..
this is table.
lq_id int
lq_year int
lv_type_id
comp_id int
emp_code
lq_leave_days
lq_leave_taken
lq_leave_balance
lq_createdby
lq_createddate
lq_updatedby
lq_updateddate
lq_deleted
lq_leave_prev_days
..
this is windows form
------------------
private void Btn_GetList_Click(object sender, EventArgs e)
{
strSql = "SELECT leave_id,a.emp_code as [Emp Code],b.emp_fname as [Employee],c.lv_type_name as [Leave Type], leave_start_time as [From Date],leave_end_time as [To Date],";
strSql += "a.leave_days as [No.of Days],a.leave_status as [Status],a.leave_doneby as [Doneby],a.leave_balance_days as [Available Days] FROM Leave a, employee as b,";
strSql += " LeaveTypes as c ,Emp_Leave_Quota as d ";
strSql += " where a.emp_code='"+strUid+"' and d.comp_id = a.comp_id And d.emp_code = a.emp_code And d.lv_type_id = a.leave_type_id";
strSql += " and d.lq_year = year(a.leave_date) ";
strSql += " and c.lv_type_id = a.leave_type_id ";
strSql += " and b.comp_id = a.comp_id and b.emp_code = a.emp_code";
strSql += " and a.leave_deleted = 0 and a.comp_id = '" + strCompanyid + "'";

if (Cb_Year.Text != "")
strSql += " and year(leave_date) = '" + Cb_Year.Text + "'";
else
strSql += " and year(leave_date) = '" + Cb_Year.Text + "'";
//if (Cb_EmpLeaveType.SelectedValue.ToString() != "ALL") strSql += " and a.leave_type_id = '" + Cb_EmpLeaveType.SelectedValue.ToString() + "'";

if (Cb_EmpLeaveType.Text != "ALL") strSql += " and c.lv_type_name = '" + Cb_EmpLeaveType.Text + "'";
Cursor = Cursors.WaitCursor;
dap = new SqlDataAdapter(strSql, cn);
sqlcommbuild = new SqlCommandBuilder(dap);
dtblTemp = new DataTable();
dap.Fill(dtblTemp);
bindsrc = new BindingSource();
bindsrc.DataSource = dtblTemp;
Dgv_Summary.DataSource = bindsrc;
//dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
Dgv_Summary.Columns[0].Visible = false;
Dgv_Summary.Columns[1].Visible = false;
Cursor = Cursors.Default;

Member 10928697 20-Aug-14 7:40am View

ok tq.

Member 10928697 20-Aug-14 7:29am View

ALTER Procedure [dbo].[sp_LeaveSummaryGetAll]

@comp_id int,
@lq_year int,
@emp_id nvarchar(200),
@leave_type_name nvarchar(200),
@emp_chk int,
@lv_chk int
As
Begin
if(@emp_chk=1)
begin
if(@lv_chk=1)
begin
SELECT leave_id,a.emp_code as [Emp Code],b.emp_fname as [Emp Name],c.lv_type_name as [Leave Type],convert(varchar (10), leave_start_time,103) as [From Date],convert(varchar (10), leave_end_time,103) as [To Date],
a.leave_days,a.leave_status as [Status],a.leave_doneby as [Doneby],a.leave_balance_days as [Available Leaves] FROM Leave a, employee as b,
LeaveTypes as c ,Emp_Leave_Quota as d
where d.comp_id = a.comp_id And d.emp_code = a.emp_code And d.lv_type_id = a.leave_type_id
and d.lq_year = year(a.leave_date)
and c.lv_type_id = a.leave_type_id
and b.comp_id = a.comp_id and b.emp_code = a.emp_code
and a.leave_deleted = 0 and a.comp_id = @comp_id and year(leave_date)=@lq_year
end
else
begin
SELECT leave_id,a.emp_code as [Emp Code],b.emp_fname as [Emp Name],c.lv_type_name as [Leave Type],convert(varchar (10), leave_start_time,103) as [From Date],convert(varchar (10),leave_end_time,103) as [To Date],
a.leave_days,a.leave_status as [Status],a.leave_doneby as [Doneby],a.leave_balance_days as [Available Leaves] FROM Leave a, employee as b,
LeaveTypes as c ,Emp_Leave_Quota as d
where d.comp_id = a.comp_id And d.emp_code = a.emp_code And d.lv_type_id = a.leave_type_id
and d.lq_year = year(a.leave_date)
and c.lv_type_code = a.leave_type_id
and b.comp_id = a.comp_id and b.emp_code = a.emp_code
and a.leave_deleted = 0 and a.comp_id = @comp_id and year(leave_date)=@lq_year
and c.lv_type_name =@leave_type_name

end
end
else
begin
if(@lv_chk=1)
begin
SELECT leave_id,a.emp_code as [Emp Code],b.emp_fname as [Emp Name],c.lv_type_name as [Leave Type],convert(varchar (10), leave_start_time,103) as [From Date],convert(varchar (10),leave_end_time,103) as [To Date],
a.leave_days,a.leave_status as [Status],a.leave_doneby as [Doneby],a.leave_balance_days as [Available Leaves] FROM Leave a, employee as b,
LeaveTypes as c ,Emp_Leave_Quota as d
where d.comp_id = a.comp_id And d.emp_code = a.emp_code And d.lv_type_id = a.leave_type_id
and d.lq_year = year(a.leave_date)
and c.lv_type_code = a.leave_type_id
and b.comp_id = a.comp_id and b.emp_code = a.emp_code
and a.leave_deleted = 0 and a.comp_id = @comp_id and year(leave_date)=@lq_year and
a.emp_code=@emp_id
end
else
begin
SELECT leave_id,a.emp_code as [Emp Code],b.emp_fname as [Emp Name],c.lv_type_name as [Leave Type],convert(varchar (10), leave_start_time,103) as [From Date],convert(varchar (10),leave_end_time,103) as [To Date],
a.leave_days,a.leave_status as [Status],a.leave_doneby as [Doneby],a.leave_balance_days as [Available Leaves] FROM Leave a, employee as b,
LeaveTypes as c ,Emp_Leave_Quota as d
where d.comp_id = a.comp_id And d.emp_code = a.emp_code And d.lv_type_id = a.leave_type_id
and d.lq_year = year(a.leave_date)
and c.lv_type_code = a.leave_type_id
and b.comp_id = a.comp_id and b.emp_code = a.emp_code
and a.leave_deleted = 0 and a.comp_id = @comp_id and year(leave_date)=@lq_year
and c.lv_type_name =@leave_type_name and a.emp_code=@emp_id
end
end
end
this is my stored procedure plz slove

Member 10928697 18-Aug-14 7:36am View

thanku

Member 10928697 18-Aug-14 7:08am View

r u right..sp was not currect formet

Member 10928697 18-Aug-14 7:07am View

i got an error ------BBEL.lv_type_id = Convert.ToInt16(LvTypeId);
input string was not currect formet

Comments by Member 10928697 (Top 114 by date)