|
your missing the AND
WHERE USERID='" & TextBox1.Text & "' AND PASSID='"
|
|
|
|
|
Hi, I added the extra AND and here is the error what I am getting now!
Syntax error in string in query expression 'USERID='Brad' AND PASSID='test' AND HARDWAREID='BRAD-8EYRYEUOH4'.
The exception is on this line of code in my source:
Dim dr As OleDbDataReader = cmd.ExecuteReader
Thanks
|
|
|
|
|
Dim sql = "SELECT UserID ,PassID, HardwareID FROM MYTAB WHERE USERID='" & TextBox1.Text & "' PASSID='" & TextBox2.Text & "' AND HardwareID='" & TextBox3.Text
like said above you are missing the AND but also a "'" at the end of you sql string
so the above string becomes:
Dim sql = "SELECT UserID ,PassID, HardwareID FROM MYTAB WHERE USERID='" & TextBox1.Text & "' AND PASSID='" & TextBox2.Text & "' AND HardwareID='" & TextBox3.Text & "'"
hope this helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
Thank you so much!!! I cant believe it was something that simple!!!
Cheers again!
|
|
|
|
|
no problem
I learned the hard way to check my sql string char by char (searched for the same thing a long long time a while back so...)
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
I have converted a vb6 application in vb.net 2005 express.
My application has lots of procedures and functions in modules.
As same procedures are used in various exe files i want o create a common procedure base
(presently same procedures are used in various exe files as modules)
Can I create a .class file or dll file and call the same in main project files.
This will reduce lot of common code
please suggest sample code as I have no formal education in vb.net,
No one gets before time and more then destiny
|
|
|
|
|
Yes , You can ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Just create a class in with the same namespace and that class will contain all of your recquired function,
and from the main fuction just create the object and access your required function !!!!!
Good luck
Happy Programming
-----
Abhijit
|
|
|
|
|
I verify that with these following codes I should see the MS-DOS windows
<br />
Public Class Form1<br />
Sub Main()<br />
System.Console.WriteLine("About VB Example")<br />
System.Console.WriteLine()<br />
<br />
' Prompt user for identifier<br />
Dim ReplyString As String<br />
<br />
System.Console.Write("Type A or B: ")<br />
ReplyString = System.Console.ReadLine()<br />
System.Console.Write("You typed: " & ReplyString)<br />
End Sub<br />
End Class<br />
But after running debug without any error ... I saw nothing. Even if I use a button to activate similar codes ... the result is nothing!
By the way I do have .NET Framework SDK
Anyone can help?
|
|
|
|
|
It appears that you have created a windows form project as indicated by the Class called Form1. Try creating a Console app instead. This worked for me.
Module Module1
Sub Main()
System.Console.WriteLine("About VB Example")
System.Console.WriteLine()
' Prompt user for identifier
Dim ReplyString As String
System.Console.Write("Type A or B: ")
ReplyString = System.Console.ReadLine()
System.Console.Write("You typed: " & ReplyString)
End Sub
End Module
|
|
|
|
|
You are absolutely right!
Thank a lots 
|
|
|
|
|
hi all,
i have a datagridview in my program which contain Combobox type column. My problem is that combo box column require two click to open drop down list.
anybody have idea that how can i open dropdown list on single click ?( as we do in normal combo box control)
thanks in advance
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
i am populating the datagridview from db. i am making changes to datagridview and also i am adding new row.
|
|
|
|
|
Please provide more information.
|
|
|
|
|
i am going to populate the datagridview. i want to make changes to datagridview and i want that changes to be available in database . i will insert new row in the datagridview , i want to add newly added row to database. i am using sqlcommand option . but i want to use sqlcommandbuilder but i am uanble to update using sqlcommandbuilder.
Siva.
|
|
|
|
|
I would say use the RowAdded Event to trigger a function that finds which row was just added, parse that information, build an appropriate update command, then use that to update your database
|
|
|
|
|
hi all
i want to Call an Exe, that is a Console Application, in that Exe i want throw in Commands from e.g like "Dir", but i want to do this in vb.NET.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
You can use the Process class to achieve this.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
i have Googled it , and i will read about it thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Vuyiswamb wrote: i have Googled it , and i will read about it thanks
All you need is:
<br />
Process.Start("ConsoleAppName.exe")<br />
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
Wow Thanks man
its So Easy.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
One more thing , how to i tell the Compiler the location of the File?, should i use the Path ? like
Process.Start("C:\ConsoleAppName.exe")
?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
|
Thank you
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hi all,
i m creating directory structure (mean which contain subdirectory & other files). Everything is working well except one thing. In 40% case i get error -Access to the Path "Some Path & "\*.txt" is denied.
Here one thing, that i want to explain is that on every run, i select same folder
any body have idea where i am wrong ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Are your permissions set right?
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
