I know this thread have been posted before, but i can't find my solution in it.
Server side:
Expand|Select|Wrap|Line Numbers
- [WebMethod]
- public DataSet getIndustryDatePostedAnnouncement()
- {
- SqlConnection con = new SqlConnection("server = localhost;Integrated Security = True;database = MPMP");
- SqlDataAdapter daAnn = new SqlDataAdapter("SELECT MPAnnouncement.date_posted FROM MPAnnouncement WHERE (MPAnnouncement.display_to = 'Industry') OR (MPAnnouncement.display_to = 'All') OR (MPAnnouncement.display_to LIKE '%I%')", con);
- DataSet ds = new DataSet();
- con.Open();
- daAnn.Fill(ds, "Ann");
- con.Close();
- return ds;
- }
I wish to embed the webemethod to a label that is in a table. And i know having a dataset will have more than one value returned. So what i wanted to do is to duplicate the number of record to the number of table.
Thanks