windows forms (C#)

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 < dt1)

{

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

}

}

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 

http://www.codeproject.com/Questions/354793/Filter-datagridview-using-datetimepicker

---

If the above solution is helpful then,accept the answer.

---