Hi Mozaharul,
try it:
cmd.CommandText="select name,perm_id,permid_moth from motherno where hpid = " & txthhidm.Text & " AND motherno = " & ((txthhidm.Text*100) + txtmemno.Text)
or
YourQuery="select name,perm_id,permid_moth from motherno where hpid = " & txthhidm.Text & " AND motherno = " & ((txthhidm.Text*100) + txtmemno.Text)
msgbox(YourQuery):' only for testing
cmd.CommandText=YourQuery
are you sure that txthhidm and txtmemno are ONLY numeric value???
