Hi all, i customizing one application and i dont have much time to re-develop it .
Now problem is that there is one field in database : MessageDate whose data type is nvarchar(25), now i want to fetch data between two dates how could i do this.
i use to get error: string is not recognized as valid datetime:
try
{
sqlConn.Close();
SqlCommand sqlComm = new SqlCommand();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlComm.CommandType = CommandType.Text;
sqlComm.CommandText = "Select MessageID,ChannelNo,ExtensionNo,MessageFileName,MessageDate,MessageTime,CallerId,InOutFlag,PlayPath,Size from MessageTransaction where MessageDate b ...
Go to the complete details ...