Advertisement
Guest User

Select

a guest
Oct 9th, 2015
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.91 KB | None | 0 0
  1.            
  2.            
  3.             string strCampaignQuery = "SELECT  FROM ";
  4.             dbMan.parameterDelete();
  5.             dbMan.AddParameterValue("adminID", id);
  6.             DataTable campaign = dbMan.GetDataSet(strCampaignQuery).Tables[0];
  7.  
  8.             List<Campaigns> campaignsList = new List<Campaigns>();
  9.  
  10.             foreach (DataRow item in campaign.Rows)
  11.             {
  12.                 Campaigns t = new Campaigns
  13.                 {
  14.                     Campaign_ID = Convert.ToInt32(item["Campaign_ID"]),
  15.                     Campaign_Name = item["Campaign_Name"].ToString(),
  16.                     Campaign_Begin_Date = Convert.ToDateTime(item["Campaign_Begin_Date"]),
  17.                     Campaign_End_Date = Convert.ToDateTime(item["Campaign_End_Date"])                
  18.                 };
  19.                 campaignsList.Add(t);
  20.             }
  21.             return new JavaScriptSerializer().Serialize(campaignsList);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement