I have the following code:
Code:
Imports System.Data.SqlClient
Imports System.Data
Public Class Main[code]...
and the sub Exceptionquery is not working. I can verify this because it is supposed to create a new table called scratchpad3. what I may be missing in that sub routine that isn't allowing it to work?
Is there a command in vb that can be used to pause a routine to give time for the form to show before the routine starts as my routine is running and completing before my form shows up?
View 13 RepliesFirst, I launch a website in Internet Explorer from VB.net and automatically login the user with ther username and password. As soon as the username and password fields are automated, I send "enter" to the website so it goes to the next website. This part works perfectly. However, my problem is that i want to send a mouse click event, which i have already written, to click a hyperlink on the next website page. I tried a few different things, none of which worked. My program is automatically logging in the user and doing the mouse click event at the same time. I have tried to use the "sleep" command, but the mouse click event is still not executing after the second webpage loads. I have tried using nesting "If, then" statements and that has not worked either. Does anyone know how to make sure the webpage fully loads before executing a sendkeys routine or a mouse click event? This is my code thus far:
If (Search.ComboBox1.Text = "IWR") Then
BlockInput(True)'this disables the mouse and keyboard
Dim IE As New Object
[code].....
There are no errors, everything is just executing all at once instead of letting the second webpage load and then executing the mouse click event.
I am using sockets to send message between computers. I send the messages alright. What I want is when the message "x0x" comes, the client must be closed within 5 minutes. Teh admin can cancel the request by sending message "-xx" as well. The routine that checks for incoming connections and accepts messages uses WHILE TRUE...END WHILE since it must always listen. Once I get a message, I need to fire a timer control or other that fires within 5 minutes. But the program cant leave the WHILE TRUE at all. If i exit it early, the timer fires and the program does get exit. How do I fire the timer or other routine while still the WHILE TRUE routine checks for incomin connections and messages?
View 5 Repliesis there any way to reference a particular code routine in VB.net external to the current loop/routine?Example:
If Var01 < 5
[Routine A]
Else
[Routine B]
End If
where Routine A and Routine B are code sequences at the end of the entire program -- such as outside of the current sub or class? The idea would be to reference an otherwise repetitive code.
I have a sub routine where I pull in information from a database. I want to use variables from this sub routine in another sub routine. I tried making everything public but it doesn't want to be friendly and share.
Dim strEmail as String
Public Sub readDB()
strEmail = "whatever@doohikcy.com"
[Code]....
The readDB would read the database and set the variables and do whatever it needs to do. Then when they submit the form it would e-mail the form to whatever the email address was.
What would be the best way to add a progress bar to this routine so that it corresponds with the progress bar?[code...]
View 6 RepliesWhen entering a value in dgv I want the Tab key to fire a routine. Works out ok only thing is I have to hit the Tab twice before it fires. Don't know why, is there a way to prevent it, so that I have to hit the Tab key only once ?
View 1 RepliesI was looking for something send keystrokes and I found this helpful routine SendKeys that I can use in a VB Script. I wanted to have "Right Control Key + (Scroll Lock & Scroll Lock)" sent to the machine. Essentially, having the Right Control Key pressed, I need Scroll Lock pressed twice. Here is what I tried:
set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.SendKeys"^({SCROLLLOCK}{SCROLLLOCK})"
I have the following code:
Private Sub Exceptionquery()
Dim connection As System.Data.SqlClient.SqlConnection
Dim connectionString As String = "Initial Catalog=mdr;Data Source=xxxxx;uid=xxxxx;password=xxxxx"
[code]....
I get the error Invalid Object name 'Scratchpad3' on this line:
adapter.Fill(ds)
I have tried to debug this and can see that the query is correct, that the values that are being passed to the sql server are correct but it doesnt look like my code is firing off the Exceptionquery Sub. I thought to call a sub all you had to enter was the name of the sub such as this line:
Exceptionquery()
I have also verified that the mapping of the buttonclick event is mapped correctly. I have other subs that I am calling in almost the same way and those work.
I know there are several libraries of code out there that can parse CSV files according to the standard, but, for various reasons, I need one simple routine (not an entire library) that parses a CSV into a DataTable or array. Does such an animal exist or is it extinct? (Preferably C# but i can translate vb.net too)
View 3 RepliesI am writing a noughts and crosses game and everything works but the checkwinner sub routine, so basically if someone gets three X's or O's in a row then a message box pops up saying either X has won or O has won.Below is what I have written in the sub routine.
[Code]...
I'm trying to get this routine to resume the downloads.I use the same routine to download a file all the way thru non-stop..so at least the download part is working..however either the stop commands i'm using or the resume routine i thought would work is all ass backwards I'm not gonna make any conclusions or anything on this one..made myself look stupid the last time i know you all are def smarter than me when it comes to this stuff,,and dangit that just erks me to no end i tried adding a exit do in the do loop..and that of course exits ok,,but when the file is resumed is larger than its supposed to be.
[Code]...
I would like to have 1 routine to load data into different collections.I would like to use the below routine in a more dynamic fashion...be able to load a different collections with different data dependent on strSQL.Is there a way I can pass the collection I want to use.If so, in the below code how would I differentiate to load the correct data to the correct collection? [code]
View 22 RepliesI hoped you could give me som tips about speeding up som code i have to match an item to a collection of items... I have 1250 items that need to find the best match from 16774 items(every item is a class that consist of a string variable containing the path to an image, and 9 fields containg the most dominant color from a collection of 13 colors(the closest color)) The program does not use the filename or do any color matching in this step, only check the 9 fields... but it takes so
[Code]...
How do I refer to a sub routine from within a shared subroutine? When I try the following code I get this error:Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
Namespace CmdLineArgs
Friend Class Program
Shared Sub Main(ByVal args As String())[code]....
I need to write a routine that enters real (scientific) numbers into an array of 20 spaces then adds all the numbers together and prints out the contents of the array plus the total value in a format such as: 1.0 + 2.0 + 3.0 + ...... + 20.0 = 210.0 in Visual Basic 2008.[code]...
View 16 RepliesI need to write a routine that compares the difference between any date in the past and the system date, showing how many days have elapsed since that date.
View 6 RepliesI have a panel2 inside a split container that has several user controls loaded into it. Panel 1 has an exit button and I want to call one of the sub routines that is in one of the user controls loaded into Panel2.
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
Dim dialogMessage As DialogResult
Dim a As New ucTimeTracker[code]......
This line is giving me trouble "ucTimeTracker.autoWriteFileOnExit()"
I am getting (reference to non-shared member requires an object reference).Basically I want the exit button on frmMain. SplitContainer. Panel1 to call autoWriteFileOnExit() on the user control named ucTimeTracker that is loaded into splitContainer.Panel2
I have a VB sub routine for sending emails.
I am not sure how to convert to C#,
here is the sub:
Sub SendAdditionalEmails()
Dim strDelimeter As String = ","
Dim strEmailResult As String = ""
[Code]....
I have a link that looks like a button from this html <p class="link-styleContact"><a href="#"><span>Email Contact Form</span></a></p> can I run a code behind file when this is clicked on by adding the routine name to the href? like below
<p class="link-styleContact"><a href="ContactFormClicked" runat="server"><span>Email Contact Form</span></a></p>
I am new to vb.net and am trying to design a routine that will allow the user to search for a record and return the results in a datagrid. Then double click on a row within the datagrid to view a more detailed form. I have been able to build the search form but am having problems with the double click event.I found a sample application on the Microsoft web site which is doing this on a smaller scale. The sample is built on the Northwind sql database and searches the customer table when you double click a row in the datagrid the following Microsoft code runs and opens a detailed form.
[Code]...
I have a combobox sub-routine that is triggered by either a "SelectedIndexChanged" or "Leave" event How can I determine which of the two events triggered the sub-routine
[Code]...
I've searched all over for what I think should be a simple answer.Is there a way to exit a timer (created to auto-click a mouse) with a CTRL key? I've tried everything and cannot exit withouth creating a button to stop the timer...
View 1 RepliesI am using the OleDbDataReader routine to examine and manipulate Access databases.I am trying to find a procedure for indicating when the end of file is reached.I am getting an error message once the end of file is reached and another record is attempted to be read.The.HasRows modifier does not work; that merely determines if the source database contains rows, not if there are any rows remaining.
View 2 RepliesI have a service that i believe has a memory leak in one particular sub routine but I cannot find out why.The routine writes data to an opc server every second. It receives a command via tcp, connects to the database for verification of signals and writes the data. When it completes it writes a message back. I am disposing of everything i can think of but for some reason when I check it in the morning then memory has increased dramatically and the cpu usage goes up to 50%. this only happens to the service when I start the client application that sends the data so i know it has to be in this routine.
[Code]...
Isn't there a way in VB to pass an array literal? Say the subroutine ask for an array of integers and you have just one. Can't you do something like
DoSomething({MyNum})
instead of
Dim MyNums as Integer() = {MyNum}
DoSomeThing(MyNums)
I'm thinking I'm just missing some adornment to the array literal inorder pass it.
I have a GridView with Cell 0 containing the ID that I need to pass to a Public Sub.
I cannot figure out how to pick the value from Cell 0 in order to pass it to the Sub. I have tried experimenting (see the Dimmed EventID below) but have failed. Here is my code:
Protected Sub gvAppointmentsCalls_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gvAppointmentsCalls.RowCommand
[Code]....
I'm having a little difficulty Setting the .text value of a Textbox in an MDIChild from a Subby in a standalone class.
I'm at this point:
[code...]
I know that the data exists because it displays in the Message Box ( MsgBox("first item = " & ds.Tables(0).Rows(0).Item("NameLast").ToString())) and the executes fine, but for some reason, I can't get the text boxes in LeadsMod2 (Open as MDIChild) to update.
I have a problem with my application "getting ahead of itself" what the problem stems from is i am manipulating a file and then using the manipulated file further along in the program, the trouble is the program is getting to the second step before the file manipulation is complete so i receive a file not found exception. The program that is doing the manipulation has an OnEnd sub routine and i have been looking at event handlers to try and figure out how i can hold up the application until the On End routine is fired. But i have been trying this to no avail, is there an example i can have that waits for an event to be fired?
View 17 Replies