I am trying to select rows from a database depending on 2 conditions. Tried to use AND but this did not work (see code below). Any suggestions?
cmd.CommandText="select name,perm_id,permid_moth from motherno where hpid = "&txthhidm.Text&" & AND & motherno = "&(txthhidm.Text&*100)+&txtmemno.Text&""
Regards
cmd.CommandText="select name,perm_id,permid_moth from motherno where hpid = "&txthhidm.Text&" & AND & motherno = "&(txthhidm.Text&*100)+&txtmemno.Text&""
Regards