23 Ağustos 2013 Cuma
How to use Datareader on C# via ADO.NET
using System.Data.SqlClient;
SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;");
cnn.Open();
SqlCommand cmd = new SqlCommand("SELECT FirstName,LastName FROM Employees WHERE EmployeeID = 1", cnn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
textBox1.Text = dr.GetString(0);
textBox2.Text = dr.GetString(1);
}
}
cnn.Close();
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();
}
How to update 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("UPDATE Employees SET FirstName = @CalisanAdi,LastName = @CalisanSoyadi WHERE EmployeeID = 1", cnn);
cmd.Parameters.AddWithValue("@CalisanAdi", textBox1.Text);
cmd.Parameters.AddWithValue("@CalisanSoyadi", textBox2.Text);
cmd.ExecuteNonQuery();
cnn.Close();
}
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ıtlar (Atom)