set dateformat dmy Go select * from Table where Pdate=select Datepart(Day,'12/10/2007') and PMonth=Datepart(Month,'12/10/2007') and PYear=Datepart(Year,'12/10/2007')
What exactly you want to know? These things are quite correct. Dataset follows a disconnected architecture. Once you get the data from the database you are disconnected. If you again want to update the dataset with the database you again need to get connected and update it. Here[^] you will get the details of ado.net architecture.
Best Regards, Apurva Kaushal
