ASP.NET

public DataTable GenerateReport( DateTime startDate, DateTime endDate)
        {
            SqlCommand  cmd = new SqlCommand 
            {
                Connection=place your connection string,

               CommandText = "select * from table t where t.age between"+startDate+" and "+endDate
            };

            SqlDataAdapter adapter = new SqlDataAdapter();
            DataTable table = new DataTable();

            adapter.SelectCommand = cmd;

            try
            {
                adapter.Fill(table);
            }             
            catch (Exception ex)
            {
                throw new NPDSException("error in fetching data", ex);
            }
            return table;
        }

ravithejag wrote:

CommandText = "select * from table t where t.age between"+startDate+" and "+endDate

using (var connection = new SqlConnection("connection string here"))
using (var command = new SqlCommand("select * from table where age between @startdate and @enddate", connection))
{
   command.Parameters.AddWithValue("@startdate", startDate);
   command.Parameters.AddWithValue("@enddate", endDate);
   
   var adapter = new SqlDataAdapter(command);
   var table = new DataTable();
   adapter.Fill(table);
   return table;
}

kumar.ranjith.k wrote:

Could you please let me know how can we do this in outlook to get the user mail id.

Varadha Raj wrote:

How to develop window application project in asp.net