22 Kasım 2011 Salı

C# ile MSSQL Query


using System.Data;
using System.Data.SqlClient;

        private void button2_Click(object sender, EventArgs e)
        {
            int YevNo = 17;
            SqlCommand cmd = new SqlCommand("update AnaIslem set Firma = 4 where
                yevmiyeno = @yn", new SqlConnection(@"Data Source=DESTEK1\SQLSERVER;Initial 
                Catalog=Muhasebe;Integrated Security=SSPI;"));
            cmd.Parameters.Add("@yn",YevNo);
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();
            cmd.Connection.Close();
        }

Hiç yorum yok: