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