c# - To Load User Details -

i have user records in table1. type 1 user in textbox. show user details in form.

i.e..,

if type "user1" (1st record in table.) in textbox. show user records in form.

id  name  user name  userid amount  

these records shows in orderly other label text values.

note: in table1 have used join query joining user table , payment table. amount has been calculated.

for example,

1 vignesh vkvk 1 6000  2 vignesh vkvk 1 8000  3 krish   kkkk 2 10000  4 vignesh vkvk 1 14000 

if type username "vkvk" , sum of payment sum shown in payment label text.

here code is,

  public sub load()      rs new adodb.recordset     rs.open("select sum of netamount table1",con)          rs("payment amount").value=lblpaymentsum.text   end sub 

here have face error on function. but, can't understand mistake done here.