I have created a form that should allow user to communicate with the database. The search criteria are filled withing Textbox. Then the string from the textbox is transferred into the SQL Command string. However, it is not included...
SQLStr = "SELECT * FROM tblMain WHERE ID = " & txtSearchBox.Text & "'"
MsgBox(SQLStr)
And only this part is stored in SQLStr variable = "SELECT * FROM tblMain WHERE ID = " - (pops up in msg box)
Basically im having some major problems with my SQL/Access connections.I can query my database and everthings working fine however i cant seem to find how to run a query on the database and return the result storing it in a variable,Current query is Str = "select [in stock] from stock where [barcode number] ='" & barcode & "'" How would i go about putting that into a variable i could use to add another number to before re-inserting it back into the same field.
View 5 RepliesIs there a way to "execute" a string variable as a command? [code]
View 9 RepliesI have a visual basic shell command that installs an IPP printers with a shell command. It asks for the username for the port.
userport = username.Text
How do I Incorporate that into:
Shell("rundll32 printui.dll,PrintUIEntry /b ""AT-LAB-BWQ"" /if /f %windir%inf
tprint.inf /r
""[URL]"" /m
""HP Color LaserJet 2800 Series PS"" /z /u")
I am trying to do a runas command but it will not let me pass all the variables instaead it brings up a command prompt asking for a password how can I wait for the command prompt to come up and pass the command variable to the console? variable I need to pass is aPwd
[Code]...
i tried to change back color of a label by command button by using a variable value
Private Sub Button3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim colorof As String
colorof = "Color.Red"[code]....
but its giving error and is not working,
Label1.BackColor = Color.Red is working but I wanted to do this with variable value
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
I am currently using psexec.exe from PsTools to send a command to a remote system to fire a command through a command prompt however I am finding that the shell I am doing does not seem to like the spaces in the path.
[Code]...
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
I want to add a new select command to my dataset. To do that, I have added a new partial class to my project. Because we have to use partial class if we want to extend generated dataset codes. [code]...
View 3 RepliesI am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
User need to select their prefferable data to show in report. What i did is i have a clear command first to delete the temporary table. The temporary table is basically a table to stored user selection parameter data. After the clear command, i have
a insert command to insert user selection data into the temporary table. What happened now is when i run the program exe, first run of the report is work fined, but not the second and the following times of execution. It will return null or blank report. The weird thing is when i execute it from development environment, it seem like the report is able to pick up user selection parameter and run the report for the first times and the subsequent execution.
i have seen this in many codes, just not sure where to start and how to call the command. what i'm talking about is having code as such (this is for save file dialog):
[Code]...
You know how you can put a picture in the resources file and it will be included with the exe. I was wondering how could i get a video to be apart of my program so that I would have to carry the video around.
View 1 RepliesI'm writing a class-library in VB.Net and one of the subs that are being called from the application which is using my library has more or less the following syntax:
Public Sub LoadDict(ByVal PhoneticType As String, ByVal strDict As String)
where PhoneticType can be phonSoundex, phonDoubleMetaphone or noPhonetic
I want to give the application-developer a possibility to select the PhoneticType from a list when writing the call of above sub (I think it's called attribute-arguments). This would make it easier for the developer since spelling-errors can be avoided and which will avoid errors when using the library. I think it's all about attributes but I haven't managed to get it to work despite trying.
I am looking to create a gridview with an add button to have the user be able to insert a new blank row. I am also looking for this row to be able to have checkboxes as fields.
View 1 RepliesI am trying to have a user input 7 letters into a textbox, and then have a url like "[URL]". Basically I am needing for the seven letters to be included in the custom url.
View 2 RepliesI am compiling and deplying my program on CD. I am using the PAINTSTROKE font in my program. This font is not on everyone's computer. How do I tell VB 2005 IDE to include it? I assume this would work with any font that may not be on another computer.
View 3 RepliesI'm using a dll in my program, it works fine. But when I publish and try to run on another machine, it says the dll is missing.Am I right in saying that I need to add it to my references, with the Add button on the references page? When I do that, it says it's not a valid assembly or com component.
How do I fix this? My level of knowledge is very low, especially with dll's.
Is there anywhere I can add folders to my project, so when someone downloads my project/program they automatically get the files I added into it. Say I want to include a data file, and my program automatically uses that file for my RichTextBox1 - And everytime they save, it saves to that file - And when they open up the program again, it opens that automatically preloaded file that came with the program?
View 1 RepliesI need to include a text file that I host on a website, into my program. I'm not sure if you can do this, but I need to. What specific code, or object (with code) should I use, to do this? Version Used: Microsoft Visual Basic 2008 Express Edition
View 6 RepliesIn the Windows Shell, there is a command that looks like this: copy /b fileA.zip + fileB.jpg fileC.jpg..Is there any equivalent function in VB.NET? I already know this works: [code] But I would much rather have a built-in function to work with. Here is what I am trying to do: url...Also, this doesn't just work for pictures. It works for any binary file. Is there any way in VB.NET to tell if a file is binary or text?
View 3 RepliesIs there a way to hide the characters of a "set /p password=Enter Password:" command? Or any new strand not using the SET command i could use instead?
View 2 RepliesI am trying to "behind the scenes" log myself into a website, from the VB code behind my ASP.NET website. But I am dumbfounded as to how to do this.
As far as I know I should be using the WebRequest or Webclient class. That is about as much as I know. I am not sure how to use the class.
I want to click a button on my website and have its Click event send a username and password to another website. This other site isot affiliated with mine. I realize the concept may seem stupid, but I plan on taking this further later, but Just need to know this now.
I have 2 source codes in fortrran (I have not written them). I visualized these codes by linking them to VB2005.when I excuate the VB.exe, when VB calls one of these DLLs, there is no problem, but in calling the other DLL, the DLL is executed but the VB.exe is closed and the interface page to the user goes out.
View 1 Repliesfaster way to enumerate through a directory and sub-folders to gather all the files in the enumeration? This is what I have right now:
Public Shared allFiles() As String
allFiles = Directory.GetFiles(<ServerLocation>, "*.*", SearchOption.AllDirectories)
EDIT: I am enumerating these files from a server location. I don't know if that will change the perspective of this question or not.