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.

windows forms (C#)

Answers (3)