problemer med datetime fra mssql
Jeg får denne fejl når jeg kompilerSystem.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime
min kode er som følger:
protected void MonthLyEvents(DateTime d1,DateTime d2)
{
string sql,Query;
sql = "SELECT EventDateBeg,EventName FROM aEvents WHERE EventDateBeg BETWEEN '{0}' And '{1}' ORDER BY EventDateBeg";
Query = String.Format(sql,d1.ToString(),d2.ToString());
SqlConnection m_SqlConnection = new SqlConnection(CDb.DsnEvents);
SqlDataAdapter m_SqlDataAdapter = new SqlDataAdapter(Query,m_SqlConnection);
try
{
DataSet Ds = new DataSet();
m_SqlDataAdapter.Fill(Ds,"Events");
eventTable = Ds.Tables["Events"];
}
catch (Exception e)
{
throw new Exception("Error in MonthLyEvents-> " + e.ToString());
}
finally
{
m_SqlConnection.Close();
m_SqlDataAdapter.Dispose();
}
}
Nogen der ved det skyldes?
Database tabellen er tom
