23 Ağustos 2013 Cuma

How to insert data C# to SQL via ADO.NET

using System.Data.SqlClient; SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"); private void button1_Click(object sender, EventArgs e) { cnn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO Employees (FirstName, LastName) VALUES (@CalisanAdi, @CalisanSoyadi)", cnn); cmd.Parameters.AddWithValue("@CalisanAdi", textBox1.Text); cmd.Parameters.AddWithValue("@CalisanSoyadi", textBox2.Text); cmd.ExecuteNonQuery(); cnn.Close(); }

Hiç yorum yok:

Yorum Gönder