how to format data on dataset

bishnupokhrel · March 21st, 2007, 03:23 AM

Hi All,

I have following function.

public Dataset getdataset(string strSQLStatement,string ConnectionString, string dateFormat)
{
  DataSet ds;
   SqlDataAdapter oDA ;
   oDA = new SqlDataAdapter(strSQLStatement,ConnectionString);
    oDA.Fill(ds);
    // perform date/time/number formatting
  return ds;

}

Is there any operation? by which data on dataset will be formatted as the format mentioned by user, like date fields gets formatted to
dd-mm-yyyy, no matter how it is saved on server.

thx in advance.

Regards
Bishnu Pokharel
[email protected]
http://www.bishnupokharel.com.np/