Hi
A problem is - how can I make that statement correct? - I would like to
SELECT somenthink like that:

String *SQLstatement = String::Format(S" SELECT * FROM Table WHERE Date =
{0}", DateTimePicker1->Value->ToShortDateString() );

There is a String statement (*SQLstatement) so I concatenate DateTimePicker1
value as string value too. But I've got an "incorrect data type error". Is
there any
solution to make this cnvertion clear - maybe using any SQL finction inside
string?.

[Access file - "Date" column type: DateTime, oleDbDataAdapter]
Good day, thanks for wrote.

[quoted text, click to view]

I would suggest not doing that in the first place. Use parameters
instead, and you don't need to do any conversion yourself.

--
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet

This is a short (untested) example of how to use parameters (in C#):

string connectionString = "...";
SqlConnection cn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM Table WHERE Date =
@dtDate", cn);

SqlParameter param = new SqlParameter("@dtDate", SqlDbType.DateTime, 8);
param.Direction = ParameterDirection.Input;
param.Value = new DateTime(2004, 1, 1);
cmd.Parameters.Add(param);

cn.Open();
using (SqlDataReader reader =
cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
for (; reader.Read(); )
{
// Do stuff
}
}

HTH, Jakob.


[quoted text, click to view]