Save data in DB in asp.net mvc without entity framework?

Here what i want to do exactly, i am using connection string to attempt this and have this logic below. Somehow i am beginning to get stuck in the middle.

private SqlConnection con;
// private method for connection.
private void connection()
{
string constr = ConfigurationManager.ConnectionStrings["DefConnection"].ToString();
con = new SqlConnection(constr);
}
//GET:/Manage/AddNewDetails.
public ActionResult AddNewDetails()
{
return View();
}
//POST://Manage to add-new-details.
[HttpPost]
public ActionResult AdAddNewDetails(EditTrainingRegFormViewModel model)
{
// logic here.
return View();
}
// Model class
public class EditTrainingRegFormViewModel
{
public string Title { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Position { get; set; }
public string Company { get; set; }
public string Address { get; set; }
[Display(Name = "Choose country")]
public int? SelectedCountryId { get; set; }
[Required]
[RegularExpression(@"^[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,}$")]
[Display(Name= "Postal/Zip Code")]
public string Code { get; set; }
[DataType(DataType.Text)]
[Required(ErrorMessage = "This field is required")]
public string City { get; set; }
public string State { get; set; }
[Required(ErrorMessage = "This field is required")]
public string Cell_Number { get; set; }
public List Dietary_requirement = new List();
[Required(ErrorMessage ="This field is required")]
[EmailAddress(ErrorMessage ="Enter correct email")]
[RegularExpression(@"^[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,}$")]
public string Email { get; set; }
public int Country_Id { get; set; }
public string Country_Name { get; set; }
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel6y ago
Hi,

refer this
https://www.c-sharpcorner.com/UploadFile/0c1bb2/insertupdatedelete-in-Asp-Net-mvc-5-using-ado-net/
https://www.c-sharpcorner.com/UploadFile/francissvk/crud-operations-in-Asp-Net-mvc-using-ado-net/
0
Guest User6y ago
Here what i want to do exactly, i am using connection string to attempt this and have this logic below. Somehow i am beginning to get stuck in the middle.
private SqlConnection con;


   // private method for connection.
        private void connection()
        {
            string constr = ConfigurationManager.ConnectionStrings["DefConnection"].ToString();
            con = new SqlConnection(constr);
        }



        //GET:/Manage/AddNewDetails.
        public ActionResult AddNewDetails()
        {
            return View();
        }


        //POST://Manage to add-new-details.
        [HttpPost]
        public ActionResult AdAddNewDetails(EditTrainingRegFormViewModel model)
        {
           // logic here.


            return View();
        }

// Model class
public class EditTrainingRegFormViewModel
    {
        public string Title { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Position { get; set; }

        public string Company { get; set; }

        public string Address { get; set; }

        [Display(Name = "Choose country")]
        public int? SelectedCountryId { get; set; }

       [Required]
       [RegularExpression(@"^[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,}$")]
       [Display(Name= "Postal/Zip Code")]
        public string Code { get; set; }

        [DataType(DataType.Text)]
        [Required(ErrorMessage = "This field is required")]
        public string City { get; set; }

        public string State { get; set; }


        [Required(ErrorMessage = "This field is required")]
        public string Cell_Number { get; set; }

        public List Dietary_requirement = new List();

        [Required(ErrorMessage ="This field is required")]
        [EmailAddress(ErrorMessage ="Enter correct email")]
        [RegularExpression(@"^[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,}$")]
        public string Email { get; set; }

        public int Country_Id { get; set; }

        public string Country_Name { get; set; }


}
0
Mario Scheeren6y ago
Take a look at this here: https://dapper-tutorial.net/dapper
0