how to View policy sales report for Hourly,weekly,monthly 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 Sender,EventArgs 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(mm,OrderedDate)=" + Selected_Month+ "and DATEPart(yyyy,OrderedDate)=" + 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),OrderedDate,103) BETWEENCONVERT(VARCHAR(10),StartDate,103) AND CONVERT(VARCHAR(10),EndDate,103)";

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),EnrollmentDate,103) BETWEEN CONVERT(VARCHAR(10),StartDate,103) AND CONVERT(VARCHAR(10),EndDate,103)"; 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

Answers (5)