mardi 14 juin 2016

query with variables c#

I have int ID in my form load function, and while loading i want datagridview to fill with data where someColumn like '%?@ID%', but when i write it like this it doesn't work. Explain to me how it need to be done.

Here is load code:

    private void PopisnaLista_Load(object sender, EventArgs e)
    {
        // TODO: This line of code loads data into the 'dataSet1.ROBA' table. You can move, or remove it, as needed.
        this.rOBATableAdapter.Fill(this.dataSet1.ROBA);
        try
        {
            this.rOBATableAdapter.FillBy(this.dataSet1.ROBA);
        }
        catch (System.Exception ex)
        {
            System.Windows.Forms.MessageBox.Show(ex.Message);
        }
    }

Here is query for FillBy

SELECT        ROBAID, KATBR, KATBRPRO, NAZIV, VRSTA, AKTIVNA, GRUPAID, PODGRUPA, PROID, JM, TARIFAID, NABAVNACENA, PRODAJNACENA, DEVNABCENA, FABRCENA, STANJE, NARUCENO, REZERVISANO, 
                         STANJEPOOTP, TAKSA, MARZA, UVOZ, TARBROJ, AKCIZA, NAZIVZACARINU, NAZIVNAENG, GARANTID, ALTJM, ALTKOL, ALTNEDELJIVA, TRPAK, TRKOL, JMSD, KOMENTAR, XOD, XDO, YOD, YDO, ZOD, ZDO, 
                         IMAROKTRAJANJA, NACENOVNIKU, ZAPID, NORMA, KALO, TEZINA, PIN, KRITZAL, OPTZAL, KATEGORIJA, IMASBROJ, STANJEPOSER, ZAPREMINA, SLIKA, PPID, TRDECPAK, PRODCENABP, JMR, 
                         STANJEPOREKLAM, STANJEPOREVERSU, ADR, STANJE_MOJE_EKSP, VPCID, PROCPC, DATUM_ISPORUKE, REZERVISANO_MOJE_EKSP, STANJEPOOTP_MOJE_EKSP, STANJEPOSER_MOJE_EKSP, 
                         NAZIVZASTAMPU, ALTPIN, TRPIN, DRZAVAID, LINKED_ROBAID, OBLIK, REKLAM_PROC, JM_POVRSINA, JM_ZAPREMINA, X3, Y3, Z3, NAS_BARKOD
FROM            ROBA
WHERE        (KATBRPRO LIKE '%?@ID')

Aucun commentaire:

Enregistrer un commentaire