How Do I insert Data in a table From the Model MVC?

Posted by user54197 on Stack Overflow See other posts from Stack Overflow or by user54197
Published on 2010-04-01T20:27:21Z Indexed on 2010/04/02 9:43 UTC
Read the original article Hit count: 276

Filed under:
|
|

I have data coming into my Model, how do I setup to insert the data in a table?

    public string Name { get; set; }
    public string Address { get; set; }
    public string City { get; set; }
    public string State { get; set; }
    public string Zip { get; set; }

    public Info()
    {
        using (SqlConnection connect = new SqlConnection(connections))
        {
            string query = "Insert Into Personnel_Data (Name, StreetAddress, City, State, Zip, HomePhone, WorkPhone)" +
                "Values('" + Name + "','" + Address + "','" + City + "','" + State + "','" + Zip + "','" + ContactHPhone + "','" + ContactWPhone + "')";

            SqlCommand command = new SqlCommand(query, connect);
            connect.Open();
            command.ExecuteNonQuery();
        }
    }

The Name, Address, City, and so on is null when the query is being run. How do I set this up?

© Stack Overflow or respective owner

Related posts about c#

Related posts about asp.net-mvc