search records between dates usnig cmg.parameters.

See more:

C#2.0

C#3.0

C#

ASP

ASP.NET

ADO

, +

I want to search date using

cmd.Parameters.add 

i have one column for date time
here i can serach for single date . i want in between dates .

SqlCommand cmd = new SqlCommand("SELECT report_type,count (report_type) as Count1 FROM Transactions where   dateadd(dd, datediff(dd,0, [R_date]), 0) =@R_date group by report_type");
cmd.Connection = con;
cmd.Parameters.Add("@R_date", SqlDbType.DateTime).Value = dtime.Date;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();