1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
// Chaîne de connexion
string connectString = @"Data Source=RENNDXPRDL2596\SQLEXPRESS;Initial Catalog=hafid;Integrated Security=True";
// Objet connection
SqlConnection connection = new SqlConnection(connectString);
// Ouverture
connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO [table_test]([ID_tst],[1],[2],[3]) VALUES(@ID_tst,@1,@2....connection);
// Paramètre
command.Parameters.Add(new SqlParameter("@ID_tst", SqlDbType.NVarChar, 50));
command.Parameters.Add(new SqlParameter("@1", SqlDbType.Float))
command.Parameters.Add(new SqlParameter("@2", SqlDbType.Float))
command.Parameters["@ID_tst"].Value = double.Parse(textBox_tst.Text, System.Globalization.CultureInfo.InvariantCulture);
command.Parameters["@ID_1"].Value = double.Parse(textBox_1.Text, System.Globalization.CultureInfo.InvariantCulture);
command.Parameters["@ID_2"].Value = double.Parse(textBox_2.Text, System.Globalization.CultureInfo.InvariantCulture); |
Partager