23 Ağustos 2013 Cuma

How to delete 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("DELETE FROM Employees WHERE EmployeeID = @CalisanID", cnn); cmd.Parameters.AddWithValue("@CalisanID", textBox1.Text); cmd.ExecuteNonQuery(); cnn.Close(); }

Hiç yorum yok:

Yorum Gönder