i have the table you talking about users column and campaigns column this is how i find what campaign is assignt to user,
and yes if tomorrow someone comes with more campaigns we add those tables to the database, the reason is that each campaign have 8 columns that later in process will store data about clients contacted by, date-time, emails etc...

how can i add a parameter 4 the table ?

__________________
bx

hi guys is it possible to to use a statement like this
Select Name, Surname From DB Where (Name = @Name, Surname =@Surname)

i tried it and got an error incorrect syntax net to name.


thanks

__________________
bx

hi.. the code is wrong, it should be:

Select Name, Surname From DB Where Name = @Name and Surname =@Surname

Anyway this have no sense, since you will returning the same data you already know.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

this was my last resort for checking the db for names that exist.

early on i tried to use a CustomValidator to check 4 the name which i could not figure out to make the table dynamic, now i took this approach,

i have textbox1, textbox2 and a button.
the user enters name in textbox1 and surname in textbox2, in the button click event i created a sql connection and a data reader.

if name =true then
label.text="Name exist"
btnNext.visible=false
btnsearch.Visible=True
else
label.text=Name does not exist"
End If
this works if i search 4 one textbox, if i try to search both on override method occurs,


so if i do this
If surname= true then

...........
it validates the last bit of code,


any way thanks for the code

__________________
bx

Well, the problem is that you are using the wrong aproach. You need a query that returns the number of rows that match your data, not the row. For that you use a executerscalar instead of an execute reader. Are you following a book or something else???
Usually books takes this aproach (at least it the basic one).

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

i am not using any book can you recommend me one that deals with this,

__________________
bx

Jim may be better suited for recommending books.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========