Okay Am totally Confused
I am using C#
Right I have SQL SERVER 2008 ENTERPRISE EDITION
-----I created a database in it called it TestDB
-----I made a Table called it TestTable
-----The columns I have are ID, NAME, PASS, SERVER, DATABASE.
Right what I want to do is say I have a TextBox and a Button right
When I type say SECRET1 in to the TEXTBOX and Press Enter I want it to go through the Database and find where SECRET1 is in PASS Column... and if it has it I want to the whole details of that Row...
So I want its ID, NAME, PASS, SERVER, DATABASE
How do I do this? I mean I know I could say
"SELECT * FROM TestTable WHERE PASS='"+ passwordTb.Text +"'"
But then If it cant find that Pass in there I want it to say No Such Password... T_T
soo I want it like a for Loop so I want it so I can do this query
"SELECT * FROM GATEWAY"
FOR (next row still exist)
if Gateway.PASSWORD == passwordTb.Text
do this this this this...
"Sorry I wrote it in simple understandable way.. didn't use proper coding stuff if you get what i mean..."
I know how to do this for Java/MySQL... where it would go through each available one... but did that using xml ofcourse.. LOL
But absolutely NO CLUE about SQL SERVER and C# am using this combination for the first time... please let me knwo if its possible a sample or example would be brilliant to.