windows forms (C#)

Question

how to view data in grid view by selecting with date?(sql database c#)

Saillesh Pawar · Answer

protected void btnSearch_Click(object sender EventArgs e) { try { DateTime dt1= DateTime.Parse(txtFrom.Text.Trim() System.Globalization.CultureInfo.CreateSpecificCulture(en-AU).DateTimeFormat); DateTime dt2 = DateTime.Parse(txtTo.Text.Trim() System.Globalization.CultureInfo.CreateSpecificCulture(en-AU).DateTimeFormat); if (dt2 { ShowAlert(To date cannot be less than From date.); return; } else { try { string Parameters = txtFrom.Text.Trim() + | + txtTo.Text.Trim() + | + Convert.ToInt32(Session[UserID])+|+drpUploadList.SelectedValue; objDbC.OpenConnection(); GrdHistory.DataSource = null; GrdHistory.DataBind(); DataSet ds = new DataSet(); ds = objDbC.ByCursor(STOREDPROCEDURENAME Parameters); if (ds.Tables[0].Rows.Count == 0) { ShowAlert(Sorry No data found!); GrdHistory.DataSource = null; GrdHistory.DataBind(); return; } else { GrdHistory.DataSource = ds; GrdHistory.DataBind(); } } catch (Exception ex) { //EXCEPTION MSGz } } } catch (Exception ex) { //EXCEPTION MSGz } }

Krishna Rajput Singh · Answer

Hello Naresh Nannaka thnaks for writing below links i hope helpful for you.. http://www.codeproject.com/Questions/453091/how-to-get-data-from-sql-database-to-gridview-by-c http://www.c-sharpcorner.com/UploadFile/b926a6/insert-data-in-database-using-gridview-control/ if find answer as helpful mark as correct

Rajeev Punhani · Answer

Hi Naresh Please try the below link. http://www.codeproject.com/Questions/354793/Filter-datagridview-using-datetimepicker If the above solution is helpful then accept the answer.