how to View policy sales report for Hourlyweeklymonthly an

Question

i have date column. but i dono how to do this ..

Pankaj Rawat · Answer

Here i assume that you have a field of DateTime Datatype in your database table. in Code Behind :- /* For Selected Month */ Protected Void BtnSearch_Click(Object SenderEventArgs e) { int Selected_Month=Convert.ToInt32(DDl_Months.SelectedValue); int Selected_Year=Convert.ToInt32(DDl_Year.SelectedValue); DataTable dtObj = new DataTable(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ApplicationServices].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = Select * from Order_Detail where DATEPart(mmOrderedDate)= + Selected_Month+ and DATEPart(yyyyOrderedDate)= + Selected_Year; SqlDataReader reader = cmd.ExecuteReader(); dtObj.Load(reader); conn.Close(); } if(dtObj.Rows.Count>0) { /* Bind Your Data to Grid */ Gridview1.Datasource=dtObj.DefaultView; Gridview1.Databind(); } } Similarly if you have to Find Records on annually basis. you can pass only year value in the above Query. To Find The record for Weekly basis you must have a Start_Date and End_Date. in that situation your query will be cmd.CommandText = SELECT * FROM Order_Detail WHERE CONVERT(VARCHAR(10)OrderedDate103) BETWEENCONVERT(VARCHAR(10)StartDate103) AND CONVERT(VARCHAR(10)EndDate103);

Pankaj Rawat · Answer

DateTime DT_StartDate; Try { DT_StartDate=Convert.ToDateTime(dropdownlist1.SelectedItem.Text); }Catch{}

dhivya pm · Answer

i am retrieving Date from dapdownlist

Pankaj Rawat · Answer

Can you tell me what exactly are you retrieving from dropdown. Is it month or date.

dhivya pm · Answer

Getting Error for Weekly report Input string was not in a correct format. error: int StartDate = Convert.ToInt32(DropDownList1.SelectedValue); protected void Button3_Click(object sender EventArgs e) { int StartDate = Convert.ToInt32(DropDownList1.SelectedValue); int EndDate = Convert.ToInt32(DropDownList2.SelectedValue); DataTable dtObj = new DataTable(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ApplicationServices].ConnectionString)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = SELECT * FROM ApplyPolicy where CONVERT(VARCHAR(10)EnrollmentDate103) BETWEEN CONVERT(VARCHAR(10)StartDate103) AND CONVERT(VARCHAR(10)EndDate103); SqlDataReader reader = cmd.ExecuteReader(); dtObj.Load(reader); conn.Close(); } if (dtObj.Rows.Count > 0) { /* Bind Your Data to Grid */ GridView1.DataSource = dtObj.DefaultView; GridView1.DataBind(); } }

how to View policy sales report for Hourly,weekly,monthly an