🙂 İNSANLARIN EN HAYIRLISI INSANLARA FAYDALI OLANDIR 🙂

Ramazan HABER / C# Athena / ÇOKTAN SEÇMELİ SQL İN YAPMA

 

1-) C# Athena -  ÇOKTAN SEÇMELİ SQL İN YAPMA

 

1-)ÇOKTAN SEÇMELİ SQL İN YAPMA

string W_sicilnum=""

string[] W_psicil;

private void MyGetDateSicilWork() {

W_sicilnum=null;

                W_sicilnum="";

if (!W_PSICIL_ID_RAPOR.Text.ToString().Equals("")) {

                    W_psicil = W_PSICIL_ID_RAPOR.Text.ToString().Split(',');

                    for (int i = 0; i < W_psicil.Length; i++) {

                        W_sicilnum = W_sicilnum + "'" + W_psicil[i] + "',";

                    }

                    if (W_sicilnum.Contains(",")) {

                        W_sicilnum = W_sicilnum.Substring(0, W_sicilnum.LastIndexOf(","));

                    }

                }}

 

2-) UYGULARKEN

 

string W_sicil = "AND PSICIL_NUM in(" + W_sicilnum + ") ";

 2021 Ocak 18 Pazartesi
 446