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();
}
Kaydol:
Kayıt Yorumları (Atom)
Hiç yorum yok:
Yorum Gönder