problem with binding date data type to OleDbDataReader
-
in the sql the orderDate DataType is smalldatetime I want to bind this orderDate to OleDbDateReader, but it doesn't work, is there anyone know why? here is my coding: dim OrderDate as Date connecting to sql... query: Select date_order from order DataReader = DataSet.ExecuteReader() Do While DataReader.Read() OrderDate = DataSet.GetDataTime(0) loop txtOrderDate = OrderDate Lisa
-
in the sql the orderDate DataType is smalldatetime I want to bind this orderDate to OleDbDateReader, but it doesn't work, is there anyone know why? here is my coding: dim OrderDate as Date connecting to sql... query: Select date_order from order DataReader = DataSet.ExecuteReader() Do While DataReader.Read() OrderDate = DataSet.GetDataTime(0) loop txtOrderDate = OrderDate Lisa
first think u seen ur code, datset doesnot have executereader ,how u exeute the reader from dataset,use the OledbCommandObjecty for execute reader obviously u can get result rugfy