Hi,
In my project i want to save some user logins and passwords in to an Excel sheet. I am trying to use Excel sheet as database and validate the user login using the SQL query statement.
" select count(*) from [Sheet1$] where user='"+textbox1.text+'"and password='"textbox2.text'";
but i don't get any output,every thing looks fine, no error msgs.
Earlier, after a long search,i was able to get connected to the Excel using the connection string.then later I checked the connection by displaying the Excel file into Data Grid view using the "Select * from [Sheet1$]"
this statement worked well and i got the whole Excel file in Grid view.
My question is
1) Is it possible to query Excel sheet using the " select count(*) from [sheet1$] where user='"+textbox1.text+'"and password='"+textbox2.text+'" statement?
2) Is there any way that i can save the user names and passwords in some other file(any type) and query using the SQL statments.
All i want is to avoid the use of a database in my application beacuse it is a small website. I know how to query SQL or ORACLE but i did not work with Excel earlier.
If any one can help me...that would be great
Thanks in Advance...
|
No responses found. Be the first to respond and make money from revenue sharing program.
|