Insert data from textbox to mdf-database. (c#)
protected void Button1_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True")) { SqlCommand CmdSql = new SqlCommand("INSERT INTO [Movies] (ID, Name, Genre, Length, Year, Description) VALUES (@ID, @Name, @Genre, @Length, @Year, @Description)", conn); conn.Open(); CmdSql.Parameters.AddWithValue("@ID", TextBox1.Text); CmdSql.Parameters.AddWithValue("@Name", TextBox2.Text); CmdSql.Parameters.AddWithValue("@Genre", TextBox3.Text); CmdSql.Parameters.AddWithValue("@Length", TextBox4.Text); CmdSql.Parameters.AddWithValue("@Year", TextBox5.Text); CmdSql.Parameters.AddWithValue("@Description", TextBox6.Text); CmdSql.ExecuteNonQuery(); conn.Close(); } }
No comments:
Post a Comment