filter from two datetimepickers and place on click event

Hi,

These codes help me to have my graph in runtime and works well.

But I have two questions that can be simple for you (not for me because I need to learn) .

1. I am trying two make filter of two datetimepickers from my sql database. But it's doesnt result.

2. I would like to use these code on my button click's event: I do try to put it on a button but its gives error.

SqlConnection conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Flex1\\Flex2\\App_datas\\flex.mdf;Integrated Security = True");

SqlCommand comm;

string connstr = @"Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Flex1\\Flex2\\App_datas\\Flex.mdf;Integrated Security = True";

private void GraficoBarra_Load(object sender, EventArgs e)

{

fillChart();

}

private void fillChart()

{

SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Flex1\\Flex2\\App_datas\\Flex.mdf;Integrated Security=True");

DataSet ds = new DataSet();

con.Open();

SqlDataAdapter adapt = new SqlDataAdapter("select date,name,fonction from company where data between @StartDate and @EndDate '", con);

var param1 = new SqlParameter("@StartDate", SqlDbType.Date);

var param2 = new SqlParameter("@EndDate", SqlDbType.Date);

param1.Value = dateTimePicker1.Value.Date;

param2.Value = dateTimePicker2.Value.Date;

if (dateTimePicker2.Value <= dateTimePicker1.Value)

{

comm.Parameters.Add(param1);

comm.Parameters.Add(param2);

}

else

{

comm.Parameters.Add(param2);

comm.Parameters.Add(param1);

}

adapt.Fill(ds);

Test.DataSource = ds;

Test.Series["Test"].XValueMember = "name";

Test.Series["Test"].YValueMembers = "fonction";

Test.Titles.Add("Report");

con.Close();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
Please consider the following points:
1. Use seperate class to access and execution of sql connection and query respectively, this will not only gives you a cleaner code but also helps in maintainance.

2. The neutral format of datetime in sql is yyyy/MM/dd, as you are passing only date in params (it might uses custom or system defined date format i.e dd/mm/yyyy) which might gives you the error.

Apply the above points and let me know, if it solves your problem
+1