I want to make a query like this.[url]...
When I test it on my mysql query browser, it works well.
Now, I want to execute it in VB with mysqlCommand. of course @rownum is defined as a parameter and waiting for its value. How can I execute that query in VB?
I was wondering if there is anyway you could go about executing what's stored in a variable....kinda like in an #Eval statement....
E.g.
dim i as integer
dim PlaceHolder as String
for i = 1 to 10
[Code].....
I need execute a webPage for example [URL]. Well those variables change then I need execute this webpage but, I don't want it opens on c# or vb.net.
View 2 RepliesIs there a way to "execute" a string variable as a command? [code]
View 9 RepliesI have the following function
Public Function GetPositionBySchoolID(ByVal SchoolID As Integer) As CPAPositionsDataTable
Dim positions As New CPAPositionsDataTable
[Code]....
And I was wondering if there is any way to cut out assigning the LINQ result to tmp and just work with the result directly, i.e.
Public Function GetPositionBySchoolID(ByVal SchoolID As Integer) As CPAPositionsDataTable
Dim positions As New CPAPositionsDataTable
[Code].....
What i am tring to do is execute certain code based on a variable held in a module someting like compiler directives, here's an example for lack of an explanation.[code]...
View 2 RepliesI'm using some VB.Net code to manipulate files on my system - the idea is that the code checks if a file exists, and based on a value read from a text file elsewhere the system decides what to do... For this I'm using a 'select... case' statement to decide on the action to take. However, when assigning a value to the variable, the code doesn't even find the option to go for... Here's the VB code:
[Code]...
Is there a way i can execute a CLI program and have it output or return what the CLI program sais, such as ping etc.
View 3 RepliesI'm trying to execute a MySQLCommand like so[code]...
It seems to be something to do with the "size" parameter, but I don't see what is wrong with it.
I create a dictionary in a function which I pass to the function executing the sproc.
Dim PParamDict As New Dictionary(Of String, String)
PParamDict.Add("sname", name)
PParamDict.Add("sdescription", description)
PParamDict.Add("sLoggedInID", LoggedInID)
PParamDict.Add("sCompanyID", CompanyID)
The dictionary gets passed to the function PParamDict -> ParameterDict
Dim dbComm As New MySqlCommand(ProcedureName, PConnection)
Dim pair As KeyValuePair(Of String, String)
For Each pair In ParameterDict
dbComm.Parameters.AddWithValue(pair.Key, pair.Value)
[Code] .....
This works as long as the PParamDict.Add statements are in that order. If they're in a different order they get passed as they come in. This is the most ridiculous thing I've ever seen, I'm passing the keys to the MySqlCommand which are defined letter for letter in the sproc.
I would like to ask for a recommendation for my project. Basically, it's a scheduled program that shall run at a given period of time, for example, 6:00 pm daily, it includes importing an excel file and inserting it in a sql table. I have my codes with me, but I dont know how to execute this program automatically.
View 3 RepliesI'm having a problem with Dim query As New MySqlCommand("Select count(*)....") I would like to take the variable query and do an If query <> 1 Then statement on it. Is this possible or is there a completely other way to go about this comparing the contents of a MySQL select statement. I'm rather new to Visual Basic.
View 1 RepliesI am using the following
Dim cmC As New MySqlCommand()
Dim daC As New MySqlDataAdapter()
Private Sub btnClientSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClientSave.Click
[code].....
When I add 1 client it works fine, but when I try adding another I get the following error:
When MySqlCommandBuilder.ReturnGeneratedIdentifiers is true, MySqlCommand.UpdatedRowSource must be set to None.
Public Class Form1
Dim x, c, number(0 To 19) As Integer
Dim s As Integer
[CODE]...
The variables in the brackets [example] do not actually have brackets in them in the original code. These are where the issues are. For both variables, it says, "The type for variable [variable] will not be inferred because it is bound to a field in an enclosing scope. Either change the name of [variable], or use the fully qualified name (for example, 'Me.[variable]' or 'MyBase.[variable]')." Now, I'm not entirely sure if this is a stupid question or not, as I'm used to VB '98 because that's what we use in my programming class at High School. let me know why this won't work.
-Note: The intention of this program is to continually loop the generation of numbers for this list until I tell it to stop. Button1 ends the program, Button2 generates the list one time only, Button3 is supposed to loop the generation of the list, and Button4 is supposed to end the loop, but not the program.
My basis of my programForm 1 has functions, which are controlled through button1 which sends an email, At the end of the send email function I have Dialog1.ShowDialog() Which opens Dialog1 to say "Email has been sent" With a button, I want this button to execute the whole program, How do I do this?
View 2 RepliesThere is a "submit" button and a textbox, when the button is pressed, i want to connect to access database and search for the entered text in the textbox . if true i want to show "okay" a string .
View 4 RepliesI need to execute a .lnk file in vb.net (lnk file that points at an exe file).[code]...
View 1 Repliesexecute an action every 5 program starts?
View 8 RepliesI want to make a program with a button and a textbox. When i click the button the program (don't know how) writes the text from the textbox in a process called test.exe. Test.exe is a cmd like window, there is only one place to write on it. How can i make it happen?
View 4 RepliesI have to execute the command line program takeown.exe[url]...
from my console application, I've tried this cose but received no output and the program does nothing[code]...
I am executing a autoit script when autoit is installed in the system by using the following code
objProcess = New System.Diagnostics.Process()
objProcess.StartInfo.Arguments = "abc"
objProcess.StartInfo.FileName = "Z:Scripts est.au3"
objProcess.Start()
But I need to do same by giving a path to a unzipped files instead of installing it on system. e.g My autoit path where I extracted files are z:Softwareautoit3.exe and my scripts path is "Z:Scripts est.au3".
Is there any command in Visual basic that can execute a function every time I choose just like setInterval in Javascript
View 1 RepliesI'm developing a web application that displays items from a work queue to a user. When an item is selected I have the app lock that item out so no other user can select it. By hitting the back button in the app it unlocks the item.
I want to be able to unlock the item if the user hits the backspace key. I know what code I need to unlock it. I just need to know how to make the code execute on backspace key stroke.
What I am trying to do is go to a website using a webbrowser, and then simulate a click. I can do this easy enough when the click is on a regular button, not handling javascript. But it seems that the website has a javascript function handling the click that I want to simulate[code]...
View 1 RepliesIm trying to execute a winform app from my website (asp .net), this winforms app its execute in the server side for processing information and send email, but i need to pass some arguments, from the webpage i know how to do it, but im asking how to catch the arguments in the winform app?[code]...
View 4 Repliestrying to execute an .exe (another program) from excel, where shall i start?
View 1 RepliesI'm writing a program and have run into a bit of a snag. I have the code perform a button click on certain buttons, the reason for this is I have a bunch of buttons that each do something and one that does everything automatically. I suppose I could rewrite everything under that one button but that would essentially double the size of my program, I could use an if statement to catch the fact that the program is in automatic mode but that would be about 15 conditions (not looking forward to writing that statement ;p)
Clicking the buttons is a nice simple, clean solution. The exception being the program performs the click then continues on executing the rest of the code in the actually clicked button while at the same time executing the code called by the code click. Main problem with this is the data that needs to be populated by the code click isn't being populated fast enough for the code in the main button so then there is errors, blank data, program doing nothing. A simple sw timer to delay could work (I know how to make one of those) but the problem with that is the program is executing against a webpage and if the webpage takes a few seconds longer to load then anticipated everything is out of wack again. I'm looking for a simplish way to cause the program to wait for ALL code called by any raised event to finish before proceeding.
i.e. Call Button.clickEvent > Wait for code and subroutines executed by Button.clickEvent to finish > continue with rest of code in button.
Below is the code I'm using so far for the user clicked button.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Button4.PerformClick()
'Need to wait for all code executed by Button4 and anything it calls to finish
x = 0
[CODE]..........................
I am trying to execute a program with switches that ends up with a shortcut being too long and exceeds the 260 character limit for shortcuts in windows XP:
[Code]...
How do I make it so that after the user selects a program it gets executed?Also can I the the OpenFileDialog1 to anything else?
View 13 Repliesi'm still at the beginner level in vb.net..i want to know...how to convert my program/code/file to execute files?
View 1 Replies
