Handle Results Of More Than 1 Row
May 6, 2009
I am having a SP run in my VB application every 10 seconds to check for any new rows that have been inserted to the database since the last check. What is the best way to do this? Most likely it will be 0 or 1 rows, but I am afraid at random times it maybe more than 1 and so I thought I would fill it in a DataSet, but I came in here to see if there are any other better ways. If dataset is the best way, how do I do a For Each Row in the dataset to process some VB code for each row?
View 20 Replies
ADVERTISEMENT
Feb 13, 2010
I know if I use String.Split on "Alpha Beta", with the space character as the separator, I will get "Alpha" "Beta". My question is, how do I then handle "Alpha" and "Beta" as separate strings in future code?
View 1 Replies
Sep 28, 2010
I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?
View 1 Replies
Mar 23, 2009
I wrote an application to handle a joystick with directinput. It works fine if it uses the handle of the main window but it doesnt happen the same if the handle is the one of the component that contains the joystick's operation.
I mean:
main form handle: 15
component handle (which is inside the window and the joystick needs the focus of this component to work): 25
It always work if the handle i initilizate the device is the main form (15).How can i use only the handle of the component?
View 1 Replies
Jul 22, 2009
How can I make this program not to give me the results for the quit command input of -999 but rather just to quit without the results?
Sub Main()
Dim TempIncelsius As Double
Dim TempInput As Double
Dim Formula As Double
[CODE]...
View 4 Replies
Feb 15, 2012
I have created a program that randomly produces simple maths questions and saves them to a SQL Server (SQL Server 2008 R2). The code looks fine and works if I step through the program. Each pass it creates a random question answer and saves them to the database. However, if I run it (Debug/Release), the program produces a question and answer but repeats it in the database.
[Code]...
View 2 Replies
Apr 11, 2011
how to get raw xml results from a web service.
So for instance i have Dim mWeb as new WebServiceName
mWeb.SearchParameter1 = "12345"
How can i turn in the results to raw xml?
View 2 Replies
Jul 13, 2011
Ok i have a query i use to parse an xml file to get an id number of a movie that allows me to get more detailed information about that movie from a database.Now the problem is the id is returned correctly with xml files stored on my hard drive (c:\desktop\movies)but when i try and parse an xml file on an external drive it dont get a hit on the <id>1123</id> node.
query
Function movieID(ByVal directory)
'Get the movie name
[code].....
View 2 Replies
Mar 15, 2011
I have setup an OleDbConnection and my query works just fine but the problem I am facing is that I want the entire query not just a certain row or column. I also would like to place this entire query into a blank excel spread sheet.[code]
View 1 Replies
Jun 20, 2011
I am running VB from VS2005. I just had to change a program to revises the logon info for a database. When I run build, I get success and there are no errors in the error page. The only thing I can think is that the first two times I ran the build I have the configuration set for 2 copies. It never bothered me before but some update may have come in and changed that. I reset it to 5 and that did not help. I closed VS and re-opened, no help. I created a new folder and moved the contents of the release folder out so that nothing was left. After running the build several more times, the release folder is still blank.
View 5 Replies
Mar 23, 2012
[code]How can I compare the results of qperson to qyou? Since the results "disappear" once End Using is executed?
View 3 Replies
Apr 14, 2010
Im creating a search button, and want to put the results in a datagrid. I want to view specific records depending on the keyword inputed by the user. Im having errors when I use this query
View 27 Replies
Jul 25, 2011
Possible Duplicate: Can .NET intercept and change css files?
I have configured IIS6 to get .NET to handle css files.I did the following steps
Launch IIS Manager Right-click on Default Web Site Click on the Home Directory tab Under Application Settings click on Configuration.Add a new association for .css and map it to .NET executable:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_isapi.dll
How can I check if this is working, i.e. I want to change the default style of a page depending on the url, i.e. if the referer url is http://intranet, it should continue to use the old existing style style1.css, if the referer url is http://intranetv2, it should use the new style style2.css.
View 2 Replies
Aug 6, 2009
I can't get a handle on the syntax. Can anyone give me a simple demo?
View 3 Replies
Jul 2, 2009
I am trying to get a handle on the correct way and easiest way to do things. By easiest I am not talking about being lazy just accessing and modifying later on. I have started using my own classes and such but I have a few questions. Sometimes I want to create a control on the fly through code instead of using the designer. Should I create this control in the main form file or in a separate class? If I make it in another class it seems harder to access later on. Then again if I dont know that the control is going to be created(user clicks a button to add a control) how can I access it? Also it seems alot harder to access certain things when it is in another class. For example if I create a new window in a class and then want to check if it is there or not it is alot harder to do.
View 5 Replies
Feb 13, 2012
Are there anyone know how to get the handle of a standard Combobox using API?
View 3 Replies
Dec 13, 2011
How do i get the handle of a NotifyIcon?
View 4 Replies
May 8, 2009
I need the intPtr for a form. Control.FromHandle(control) gives me the control from a handle, but I need the opposite--get the handle from a control. How do I do this?
View 2 Replies
Apr 27, 2009
I need to get the handle of a control as an IntPtr to pass to a screen capture class in vb.Net 3.0. Tried this but get an invalid handle exception.
Dim hwnd As IntPtr = Runtime.InteropServices.GCHandle.Alloc(CanvasMap)
View 2 Replies
Jan 24, 2012
I am trying to create a small utility that tracks desktop usage in detail, to the level of individual text boxes etc.... in other applications. However, it is proving quite tricky. I thought I had it nailed using the Windows api. The below code is just a snipet of the code but essentially it provides me the handle of the control that the mouse is over. I thought from here, it would be easy to to the same thing but to provide the handle of the control that the cursor was actually clicked on, for example, if someone is filling in a text box in an application, they would not necessarily move the mouse to get to the text box, they may tab to it. Does anyone know if there is a way to get the handle of the control that is in use?
Private Sub Timer1_Tick(sender As Object, e As System.EventArgs) Handles Timer1.Tick
Dim ptx As Integer = Cursor.Position.X
Dim pty As Integer = Cursor.Position.Y
[code]....
View 4 Replies
Apr 12, 2011
I need to get the handle of a window with a specific name from my vb.net application. The form isn't actually from my application.
View 1 Replies
Jun 23, 2009
I am going mad about getting the process id for one existing handle on VB2008.I tried both GetWindowThreadProcessId(hwnd, pid) and GetProcessId(hwnd), while PID always returns 0, I tried the same things in VBA of Excel, it works perfect, so this is somewhat weird,
View 8 Replies
Jun 22, 2010
I have referred DLL in my project. I have to handle the event from DLL in VB.net code. I guess we can do using WithEvents. Can you give me complete picture?
View 2 Replies
Jan 19, 2009
I read stuff from a SQL DB (database) using a data set. Some of the columns in the DB may contain NULL. I want to go through the table in the dataset and print, or use in some other way, the data. But when I try to use a certain data that corresponds to a NULL in the DB my program crashes.How can I detect - in the dataset - that it has no value and that I shouldn't try to use it?
Private Sub Get�rendenLista(ByVal e As System.EventArgs)
'----------------------------------------------------------------------
' This function fetches a list of �rende from the table �rende
'----------------------------------------------------------------------
Dim cno As New SqlConnection
[code]....
View 6 Replies
Sep 12, 2009
The short program below runs just fine when it is the only item on a form. However, when I put it into the ItemInsertTemplate of a ListView control, I get the following message:
Handles clause requires a WithEvents variable defined in the containing type or one of its base types
Line 30: Protected Sub btnDate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDate.Click
The error message identifies Line 30 as the problem.I get the same message for Sub clnEvent_SelectionChanged How do I correct this?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="clnControl.aspx.vb" Inherits="clnControl" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[code].....
View 2 Replies
Nov 22, 2009
Does anybody know if there is an API function that would let me cancel a print job.I already know how to get a handle to a printer and how to enumerate the print jobs using the printer handle.
View 1 Replies
Feb 25, 2009
how to make VB handle my associated files.I made a program that opens fine when from the EXE file. But however, when I try to open it from the associated file, it behaves the same way as if opened from the EXE.So, where (in what method?) do I tell VB how to handle those files?
View 8 Replies
Jan 27, 2010
I have several installations of my Linq-to-Sql app running in the field. Now I've created a new version, which adds a new column to a certain table. I've added this column in the dbml file. But when updating the installation, I want to preserve the existing database. How to handle this? Linq-to-SQL doesn't seem to like this inconsistency.Is there an easy way to update the existing database using my new dbml file?
View 1 Replies
Oct 11, 2010
I am retrieving a database object and trying to set the values of the object's fields to various textboxes in my vb.net page
View 3 Replies
Jul 27, 2010
my computer model has an eject key on top of it (touch sensitive), this handles the CD ejecting. But Windows doesn't native support this button, and I have to use Dell QuickSet to use this button (otherwise it does nothing). I need to hook onto this key and eject the CD Drive when it is pressed (I already have the ejecting and the hooking done). But I have no idea how to detect this key? There is no key in the key list for VB.NET, and I don't know what the eject button sends (Numerical wise) so I can't handle it that way. Does anybody know how to handle the eject key?
View 2 Replies
