Comments by ajays3356 (Top 66 by date)

I want all the record between April,2016 to March,2014

This query gives the sum of only 4,2013 and 3,2014...

But I want all the rows in between.

i have try this,it gives null,But i have columns in table

But i want all the column Between 4,2013 and 3,2013

Not working..

hii, I am using your code but it refreshing the same pop up window.I am using the code as follows

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

window.parent.location.reload(true);
var cancel = window.close();

}
</script>
on cancel button in pop up window

datetime

No improvement same error is coming.

i am trying your code but now when it finds the rows then it shows only one row out of three.

i had tried this way but this function if(fplUploadexcel.hasfile) shows false and control passes to to else part.

Thanks For your reply.But i don't want the file uploader to be visible.what i want is that when i click the image then i can select file an upload the selected file.

sheet name is xlsx.Yes i have tried to namually giving the path of excelsheet but still facing the same problem.

I don't understand this the file is on my pc and it is already closed..

I am trying your code but i am having the following error..

The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

DataTable dt = new DataTable();
Line 69: adapt.Fill(dt); On this line.

Guid does not contain an defination for TryParse..This is shows in Intellesense..

Following is my dropdown list from where i am getting the ddlParentName.SelectedItem.Value
<asp:DropDownList ID="ddlParentName" CssClass="nonwatermarkedddl" runat="server"
Width="146" AppendDataBoundItems="true">
<asp:ListItem Selected="True" Text="None" Value="">



and code is

using (SqlDataAdapter adapt = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
adapt.Fill(ds);
ddlParentName.DataSource = ds;
ddlParentName.DataTextField = "AccountGroupName";
ddlParentName.DataValueField = "AccountGroupId";
ddlParentName.DataBind();
}
}

And Now AccountgroupId is Uniqueidentifier
and i have requirement like if user selects the none in DropDown then null will be in dbcoloumn and when he selects the menu from dropdown the that uniqueidentifier value should be store in an database...

Now, i have try your code now it shows cannot convert string to GUID..

Both value are uniqueidentifier in database..

yes its working but now it shows all checkboxes checked which are even false in database.

yeah it entered.but again chkisdefault shows null.

Yes I am trying with your code ...but while tracing it is not even entering in the f(e.Row.RowType == DataControlRowType.DataRow) block.

No.Not Working..Same Problem..

it shows on this line..
chkisdefault.Checked = true;

and while tracing it shows that chkisdefault is null

Can you tell me whether i am finding the control in gridview is correct or not..

<asp:GridView ID="GridViewTrustee" runat="server" CellPadding="4" Width="100%" BackColor="White"
BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" AutoGenerateColumns="False"
DataKeyNames="EmployeeReferenceId" OnRowCommand="GridViewTrustee_RowCommand"
OnRowDeleting="DeleteRecord" OnRowDataBound="GridViewTrustee_RowDataBound">
<columns>
<asp:TemplateField HeaderText="Actions">
<itemtemplate>
<asp:LinkButton ID="lnkEdit" runat="server" Text="Edit" CommandName="edit">
<asp:LinkButton ID="lnkDelete" runat="server" Text="Delete" CommandName="Delete"
OnClientClick="return confirm('Are you sure you want to delete this event?');">


<asp:TemplateField HeaderText="Employee Id">
<itemtemplate>
<asp:Label ID="gridEmployeeId" runat="server" Text='<%# Eval("EmployeeReferenceId") %>'>

<asp:TemplateField HeaderText="Trustee Name">
<itemtemplate>
<asp:Label ID="lblTrusteeName" runat="server" Text='<%# Eval("TrusteeName") %>'>

<edititemtemplate>
<asp:TextBox ID="txtTrusteeName" runat="server">

<asp:TemplateField HeaderText="Is Default Signatory">
<itemtemplate>
<asp:CheckBox ID="chkisdefaultsign" runat="server" Enabled="false" />


<asp:TemplateField HeaderText="Description">
<itemtemplate>
<asp:Label ID="lblDescription" runat="server" Text='<%# Eval("Description") %>'>
<edititemtemplate>
<asp:TextBox ID="txtDescription" runat="server" Text='<%# Eval("Description") %>'>

<asp:TemplateField HeaderText="Is Active">
<itemtemplate>
<asp:CheckBox ID="chisactive" runat="server" Enabled="false" />


<footerstyle backcolor="#99CCCC" forecolor="#003399">
<HeaderStyle BackColor="#64B1FF" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" />
<rowstyle backcolor="White" forecolor="#003399">
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />

No, its not working again its showing the same error...

The problem is solved through asp hidden feild control..

can you show me an any example to use hidden fields..

Hello JoCodes,
I have updated my question..

I have tried this but it shows an no object reference error...

means whenever txtlinemanager textbox is filled with some id then the txttrustname textbox should auotmatically be filled with trusteename on behalf of that particular id in txtlinemanager textbox ...

This is my Id Text Box

<asp:TextBox ID="txtlinemanager" Width="120" CssClass="nonwatermarked" runat="server">
<asp:ImageButton ID="imgbtnbusinessheadid" runat="server" ToolTip="Click here for search..."
ImageUrl="~/Icons/search-button.gif" OnClientClick=' return OpenPopup("manager");


This is name name textbox

Collapse | Copy Code
<div class="txtLTitleMenuEdit">
Trustee Name</div>
<div class="lblfullname">
<asp:TextBox ID="txtTrusteeName" ReadOnly="true" Width="300" CssClass="nonwatermarked"
runat="server" ><div class="divnewline">
</div>


The Method i have created is

protected void TrusteeName()
{
using (SqlConnection con = new SqlConnection(connectionstring))
{
using (SqlCommand cmd = new SqlCommand("select trusteename from table where Id='" + txtlinemanager.text + "'", con))
{
using (SqlDataAdapter adapt = new SqlDataAdapter(cmd))
{
DataSet ds=new DataSet();
adapt.Fill(ds);
txttrusteename.text = ds.Tables[0].Rows[0]["trusteename"].ToString();
}

}
}
}

This Function i have created but dont know where to call it..

can you tell me link to read about jquery and the onchange event of textbox ..

I have updated the question now please tell me.

how, can you give me an example please..

Thank You, JoCodes For your Great Great Help..Now Its Working and I understand the problem that i have taken link button but assigning to the code..And once again thankyou very very much..

<asp:GridView ID="GridViewTrustee" runat="server" CellPadding="4" Width="100%" BackColor="White"
BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" AutoGenerateColumns="false"
RowStyle-BackColor="White" RowStyle-ForeColor="#003399" FooterStyle-BackColor="#99CCCC"
FooterStyle-ForeColor="#003399" PagerStyle-BackColor="#99CCCC" PagerStyle-ForeColor="#003399"
SelectedRowStyle-BackColor="#009999" SelectedRowStyle-Font-Bold="true" SelectedRowStyle-ForeColor="#CCFF99"
HeaderStyle-BackColor="#64B1FF" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="#CCCCFF"
OnRowDataBound="GridViewTrustee_RowDataBound" DataKeyNames="EmployeeReferenceId"
OnRowDeleting="GridViewTrustee_RowDeleting"
OnRowCommand="GridViewTrustee_RowCommand">
<columns>
<%-- <asp:CommandField ShowEditButton="true" ShowDeleteButton="true" HeaderText="Actions" />--%>
<asp:TemplateField HeaderText="Actions">
<itemtemplate>
<asp:LinkButton ID="lnkEdit" runat="server" Text="Edit" CommandName="edit">
<asp:LinkButton ID="lnkDelete" runat="server" Text="Delete">


<asp:TemplateField HeaderText="Employee Id">
<itemtemplate>
<asp:Label ID="gridEmployeeId" runat="server" Text='<%# Eval("EmployeeReferenceId") %>'>

<%--<asp:TemplateField HeaderText="Trustee Name">
<itemtemplate>
<asp:Label ID="grdTrusteename" runat="server" Text='<%# Eval("TrusteeName") %>'>

<edititemtemplate>
<asp:TextBox ID="txttrusteename" runat="server" Text='<%# Eval("TrusteeName") %>'>
--%>
<%--<asp:CheckBoxField HeaderText="Is Default Signatory" />--%>
<asp:TemplateField HeaderText="Is Default Signatory">
<itemtemplate>
<asp:CheckBox ID="chkisdefaultsign" runat="server" Enabled="false" />


<asp:TemplateField HeaderText="Description">
<itemtemplate>
<asp:Label ID="lblDescription" runat="server" Text='<%# Eval("Description") %>'>
<edititemtemplate>
<asp:TextBox ID="txtDescription" runat="server" Text='<%# Eval("Description") %>'>

<%--<asp:CheckBoxField HeaderText="Is Active" />--%>
<asp:TemplateField HeaderText="Is Active">
<itemtemplate>
<asp:CheckBox ID="chisactive" runat="server" Enabled="false" />

it's 0.

I am redirecting on another page on edit click..and i am getting the error in
int index = Convert.ToInt32(e.CommandArgument);

in Session["EmployeeReferenceId"] = lblid.Text;

Hello JoCodes
I tried your code but now i facing the error.

Input string was not in a correct format.

if (e.CommandName.Equals("edit"))
Line 292: {
Line 293: int index = Convert.ToInt32(e.CommandArgument);
Line 294: GridViewRow row = GridViewTrustee.Rows[index];
Line 295: Label lblid = (Label)row.FindControl("gridEmployeeId");

yes i have check in ie8 and google chrome...

No, I don,t want to set the width of an div.I want To change the look and feel of that srollbar,,is it possible...

So,how can i create an report for my project.

I have added an Business Intelligence Project.

No.

NO,Its not working.I have add an report server project in 4 layer.It BI Project part.I have build an solution but again notr getting an reference..

And thanks for your help...

OOhh,,,Sorry sorry I got it what u are trying to saying ...My mistake...i should simply pass the id.text instead of coverting it to int type...sorry my mistake..

So, how would i suppose do this...please suggest me i am new to .net.

and above id that i am taking in an session have to pass in the query which is on another page...

and how would i supposse to do that plz tell me...

I am not getting anything on the div(headermenutab)..when i view in the browser its empty

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

al.Add(aa[i]);
}
foreach (LinkButton s in al)
{
headerMenuTab.Controls.Add(s);
}


now i have added the above code but getting following error..
Unable to cast object of type 'System.String' to type 'System.Web.UI.WebControls.LinkButton'.

ookk...so how should i do to work properly the above code plz suggest

yes, i am trying the above css class but not getting the result

applied but again dont getting the display correctly

I Had already applied this settiing in myy IIS but it doesn't Work..

I am having the following error what does it mean sir.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Unable to cast object of type 'ASP.default2_aspx' to type 'BasePage'.

Source Error:


Line 17: protected void Page_Load(object sender, EventArgs e)
Line 18: {
Line 19: ENTUserAccountEO currentUser = ((BasePage)Page).CurrentUser;
Line 20:
Line 21: //Set the top menu properties

Thankyou very very much Sir ...
You have really give me an appreciable help.Now I am able to run my project and save my carrier...Thanks Once again sir..

I am getting the following error what does it mean sir...I am not able to understand this error..
Actually I created an vitual directory in IIS bind it to the project location but while running the project getting the following error-

ERROR-It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

When I run project in vs2010 then. In vs2008 I didn't run as i don't have vs2008 on my machine...

Yeah..Just Have to add an crystal report 10..

Yes This the book..Actually I am trying to Convert this into vs2010 and my seniors want me to compile this project successfully...

www.wrox.com
This is the link from where i had download the project.
Search the code by the following isbn number

the book’s ISBN is
978-0-470-39686-5

and in that there is an chapter 12 which i want to run..And once again Thanks for above help

Thanks For the answer but i had already try this but still getting the same error the reference could not be found..