0

hey,

i m working on Asp.net with C#
i made a table which has username, CheckIntime, Checkouttime and Date in a grid view
i want that customer enter his name in text box and click the submit button then it display his data in table on web page

i do the the coding like this can u plz help me and tell me how can i do this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

namespace manage_logs
{
    public partial class UserView : System.Web.UI.Page
    {



        protected void Page_Load(object sender, EventArgs e)
        {
            // GridView1.Visible = false;

        }


        protected void Button1_Click(object sender, EventArgs e)
        {

            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("select * from [Logs] where name = '" + TextBox1.Text + "'", conn);
            //SqlDataReader reader;

            conn.Open();
            try
            {
                SqlParameter Username = new SqlParameter();
                Username.ParameterName = "@TextBox1.Text";
                Username.Value = TextBox1.Text.Trim();
                cmd.Parameters.Add(Username);
                SqlDataReader dr = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(dr);
                GridView1.DataSource = dt;
                GridView1.DataBind();
                SqlParameter search = new SqlParameter();

            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
            finally
            {
                //Connection Object Closed
                conn.Close();
            }
        }
    }
}

Edited by __avd: Added [code]..[/code] tags.

4
Contributors
28
Replies
47
Views
6 Years
Discussion Span
Last Post by prateekpk5
0

Something like this would work.

protected void Button1_Click(object sender, EventArgs e)
    {
        
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlCommand cmd = new SqlCommand("select * from [Logs] where name = @Username", conn);
        try
        {
            using (conn)
            {
            conn.Open();
                SqlParameter Username = new SqlParameter();
                Username.ParameterName = "@Username";
                Username.SqlDbType = System.Data.SqlDbType.varchar
                Username.Value = TextBox1.Text.Trim();
                cmd.Parameters.Add(Username);
                GridView1.DataSource = cmd.ExecuteReader();
                GridView1.DataBind();
            }

        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
    }
}

I switched out the finally for a using and had the datasource use the reader directly as well. I also made it so the query actually uses the parameter you were using.

As for the gridview make sure the field names are actually set up. For an example look below.

<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:BoundField DataField="Fieldname Here" />
</Columns>
</asp:GridView>

Also since the sql statement uses = insted of like whatever is in the textbox will need to match the name column in the database exactly

Edited by __avd: Added [code]..[/code] tags.

0

it give error


Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'ASP.categoryview_userview_aspx' does not contain a definition for 'TextBox1_TextChanged' and no extension method 'TextBox1_TextChanged' accepting a first argument of type 'ASP.categoryview_userview_aspx' could be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 19: </div>
Line 20: <p>
Line 21: <asp:TextBox ID="TextBox1" runat="server"
Line 22:
Line 23: style="z-index: 1; left: 258px; top: 55px; position: absolute; height: 27px"

0

This is my source view

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserView.aspx.cs" Inherits="manage_logs.UserView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        UserView<br />
        <br />
        <asp:Label ID="Label1" runat="server" 
            style="z-index: 1; left: 96px; top: 58px; position: absolute" 
            Text="EnterUserName"></asp:Label>
    
    </div>
    <p>
        <asp:TextBox ID="TextBox1" runat="server" 
            
            style="z-index: 1; left: 258px; top: 55px; position: absolute; height: 27px" 
            OnTextChanged="TextBox1_TextChanged"></asp:TextBox>
    </p>
    <asp:Button ID="Button1" runat="server" 
        style="z-index: 1; left: 256px; top: 108px; position: absolute" 
        Text="Submit" onclick="Button1_Click" />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="UserName" DataSourceID="SqlDataSource1" 
        EnableModelValidation="True" 
        style="z-index: 1; left: 71px; top: 303px; position: absolute; height: 42px; width: 7px">
        <Columns>
            <asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" 
                SortExpression="UserName" />
            <asp:BoundField DataField="CheckinTime" HeaderText="CheckinTime" 
                SortExpression="CheckinTime" />
            <asp:BoundField DataField="CheckoutTime" HeaderText="CheckoutTime" 
                SortExpression="CheckoutTime" />
            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [Logs]"></asp:SqlDataSource>
    <asp:GridView ID="GridView2" runat="server" 
        style="z-index: 1; left: 448px; top: 209px; position: absolute; height: 137px; width: 48px; margin-top: 0px">
    </asp:GridView>
    </form>
</body>
</html>

Edited by __avd: Added [code] tags.

0

Get rid of the OnTextChanged="TextBox1_TextChanged" in the asp:textbox clientside since there is no corresponding server side method.

0

like that but gives error text box does not exit

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserView.aspx.cs" Inherits="manage_logs.UserView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        UserView<br />
        <br />
        <asp:Label ID="Label1" runat="server" 
            style="z-index: 1; left: 96px; top: 58px; position: absolute" 
            Text="EnterUserName"></asp:Label>
    
    </div>
    <p>
        <asp:TextBox ID="TextBox1" runat="server" 
            
            style="z-index: 1; left: 258px; top: 55px; position: absolute; height: 27px" 
            </asp:TextBox>
    </p>
    <asp:Button ID="Button1" runat="server" 
        style="z-index: 1; left: 256px; top: 108px; position: absolute" 
        Text="Submit" onclick="Button1_Click" />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="UserName" DataSourceID="SqlDataSource1" 
        EnableModelValidation="True" 
        style="z-index: 1; left: 71px; top: 303px; position: absolute; height: 42px; width: 7px">
        <Columns>
            <asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" 
                SortExpression="UserName" />
            <asp:BoundField DataField="CheckinTime" HeaderText="CheckinTime" 
                SortExpression="CheckinTime" />
            <asp:BoundField DataField="CheckoutTime" HeaderText="CheckoutTime" 
                SortExpression="CheckoutTime" />
            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [Logs]"></asp:SqlDataSource>
    <asp:GridView ID="GridView2" runat="server" 
        style="z-index: 1; left: 448px; top: 209px; position: absolute; height: 137px; width: 48px; margin-top: 0px">
    </asp:GridView>
    </form>
</body>
</html>

Edited by __avd: Added [code] ..[/code] tags.

0

<asp:TextBox ID="TextBox1" runat="server"
style="z-index: 1; left: 258px; top: 55px; position: absolute; height: 27px">
</asp:TextBox>

Use that, you accidently deleted the closing tag for the textbox. The last > on the second line.

0

its running but its not giving me data it gives an error like invalid column name when i click submit button

Edited by rahigoswami: n/a

0

Also, didn't notice this until you posted the html but since you already have a sqldatasource assigned to the gridview that will automatically be databound everytime. You will want to get rid of that and instead bind it server side.
You can put this either in the page load itself. Also to fix the wrong column error I changed name to username in the query select statement. I will post everything below.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserView.aspx.cs" Inherits="manage_logs.UserView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

UserView<br />
<br />
<asp:Label ID="Label1" runat="server"
style="z-index: 1; left: 96px; top: 58px; position: absolute"
Text="EnterUserName"></asp:Label>

</div>
<p>
<asp:TextBox ID="TextBox1" runat="server"
style="z-index: 1; left: 258px; top: 55px; position: absolute; height: 27px"></asp:TextBox>
</p>
<asp:Button ID="Button1" runat="server"
style="z-index: 1; left: 256px; top: 108px; position: absolute"
Text="Submit" onclick="Button1_Click" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="UserName" 
EnableModelValidation="True"
style="z-index: 1; left: 71px; top: 303px; position: absolute; height: 42px; width: 7px">
<Columns>
<asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True"
SortExpression="UserName" />
<asp:BoundField DataField="CheckinTime" HeaderText="CheckinTime"
SortExpression="CheckinTime" />
<asp:BoundField DataField="CheckoutTime" HeaderText="CheckoutTime"
SortExpression="CheckoutTime" />
<asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
</Columns>
</asp:GridView>
<asp:GridView ID="GridView2" runat="server"
style="z-index: 1; left: 448px; top: 209px; position: absolute; height: 137px; width: 48px; margin-top: 0px">
</asp:GridView>
</form>
</body>
</html> 

Code:

    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlCommand cmd = new SqlCommand("select * from [Logs]", conn)   
        using (conn)
        {
        conn.Open();
        GridView1.DataSource = cmd.ExecuteReader();
        GridView1.DataBind();
        }
    }

protected void Button1_Click(object sender, EventArgs e)
{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [Logs] where Username = @Username", conn);
try
{
using (conn)
{
conn.Open();
SqlParameter Username = new SqlParameter();
Username.ParameterName = "@Username";
Username.SqlDbType = System.Data.SqlDbType.varchar
Username.Value = TextBox1.Text.Trim();
cmd.Parameters.Add(Username);
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

It will be bound twice on postback but for simplicities sake we will forgo efficiency right now. :)
Let me know if it throws anymore errors.

Edited by __avd: Added [code] tags.

0

my c # code:-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

namespace manage_logs
{
    public partial class UserView : System.Web.UI.Page
    {



        protected void Page_Load(object sender, EventArgs e)
        {
             GridView1.Visible = false;

        }



       protected void Button1_Click(object sender, EventArgs e)
{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [Logs] where name = @Username", conn);
try
{
using (conn)
{
conn.Open();
SqlParameter Username = new SqlParameter();
Username.ParameterName = "@Username";
Username.SqlDbType = System.Data.SqlDbType.VarChar;
Username.Value = TextBox1.Text.Trim();
cmd.Parameters.Add(Username);
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
GridView1.Visible = true;
}

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
    }


       
MY source code 

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserView.aspx.cs" Inherits="manage_logs.UserView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        UserView<br />
        <br />
        <asp:Label ID="Label1" runat="server" 
            style="z-index: 1; left: 96px; top: 58px; position: absolute" 
            Text="EnterUserName"></asp:Label>
    
    </div>
   
    <asp:Button ID="Button1" runat="server" 
        style="z-index: 1; left: 256px; top: 108px; position: absolute" 
        Text="Submit" onclick="Button1_Click" />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="UserName" DataSourceID="SqlDataSource1" 
        EnableModelValidation="True" 
        
        style="z-index: 1; left: 71px; top: 226px; position: absolute; height: 42px; width: 7px">
        <Columns>
            <asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" 
                SortExpression="UserName" />
            <asp:BoundField DataField="CheckinTime" HeaderText="CheckinTime" 
                SortExpression="CheckinTime" />
            <asp:BoundField DataField="CheckoutTime" HeaderText="CheckoutTime" 
                SortExpression="CheckoutTime" />
            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [Logs]"></asp:SqlDataSource>
    <asp:TextBox ID="TextBox1" runat="server" 
        style="z-index: 1; left: 239px; top: 52px; position: absolute"></asp:TextBox>
    <asp:GridView ID="GridView2" runat="server" 
        style="z-index: 1; left: 448px; top: 209px; position: absolute; height: 137px; width: 48px; margin-top: 0px">
    </asp:GridView>
    </form>
</body>
</html>

Edited by __avd: Added [code] tags.

0

See my post right before you posted. You can probably add the GridView1.Visible = false; to the pageload again since I accidently removed that.

0

one more thing
suppose i have same table like the previous one now i want that user can select a stat date and end date from the calender and it will check into the database display the data like the previous one

my source view

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ViewLog.aspx.cs" Inherits="manage_logs._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    </head>
<body>
    <form id="form1" runat="server">
    <p>
        Manage Logs ( View Log)</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        <asp:Label ID="Label2" runat="server" 
            style="z-index: 1; left: 231px; top: 123px; position: absolute; height: 19px; width: 81px" 
            Text="Start Date"></asp:Label>
    </p>
    <p>
        &nbsp;</p>
    <asp:Calendar ID="Calendar1" runat="server" 
        style="z-index: 1; left: 351px; top: 32px; position: absolute; height: 205px; width: 9px">
    </asp:Calendar>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <asp:Calendar ID="Calendar2" runat="server" 
        onselectionchanged="Calendar2_SelectionChanged" 
        style="z-index: 1; left: 348px; top: 260px; position: absolute; height: 205px; width: 9px">
    </asp:Calendar>
    <p>
        <asp:Label ID="Label3" runat="server" 
            style="z-index: 1; left: 232px; top: 288px; position: absolute" Text="End Date"></asp:Label>
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click1" 
            style="z-index: 1; left: 303px; top: 522px; position: absolute; height: 26px; width: 91px; margin-bottom: 62px" 
            Text="Submit" />
    </p>
    <p>
        &nbsp;</p>
    </form>
</body>
</html>

my code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Text;


namespace manage_logs
{
    public partial class _Default : System.Web.UI.Page
    {
        //StreamReader myReader = new StreamReader("logfile");

          
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
        {

        }

        protected void Calendar1_SelectionChanged(object sender, EventArgs e)
        {
           
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
        

        }

        protected void Calendar2_SelectionChanged(object sender, EventArgs e)
        {

        }

        protected void Button1_Click1(object sender, EventArgs e)
        {
            

        }

        protected void Calendar1_SelectionChanged1(object sender, EventArgs e)
        {

        }
       

    }
}

Edited by __avd: Added [code] tags.

0

i got it the previous problem

Thanks

Edited by rahigoswami: n/a

0

Assuming you want exact dates on the check in time and check out time you can use the following for button1_click

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [Logs] where CheckInTime = @CheckInTime and CheckOutTime = @CheckOutTime", conn);
try
{
using (conn)
{
conn.Open();
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "@CheckInTime";
param1e.SqlDbType = System.Data.SqlDbType.Datetime;
param1.Value = calender1.SelectedDate;
cmd.Parameters.Add(param1);
param2 = new SqlParameter();
param2.ParameterName = "@CheckOutTime";
param2.SqlDbType = System.Data.SqlDbType.Datetime;
param2.Value = calender2.SelectedDate;
cmd.Parameters.Add(param2);
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}

}
catch (Exception ex)
{
Response.Write(ex.Message);
}

}

Edited by __avd: Added [code] tags.

0

hi

it give an error

Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'ASP.viewlog_viewlog_aspx' does not contain a definition for 'Calendar1_SelectionChanged1' and no extension method 'Calendar1_SelectionChanged1' accepting a first argument of type 'ASP.viewlog_viewlog_aspx' could be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 40: SelectCommand="SELECT * FROM [Logs]"></asp:SqlDataSource>
Line 41: </p>
Line 42: <asp:Calendar ID="Calendar1" runat="server"
Line 43:
Line 44: style="z-index: 1; left: 351px; top: 32px; position: absolute; height: 205px; width: 9px"


Source File: c:\Users\Rahul\Documents\Visual Studio 2010\Projects\manage logs\manage logs\ViewLog\ViewLog.aspx Line: 42


Show Detailed Compiler Output:

C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0> "C:\Windows\Microsoft.NET\Framework\v3.5\csc.exe" /t:library /utf8output /R:"C:\Windows\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.WorkflowServices\3.5.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /R:"C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\dc4d45d2\ffce7b0a\assembly\dl3\51530a2a\8c3ac1c2_4005cc01\manage logs.DLL" /R:"C:\Windows\assembly\GAC_MSIL\System.Xml.Linq\3.5.0.0__b77a5c561934e089\System.Xml.Linq.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.ServiceModel.Web\3.5.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Data.DataSetExtensions\3.5.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll" /R:"C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\Windows\assembly\GAC_MSIL\System.Web.Extensions\3.5.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /out:"C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\dc4d45d2\ffce7b0a\App_Web_gise2lye.dll" /D:DEBUG /debug+ /optimize- /w:4 /nowarn:1659;1699;1701 /warnaserror- "C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\dc4d45d2\ffce7b0a\App_Web_gise2lye.0.cs" "C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\dc4d45d2\ffce7b0a\App_Web_gise2lye.1.cs"


Microsoft (R) Visual C# 2008 Compiler version 3.5.30729.4926
for Microsoft (R) .NET Framework version 3.5
Copyright (C) Microsoft Corporation. All rights reserved.

c:\Users\Rahul\Documents\Visual Studio 2010\Projects\manage logs\manage logs\ViewLog\ViewLog.aspx(42,70): error CS1061: 'ASP.viewlog_viewlog_aspx' does not contain a definition for 'Calendar1_SelectionChanged1' and no extension method 'Calendar1_SelectionChanged1' accepting a first argument of type 'ASP.viewlog_viewlog_aspx' could be found (are you missing a using directive or an assembly reference?)
c:\Users\Rahul\Documents\Visual Studio 2010\Projects\manage logs\manage logs\ViewLog\ViewLog.aspx(42,70): error CS1061: 'ASP.viewlog_viewlog_aspx' does not contain a definition for 'Calendar1_SelectionChanged1' and no extension method 'Calendar1_SelectionChanged1' accepting a first argument of type 'ASP.viewlog_viewlog_aspx' could be found (are you missing a using directive or an assembly reference?)
c:\Users\Rahul\Documents\Visual Studio 2010\Projects\manage logs\manage logs\ViewLog\ViewLog.aspx(51,70): error CS1061: 'ASP.viewlog_viewlog_aspx' does not contain a definition for 'Calendar2_SelectionChanged' and no extension method 'Calendar2_SelectionChanged' accepting a first argument of type 'ASP.viewlog_viewlog_aspx' could be found (are you missing a using directive or an assembly reference?)
c:\Users\Rahul\Documents\Visual Studio 2010\Projects\manage logs\manage logs\ViewLog\ViewLog.aspx(51,70): error CS1061: 'ASP.viewlog_viewlog_aspx' does not contain a definition for 'Calendar2_SelectionChanged' and no extension method 'Calendar2_SelectionChanged' accepting a first argument of type 'ASP.viewlog_viewlog_aspx' could be found (are you missing a using directive or an assembly reference?)


Show Complete Compilation Source:

0

i already delete it not showing from the start date to end date.. it shing the whole table

Edited by rahigoswami: n/a

0

Make sure you are also databinding in the page_load again and not using a sqldatasource on the page since that will result in it always showing everything unless you filter it.

0

i wondering about my data type in table for CheckIntime and CheckOuttime i used time(7)
for date i use date is it fine becoz it running but gives error like

"the data types time and datetime are incompatible in the equal to operator"

0

yeah you will want to change the parameter datatype then to time instead of datetime.

0

for both i mean checkIntime Checkout time and date i have to use time datatype

0

yeah when using the parameters in the button1_click method switch the datetypes to time instead of datetime. You can leave the date as date.

0

now it gives error "Failed to convert parameter value from a DateTime to a TimeSpan"

actually i am searching the data according to "date" not "time" like i have a table in which some user "login" into the system on different dates so i want to select the start date and end date from two different calenders and display the data from the start date to the end date according to the date which i selected...

Edited by rahigoswami: n/a

0

now it gives error "Failed to convert parameter value from a DateTime to a TimeSpan"

actually i am searching the data according to "date" not "time" like i have a table in which some user "login" into the system on different dates so i want to select the start date and end date from two different calenders and display the data from the start date to the end date according to the date which i selected

0

Hi Rahi,

After entering the name in the textbox call a AJAX method onblur or onfocus out of the textbox and pass the entered text to the AJAX method and code behind call use webmethod which will connect to DB and Fetchs the Result according to the text. and display the returned recorded in grid or textarea where u want .. If feel any diffuculty in doing this please reply to this i can suggest u more on this

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.