Hi,

Does anybody know where I can get some samples to pass C# data to sql data?
For example, I need to pass some date data to a sql 'smalldatatime' data but
I did not know how. Thanks,

CT

Chi,

Can you post the code that isn't working for you?

There are samples in the quick starts

Kathleen


"Chi Tang" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi,
>
> Does anybody know where I can get some samples to pass C# data to sql
data?
> For example, I need to pass some date data to a sql 'smalldatatime' data
but
> I did not know how. Thanks,
>
> CT
>
>

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);







"Kathleen Dollard" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Chi,
>
> Can you post the code that isn't working for you?
>
> There are samples in the quick starts
>
> Kathleen
>
>
> "Chi Tang" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> > Hi,
> >
> > Does anybody know where I can get some samples to pass C# data to sql
> data?
> > For example, I need to pass some date data to a sql 'smalldatatime' data
> but
> > I did not know how. Thanks,
> >
> > CT
> >
> >
>
>