|
vijay2482 wrote: sql = "SELECT Username,Password FROM user WHERE Username='" & TextBox1.Text & "' AND Password='" & TextBox2.Text & "'"
vijay2482 wrote: syntax error in FROM clause
Use a stored procedure
I are troll
|
|
|
|
|
i have an MS Access Database table,which i have connected with the VB.net proj
Troubleshooting Exceptions: System.Data.OleDb.OleDbException
An OleDbException exception is generated when a warning or error is returned by an OLE DB data source.
Associated Tips
Verify that you are connecting with valid credentials.
Make sure that the credentials you are supplying are valid. For more information, see OleDbErrorCollection.
Verify that the server name is correct and that the server is running.
Make sure that you are using the correct server name, and that the server can be reached. For more information, see OleDbErrorCollection.
Remarks
This exception is thrown whenever the .NET Framework Data Provider for OLE DB encounters an error generated by the server.
If the severity of the error is too great, the server may close the OleDbConnection. However, the user can reopen the connection and continue.
this is the online help.i am not able to find whats wrong with my code
im not aware of stored procedures...
can u help me out in this coding?
|
|
|
|
|
That's a warning from the integrated security, probably an error in the connectionString. Try this one:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Downloads\user.mdb;User Id=admin;Password=;
vijay2482 wrote: Verify that you are connecting with valid credentials.
It is referring to the credentials in your connection, the one used to connect to the database. You can't perform a "SELECT FROM USER" until you have a database-connection. And you'll need a user-name and a password to do that
The supplied connectionstring feats. the default username and password for MS-Access. From there-on you can implement your own security-system.
I are troll
|
|
|
|
|
I expect your select statement is incorrect, probably with all the embedded quotes. Use either a stored procedure or a parameterised query, or if you must leave yourself open to sql injection attack then print the select statement out and see where its wrong.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
The error says your SQL statement has a problem in the FROM clause. Does your database have a table called "Users"? BTW: That's NOT referrring to the name of the database file.
|
|
|
|
|
yes i do have a database file named as "user"
i deleted the existing data source in vb.net and recreated it
even then the same error is been displayed
kindly give a solution for this problem
thanks in advance
|
|
|
|
|
Inside that file, do you have any table called user?
The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."
जय हिंद
|
|
|
|
|
yes i do have a table called user with Username and Password as the fields and 3 entries in it
|
|
|
|
|
Well the error message says you don't. Try enclosing the table name in square brackets in your SQL statement.
SELECT Username, Password FROM [User] WHERE ...
BTW: Your WHERE clause is a VERY bad way of looking up what was entered on the login page. Use parameterized queries instead.
|
|
|
|
|
thanks a lot, its working now
|
|
|
|
|
How can i manage to move a label in a vb6.0? can i ask for the source code...Please i need help
|
|
|
|
|
Label1.Move Left,Top,Width,Height
Label1.Move 500, 1500, 1000, 200
better to try in .net. VB is old lang.
|
|
|
|
|
Friend,
This is the sample code for moving label. you need to add a label from tool box and paste this code into form load event.
Label1.Move 1000, 1500, 5000, 5000
|
|
|
|
|
hii all..i want the user to enter hexedecimal valuein the text box, so i need to convert it..but i dont know how..anyone can help me plss
this is my email: hafizul_10422@yahoo.com
|
|
|
|
|
|
how to validate the hexadecimal value??
thanks for ur help!!
|
|
|
|
|
Hi,
You can use the Parse or TryParse methods of the number types to do the conversion. This fragment in c# should get you started.
String userInput = "ab7f";
Int64 value = Int64.Parse(userInput, System.Globalization.NumberStyles.HexNumber);
Alan N
|
|
|
|
|
What do want to convert it to?
The assumption is that it's to integer but it could be to character or binary or unicode.
E.g. 4C hex goes to:
integer 76
binary 01001100
ASCII L
EBCDIC <<br mode="hold" />
You really need to be specific when asking questions.
|
|
|
|
|
I’m stuck on how to enter a HEX number into a text box
|
|
|
|
|
Strictly speaking, what you are asking for is actually not possible. There is nu such thing as a hexadecimal numbe, you either have a number or the hexadecimal textual representation of a number. Converting the textual representation into a number is called parsing.
Entering the hexadecimal textual representation of the number in a textbox is easy. Make sure that the textbox has focus (you will see the blinking caret in the tectbox), then you just push keys on the keyboard to enter characters in the textbox. Valid characters for the hexadecimal representation are the digits 0 to 9 and the letters A to F. The letters can be either upper case or lower case.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi Everyone,
Can anyone guide me to install a vb6 application in a dotnet machiene.
Regards,
Manowj
|
|
|
|
|
Can you please elaborate : what are trying to do and where exactly you are facing problem
|
|
|
|
|
The fact it has the .net framework installed makes no difference to a vb6 app. The two are not related, just install the app in the normal way.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
tab skips the controls inside panel in winforms!!
How to set tab index so that it go through all controls in panel and then to next control on form??
|
|
|
|
|
I Hope this will Help Click[^]
|
|
|
|