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); }