how to search between two date range

Hi Jaya,

 

Your code looks mostly correct. However, there are a few minor things you could improve.

Firstly, instead of using varchar(1000) for startdate and enddate, you should use date or datetime data types. This will allow you to use the BETWEEN operator directly on the date values without having to worry about string formatting issues.

Here's the updated CREATE TABLE statement with the date columns changed to datetime data type:

CREATE TABLE gridview (
    id bigint identity(1,1),
    name varchar(65),
    startdate datetime,
    enddate datetime,
    gender char(25),
    mobileno bigint,
    designition varchar(100),
    country nvarchar(65),
    state nvarchar(65),
    city nvarchar(65)
);

Next, it's a good practice to explicitly specify the columns you want to select from the table instead of using SELECT *. This can improve query performance and reduce network traffic.

Here's the updated stored procedure code:

CREATE PROCEDURE sp_SearchCustomerDetailsByDate
    @StartDate datetime,
    @EndDate datetime
AS
BEGIN
    SELECT id, name, startdate, enddate, gender, mobileno, designition, country, state, city
    FROM gridview 
    WHERE startdate BETWEEN @StartDate AND @EndDate
END

Finally, when passing the date values to the stored procedure, you should convert them to DateTime objects instead of passing them as strings. You can use DateTime.Parse or DateTime.TryParse to do this.

Here's the updated GetDate method:
 

private DataTable GetDate(string fromdate, string enddate)
{
    DateTime startDate;
    DateTime endDate;
    if (!DateTime.TryParse(fromdate, out startDate) || !DateTime.TryParse(enddate, out endDate))
    {
        // Handle invalid date inputs here
        return new DataTable();
    }

    using (SqlCommand cmd = new SqlCommand("sp_SearchCustomerDetailsByDate", con))
    {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@StartDate", startDate);
        cmd.Parameters.AddWithValue("@EndDate", endDate);
        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
        {
            DataTable dt = new DataTable();
            da.Fill(dt);
            return dt;
        }
    }
}

With these changes, your code should work as expected.