save data in view using store procedure

Guest User

Hi Team

I have a form with field names, i have created store procedure with table field name. I want my form to save these details to the table name. How do i create save functionality without using entity framework? Only store procedure with Configuration.Manager("Connection-Name);

3 Replies

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

Jaimin Shethiya6y ago
Hello Gcobani,

can you please try a below code for insert a data using SP to database

SqlConnection conn = new SqlConnection("connection String");
conn.Open();
using (SqlCommand command = new SqlCommand("store procedure name", conn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@param1", System.Data.SqlDbType.Int);
command.Parameters["@param1"].Value = Convert.ToInt32(param1Value);
...
...
...
command.ExecuteNonQuery();
}
conn.Close();
Thanks.
Jignesh Kumar6y ago
Hi,
Please use this link which will resolve your query,

https://www.c-sharpcorner.com/UploadFile/4d9083/creating-insert-update-and-delete-application-in-mvc-4-using/

https://www.completecsharptutorial.com/mvc-articles/insert-update-delete-in-asp-net-mvc-5-without-entity-framework.php
Rajanikant Hawaldar6y ago
Hello go through below articles https://forums.asp.net/t/2129520.aspx?How+to+save+data+from+a+view+using+stored+procedure https://www.c-sharpcorner.com/uploadfile/01fc26/how-to-use-stored-procedure-in-simple-easy-way-with-web-config-file/ https://www.c-sharpcorner.com/uploadfile/puranindia/inserting-records-in-a-database-using-stored-procedure-and-ado-net-technology/