Get all textbox values and save in database using MVC

Hi All,

Get all textbox values from the table and store it in database using ASP.Net MVC?

Get all the textbox values from the table via foreach and process it in viewbag and store all values it in database using asp.net mvc..

if there's any solution or answer or link please let me know it..

Hi,

Simply you can do that.

string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand("Insert_Customers"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@tblCustomers", dt);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}

inside this procedure insert @tblCustomers data into main table

store procedure.

Take the reference form below link and implement it in MVC because login is the same. data into main table

3 Replies

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

Sourav Kumar Das7y ago
Hi All,

Is there any solution or answer for my above question...?
Sourav Kumar Das7y ago
Hi Amit & All,

I Need solution or answer for the above question in ASP.Net MVC.
Amit Kumar7y ago
Hi,
Simply you can do that.
string consString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(consString))
        {
            using (SqlCommand cmd = new SqlCommand("Insert_Customers"))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection = con;
                cmd.Parameters.AddWithValue("@tblCustomers", dt);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
inside this procedure insert @tblCustomers data into main table
store procedure.
CREATE PROCEDURE Insert_Customers
   (@tblCustomers  tblCustomers)
AS
BEGIN
    INSERT INTO SmallTable(C1, C2, C3) --- Columns of smaller table
        SELECT C1, C2, C3 ---Columns of Master table
        FROM MasterTable

END
Take the reference form below link and implement it in MVC because login is the same. data into main table