Not preserving time format while exporing to excel

Question

Hi All ,

I tried to export XML data to excel using datasets which includes one column of 24 hr format time in my table .
Now when it is exported to excel it is displaying in 12 hr format .I want to preserve the 24 hr format.

Please suggest me the solution .

Answer 1

it shows me this error : localhost.SqlParameter does not contain a constructor that takes 2 arguments

 

in

param[0] = new localhost.SqlParameter("KeyWord", b[1].ToString());

this line...

 

 

Answer 2

Hi u can try like this

 

localhost.SqlParameter[] param = new localhost.SqlParameter[2];

param[0] = new localhost.SqlParameter("KeyWord", "Testing");

param[1] = new localhost.SqlParameter("PageSize", 20);

var objGetDetail = Obj1.GetDetail("SP_Related", param).Tables[0];