date time
-
Hi, I'm working on vb. net and sql server... I have a table called "rproduct" which has 2 fields declared as 'datetime' namely for "date received" and "time received". I'm using datagrid in vb .net to view the table data and also to modify and update etc. The problem was that I wasnt able to view only time and only date in the respective fields, instead I used to get 'date and time' in both the fields. So what I did is something like this select substring(cast(dater as varchar),0,13), substring(cast(timeR as varchar),14, 20) from rproduct and I set respective column in dataset's .xsd file as 'string' so that I can c the only date in "date received" field and just time in "time received" field. But now the problem is I dont know how can I save the changes made in these fields back to database??? shatru2k