Hi,

The following code shows that I try to pass a 'smalldatetime' data to the
'Today_Date' column when I add a new row to a table. I use the
'DateTimeFormatInfo' object to get the today date but did not know how to
convert to a sql 'smalldatetime'. Thanks for help.

DataSet ds = new DataSet("MyTable");

adapter.Fill(ds, "MyTable");

DataTable tbl = ds.Tables["MyTable];


DataRow row = tbl.NewRow();

row["Today_Date"] = ?; // this column data is a smalldatetime in sql

tbl.Rows.Add(row);

Chi,

= Data.Today ? (or better, set the
MyTable.Columns("Today_Date").DefaultValue = Date.Today are you create the
table)
Having said that, why not just set the default value of your column in the
underlying database (using GetDate())
Then when you insert a new record into the database, don't set a value for
that column. You than won't have any possible errors caused if the date/time
settings on individual users computers are set incorrectly

Stephen

"Chi Tang" <(E-Mail Removed)> wrote in message
news:Op$(E-Mail Removed)...
> Hi,
>
> The following code shows that I try to pass a 'smalldatetime' data to the
> 'Today_Date' column when I add a new row to a table. I use the
> 'DateTimeFormatInfo' object to get the today date but did not know how to
> convert to a sql 'smalldatetime'. Thanks for help.
>
> DataSet ds = new DataSet("MyTable");
>
> adapter.Fill(ds, "MyTable");
>
> DataTable tbl = ds.Tables["MyTable];
>
>
> DataRow row = tbl.NewRow();
>
> row["Today_Date"] = ?; // this column data is a smalldatetime in sql
>
> tbl.Rows.Add(row);
>
>
>
>