Click here to Skip to main content
15,887,944 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI

iam working on the accordian control, i am getting the data dynamically by using this

here i am getting the data into dataset by using dataadapter query

like

con = new MySqlConnection(ConfigurationManager.ConnectionStrings["XXXXX"].ConnectionString);
           MySqlCommand cmd = new MySqlCommand("select ticketno,status,clientname,mobileno,reson,raiseddata,organizationname,raisedperson,departmentname,DATE_FORMAT(DATE(date),'%d/%m/%Y %T') as date,DATE_FORMAT(DATE(updateddate),'%d/%m/%y %T') as updateddate from raiseticket", con);
           MySqlDataAdapter da = new MySqlDataAdapter(cmd);
           DataSet ds = new DataSet();
           da.Fill(ds, "raiseticket");

sample code

<asp:Label ID="Label5" runat="server" Text= <%#Eval("ticketno")%>></asp:Label>
<asp:Label ID="Label5" runat="server" Text= <%#Eval("data")%>></asp:Label>


upto now everything is fine right now, in my database i had the date in unixtime so i need to convert this date in to general formate, how can do that this is large data so i cannot the method a and keeping the while loop using datareader,

can i do this in the dynamicall into the accordian

please help me
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900