You haven't asked a single question. It's a set of many questions. Please check following breakdown of your question to simple questions and link to the solution.
1. How to retrieve data from MYSQL using C#?
Reference:
Retrieving Data From a MySQL Database[
^]
Connecting to MySQL Database using C# and .NET[
^]
2. How to filter MySQL data between the dates selected in datepicker?
Just add a correct WHERE clause to your SELECT query. Something like-
"WHERE yourDateColumn >='"+dateTimePicker1.Value.ToString("yyyy-MM-dd")+" 00:00:00"+"' AND yourDateColumn <='"+dateTimePicker2.Value.ToString("yyyy-MM-dd")+" 23:59:59"+"'"
3. How to create PDF using iTextSharp?
Reference:
Export DataSet or DataTable to Word Excel PDF and CSV Formats[
^]
Basic PDF Creation Using iTextSharp[
^]
Note: Don't use inline queries which are vulnerable to SQL Injection. I have used these to make the answer simple to understand. Use Parameterized query or Stored Procedure to avoid SQL Injection.
Hope, it helps :)