I-BEGO

temen2 minta penjelasannya donk..

masalah gw begini :
saya pengin ketika saya masukan kode barang nanti ny akan muncul nama barang ny di datagridview ny sesuai dengan yang ada di database..gmn ya cara nya ? tolong donk penjelasannya

tinggal om terjemahin sendiri ke C# ya

Code: Select all

private function GetItemValues(byval pReturnField as string, byval pKey as string, byval pValues as string) as string
      dim xSet as new dataset
      dim xAdap as sqldataadapter
      dim SQL as string, Value as string
     
      SQL = "SELECT * FROM Table WHERE " & pKey & " ='" & pValues & "'"
      xAdap = new sqldataadapter(SQL, "Connection...")
      xAdap.Fill(xSet, "Data")

      Value = xSet.tables("Data").row(xSet.tables("Data").row.count-1).item(pReturnField)
      xSet.tables("Data").clear

      return Value
end function


cara panggilnya :

Code: Select all

   txtNamaBarang.text = GetItemValues("Field (NamaBarang/Jumlah/Satuan/Dst)", "Field Primary Key (Kode Barang)", txtKodeBarang.text)


semoga membantu