sir

i have to use parameterized sql query as on running the user will select the zone and then he will able to see the ippool of that selected zone...

ZoneSearch is a variable and it contain a zone name selected form the combo box items

here it is "City"

ok sir

i first change my naming conventions to as u described me

and can u suggest me some article on normalization

so that i can read

my big problem is the relation between IPPOOL and ACCOUNT table which will be created to 1 to 1

and that mean that if i delete a user also will...

sir thanks for replying immediately

sir i am using sql server express edition in Visual Basic 2010 and there i create the tables and relations using the graphical interface

i created...