How to fetch data....???

Question

how to fetch fields in mvc using ado.net in class and controller....

Upendra Pratap Shahi · Answer

Kindly go to above code, this is very easy.

Mohd Nawaz Khan · Answer

Thanx Buddy its very helpfull to me.... :-)

Shuvojit Halder · Answer

This code will help you some.    Model class   public class FrontPageCampaign { public List ADMIN_BANNER_IMAGE { get; set; } public string ADMIN_VEDIO_LINK { get; set; } public bool? BANNER_IMAGE { get; set; } public string STATUS { get; set; } public Nullable CREATED_BY { get; set; } public string NAME { get; set; } public string VEDIO_LINK { get; set; } public string USER_NAME { get; set; } public string CAMPAIGN_LOCATION { get; set; } public string CAMPAIGN_SHORT_DESCRIPTION { get; set; } public string ENDSOON { get; set; } public Nullable CAMPAIGN_GOAL_AMMOUNT { get; set; } public string CAMPAIGN_DESCRIPTIONS { get; set; } public string CURRENSY_SYMBOL { get; set; } public Nullable DAYLEFT { get; set; } public int? DAYSP { get; set; } public string CAMPAIGN_CREATION_COUNTRY { get; set; } public List TOTAL_LIKE { get; set; } public List TOTAL_RATING { get; set; } public Nullable TOTAL_COMMENTS { get; set; } public Nullable SHARE { get; set; } public Nullable TOTAL_EMAIL { get; set; } public Nullable IS_FETURED { get; set; } public Nullable IS_RUNNING { get; set; } public Nullable IS_COMPLETE { get; set; } public string CATEGORY_NAME { get; set; } public string CATEGORY_IMG { get; set; } public Nullable AVGS { get; set; } public Nullable AMMOUNT { get; set; } public Nullable CONTRIBUTED_DATE { get; set; } public Nullable countView { get; set; } public Nullable CAT_ID { get; set; } public long CAM_DETAILS_ID { get; set; } public string CAMPAIGN_TITLE { get; set; } public Nullable CAMPAIGN_PUBLISHED_DATE { get; set; } public Nullable CAMPAIGN_COLLECTION_DATE { get; set; } public Nullable CAMPAIGN_APPROVED_DATE { get; set; } public Nullable MARK_AS_FEATURED_DATE { get; set; } public string CAMPAIGN_TITLE_IMAGE { get; set; } public Nullable IS_DRAFT { get; set; } public Nullable PLANTYPE { get; set; } public Nullable CAMPAIGN_PLAN_AND_PRICE_ID { get; set; } public string CAMPAIGN_LOGO_IMAGE { get; set; } public IList _TeamMember { get; set; } public int TOTAL_RUNNING_CAMPAIGN { get; set; } public int TOTAL_CREATE_CAMPAIGN { get; set; } public int TOTAL_COMPLETE_CAMPAIGN { get; set; } public int TOTAL_CONTRIBUTION { get; set; } public int TOTAL_SPONSORES { get; set; } } //-----------------Dal class   public FrontPageCampaign CampaignRunning() { yourentity _DB=new  yourentity(); FrontPageCampaign _RunningCamp; _RunningCamp = _DB.SP_RUNNINGCAMPAIGN().Select(x => new FrontPageCampaign { AMMOUNT = x.AMMOUNT, AVGS = x.AVGS, CAM_DETAILS_ID = x.CAM_DETAILS_ID, CAMPAIGN_APPROVED_DATE = x.CAMPAIGN_APPROVED_DATE, CAMPAIGN_CREATION_COUNTRY = x.CAMPAIGN_CREATION_COUNTRY, CAMPAIGN_DESCRIPTIONS = x.CAMPAIGN_DESCRIPTIONS, CAMPAIGN_GOAL_AMMOUNT = x.CAMPAIGN_GOAL_AMMOUNT, CAMPAIGN_LOCATION = x.CAMPAIGN_LOCATION, CAMPAIGN_LOGO_IMAGE = x.CAMPAIGN_LOGO_IMAGE, CAMPAIGN_PLAN_AND_PRICE_ID = x.CAMPAIGN_PLAN_AND_PRICE_ID, CAMPAIGN_PUBLISHED_DATE = x.CAMPAIGN_PUBLISHED_DATE, CAMPAIGN_SHORT_DESCRIPTION = x.CAMPAIGN_SHORT_DESCRIPTION, CAMPAIGN_TITLE = x.CAMPAIGN_TITLE, CAMPAIGN_TITLE_IMAGE = x.CAMPAIGN_TITLE_IMAGE, CAT_ID = x.CAT_ID, CATEGORY_IMG = x.CATEGORY_IMG, CATEGORY_NAME = x.CATEGORY_NAME, CONTRIBUTED_DATE = x.CONTRIBUTED_DATE, countView = x.countView, DAYLEFT = x.DAYLEFT, IS_COMPLETE = x.IS_COMPLETE, IS_DRAFT = x.IS_DRAFT, IS_FETURED = x.IS_FETURED, IS_RUNNING = x.IS_RUNNING, MARK_AS_FEATURED_DATE = x.MARK_AS_FEATURED_DATE, NAME = x.NAME, PLANTYPE = x.PLANTYPE, SHARE = x.SHARE, }).FirstOrDefault(); return _RunningCamp; }     //------------------------Controller------------------------------    public actionresult getrecord() {  FrontPageCampaign _model=new  FrontPageCampaign();  _model=dalclassobject.CampaignRunning(); return view(_model);  }