Retrieving Data from a database table using DataGridView

Serign Bah

Hello Everyone,

I have a windows form application where I will enter start-date-time and end-date-time to show result in table, but whenever I run , I have the error below: I am using visual studio 2015

error

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Conversion failed when converting date and/or time from character string."

This is my code :

Properties.Settings.Default.In_OutConnectionString))

{

c.Open();

// 2

// Create new DataAdapter

string textboxValue1 = textBox1.Text.Trim();

string textboxValue2 = textBox2.Text.Trim();

using (SqlDataAdapter a = new SqlDataAdapter(

"SELECT * FROM People_Tracking WHERE Enter_Exit_Time >='textboxValue1' AND Enter_Exit_Time <='textboxValue2'", c))

{

// 3

// Use DataAdapter to fill DataTable

DataTable t = new DataTable() ;

a.Fill(t);

// 4

// Render data onto the screen

dataGridView1.DataSource = t;

}

4 Replies

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

Serign Bah10y ago
@gokul raj I did as suggested, but still the same error:
It only works if i use the dates directly in the query
Here is my DataGridview and Database Table:
Gokulraj Sankar10y ago
hi,
use the below one.
textboxValue1.ToString("yyyy-MM-dd HH:mm:ss");

textboxValue2.ToString("yyyy-MM-dd HH:mm:ss");
Serign Bah10y ago
@gokul raj I did as suggested, but still the same error:

the error points to this part of the code:

DataTable t = new DataTable() ;
a.Fill(t);
Gokulraj Sankar10y ago
hi,
modify your sql query like.
SELECT * FROM People_Tracking WHERE Enter_Exit_Time >=
CONVERT(datetime,'textboxValue1')
'' AND Enter_Exit_Time <=
CONVERT(datetime,'textboxValue2')

thanks