Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/uy/public_html/wp-includes/functions.php on line 6121
C# sql class da parametre kullanımı – Umut Yazılım - Ümit AYDIN

C# sql class da parametre kullanımı

C# sql class da parametre kullanımı

C# sql veritabanı işlemlerinde db class a sql parametreli gönderme örneği.

public static SqlDataReader GetDataReaderParametreli(string sorgu, params SqlParameter[] parameter)
{
Baglan();
SqlCommand cmd = new SqlCommand(sorgu, conn);
cmd.Parameters.AddRange(parameter);
SqlDataReader dr = cmd.ExecuteReader();
//BaglantiKapa();
return dr;  
}     
 //KULLANIMI kod tarafı
        //string sql = "select * from Umt_062_Markalar WHERE MARKA=@MARKA";
        //SqlParameter[] parameter = new SqlParameter[1];
        //parameter[0] = new SqlParameter("@MARKA", "VALEO");
        //// parameter[1] = new SqlParameter("@Password", txt_password.Text);
        //SqlDataReader dr = SqlClass.GetDataReaderParametreli(sql, parameter);

        //if (dr.Read())
        //{
        //    string AA = dr[0].ToString();
        //}
    }

Bir yanıt yazın

E-posta adresiniz yayınlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir