What should i research in order to accomplish this task?
I am using MS-SQL & VB.Net
I have a SQL table that stores startdate and enddate. I want to run a query on that table every 10 minutes in order to check if the enddate is greater than today and if it is I would like to add a 1 to another column if it is not I would like to add a 0.
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I am new to vb 2008, but I know how to automate some html elements. The issuse that I running into is that I cannot get my webbrowser1 to auto-click the "Gmail" button at the top left of the page or the "Show me my account" button on the righthand side of the webpage. Here is the webpage that I'm trying to auto click: url...Can someone please view the html source and give a code sample to click either button so that the page can then go on to the following page?
View 7 RepliesI have an access database and have a simple query in which i have 1 parameter.I want to run this query in vb.net and display the results in a datagrid or anything but in vb.net. I'm able to run the query but wht should i do to display the results of the query.the code i m using now is:
[Code]...
im calling a sp from vb net code that is rans for about 2 minutes and some times the user wants to cancel the query, how can i get the query id so i can sent the kill sentece?
View 7 RepliesRunning same query for different objects?
View 1 RepliesI need to filter the database based on selected user input at runtime. I have a Drop Down List, GridView, and button on my webpage. The drop down list is bound to the database, it holds a list of product catagories. The gridview is also linked to the database with a query written so that the displayed data is only that which falls under the selected catagory. I want the query to execute when the button is clicked but i dont know and cant find such a command.
View 1 RepliesI've been using Classic ASP for years and just switching over to .net. So far, I'm not having much fun, but I'm trying and I'm not going to quit. One of the small pieces I am struggling with is running a query then, updating the record.
Set objRS = Server.CreateObject ("ADODB.RecordSet")
ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=G:InetpubwwwrootTestPageTheDataTestData.mdb;" & _
[code]....
Currently my code looks like this:
[Code]...
Where x would be the numbers 0 to 100, or infinite I don't mind. I want it to check all the numerical values for each number. How would I go about doing this?
Im wanting to pull some data from our Remedy Server every so often. Right now we're having to do it manually; Data > Import External Data or New Database Query. The connection is called AR System ODBC Connection Source. We have to log into the server and then it pulls the info into the sheet. Im needing even if have to setup a conection myself first to just have this conection run every couple or two and update the excel sheet. We're using excel 03, Remedy 7.
View 2 RepliesI have an Access XP database with two linked tables and a maketable query. I need to first run the Query through VB 2005 and then get the data from the resulting table created. But I get an error when I run the query as follows. I am getting the SQL Select statement from the SQL view in MS access after I create my Maketable query So it should be ok. I am saving the select in a hidden text box on my form.The query text :
SELECT [SWX-Seats].[Asset #], [SWX-Seats].Account, [SWX-Seats].Product, [SWX-Seats].[Seat Id], [SWX-Seats].[Serial #], [SWX-Seats].Qty, [SWX-Seats].[Entitlement End Date], [SWX-Seats]![Entitlement End Date]-[NS-Seats]![Exp Date] AS DaysDiff, [NS-Seats].[Exp Date] INTO
[code].....
I have a report that displays some sales info. I have a query that takes the data from an SQL Server database and I store it in a dataset. Up to there everything is ok. The problem is that I need to print the same report using Crystal Reports for each row in my query. Is there any way this can be done? I call a form with a ReportViewer tool to display the reports, wich are basic .rdlc reports.
View 1 RepliesThis is how I update a table using DataAdapter and DataSet in VB using SQL Server[code]...
I know that the Fill method does not make sense in case of an INSERT statement, but I am new to this technology and the above statement does the job and updates the table w/o problems. My question is this: If there was an error (say a duplicate key error) how would I know this in my application? Should I be putting the above code in a try/catch block?
Also, if there is a "proper" method for running INSERT statements using a DataAdapter/DataSet combination that does not use the Fill method, please indicate that as well.
I have an application that performs database queries using "Imports System.Data.SqlClient". I want to display an animated GIF on the taskbar which spins while the query is running. However, during a query the application simply hangs and does not update the GUI until the query has finished, at which point the spinning icon is set to invisible anyway. Is there any way to force the GUI to update while the query runs?
View 2 RepliesI have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows:
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadConfigFile()
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
End Sub
Now, I want to run the PopulateGrid function directly after I connect to the database as shown above. I'm confused as to how I'd use a database query in a module when the database is initialized in my main form. Would simple setting the variable cn to public work?
I have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
i am relatively new to VB and i am working on a Visual Basic Program to build a Student Record Book where all the information is stored to an Access 2007 database. If the user is an administrator they will be able to add a new student, update delete etc. I managed to implement INSERT/DELETE/UPDATE functions and also a search button and they all appear to be working fine.
View 4 Repliesi have 2 queries in vb.net with an if clause -
if x=0 then
insert into table1
else
update table1
both queries have 5 fields. now what i want to do is after this insert or update takes place, i need to look at this inserted/updated record and compare it with another table (table2). Especially for update, i have 5 fields in both tables. if any of the 5 fields dont match with table2, then i insert a new record in table 2 which is the updated record in table 1.
I am doing examination using vb.net but my has some error .[code]...
View 1 RepliesI am using AdWords for advertising my products. But in a last couple of months number of products have doubled so I don't have enough time to optimize AdWords campaigns for all of them. Some campaigns have thousands of keywords so I am looking a way to automate my AdWords campaigns.
I know about AdWords API and client libraries. I have been investigating them for some time and they are not so easy to use. I want to focus more on optimizing my AdWords campaigns, and not on communication with AdWords server. Does anyone know about some VB.NET library that would allow me to download my AdWords data, investigate it, modify it and then upload modifications back on AdWords server?
I have automate ssh to Linux box using vbs script (to log in and execute commands)
but i need to make a tool which edit the vbs values and execute it
Brief vbs script set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run "plink.exe -v -ssh ubnt@192.168.1.20 -pw ubnt -m UNIX_commands.txt" WScript.Sleep 2000 WshShell.AppActivate "192.168.1.20 - PuTTY" WshShell.SendKeys "conf term{ENTER}" as you can see it is first run plink.exe (ssh client) with specific User name & password and load specific commands to execute on Linux box from UNIX_commands.txt which located in same directory
[Code]...
Working with dynamic button. So if i have 5 buttons created dynamicly, i can get alot of information from the button click of that button. You click a button on this app, it will show the name of the button.
But now I want, lets say button 4 to click at 4:45 pm today. Normally I would do something like compare a string to "4:45", and when true, then button 4.Perform_Click.
But button 4 is dynamic, so how do I call that button in my code. How can I address it. I know it will be there when the program is running, I just don't know how to get to it in code.
Now I do have the button names in a database, so I can get the name that I want from there. Just not sure how to tell it, "Do a perform click on button 4" The code below is my test bed, so If you click the main button, it will create a button, and a timer. Click the button that was created, and it will show the button name.
[Code].....
I'm currently trying to teach myself VB. I'm trying to automate a web-browser to go to a certain website. I wish to place the script on my desktop. But I keep getting syntax error 800A03EA. Here's my code.
'webbrowser.vbs'
WScript.CreateObject(' "InternetExplorer.Application" "IE_" ' )
ie.Visible = true
ie.navigate("www.google.com")
Public Class Form1
Dim IE As New Object
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
I want to code some thing up that logs you into a site and automatically posts to it.
I heard you need to use httpwebrequest but I've seen literally almost every tutorial on the subject and I am still super lost.
Also, is it possible to automate the built in web browser? I coded a semi-automatic program in the past but I want something automated.
code snippet in visual basic 2010 to automate the webcam to click a picture based on if any key is pressed on the keyboard?
View 1 RepliesI use the following vb.net function to purely save Word documents (no text input whatsoever, I'm only interested in mass creation of empty word documents at the moment):[code]The OFDD variable is the name of a folder browser vb component, and its SelectedPath property combined with the cname and acctype parameters provide me with the name of the Word document I want to create and save. Here are the declarations of the counter, wordDoc and wordApp variables:[code]The wordDoc variable is assigned to a Document object by use of the second line of code in the subroutine createDoc. However, it appears that at the 83rd time that I'm trying to retrieve a document object and assign it to wordDoc I receive an exception stating that "Command failed" . I can tell that it's the 83rd time I enter the function because in my catchblock I print the value of counter in a message box, right after printing details about the received exception and right before I release my used resources and end the process.
Worried about whether my system has limitations related to MS Word automation, I created another Visual Studio project (a Console project, this time), referenced the Microsoft.Interop.Office.Word namespace and wrote the following simple module:[code]Which works perfectly. Checking my filesystem, I see 150 word files created in "C:WordTester". [code]
There is a website and it has excel file. Daily I login to it and open excel file update, save and close it and then logout. This I want automate using code.
View 2 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
I have been attempting to automate a process in a webbrowser control. When I attempt to fill out the form and submit, I get a false negative response (meaning all the data in the fields are correct but I am getting an incorrect response back from what I should be getting). I have determined that this problem is due to the fact that when I manually type out the data in the input fields a javascript is being fired. I know that you are able to invoke the javascript, but as I have no real knowledge about javascript and the script is rather complex I am stuck.
A temporary solution for me has been to use SendKeys, but this is no real solution at all. If the window loses focus, the entire process goes out the window. I cannot just use the .SetAttribute or .InnerText methods for the elements in the window.
I'm not sure if any of you are familiar with WatiN but I have used it recently while looking for other means to do what I need to do here. Watin works, but instead of allowing me to use an embedded browser object it shells new browser windows. Anyhow, with WatiN I am able to minimize or hide the browser window and the code will still execute. This leads me to believe that there is a way to simulate keypress events in a browser window while making sure that the specific element is the active element.
I have searched all over the internet for this (but am sure I overlooked a few things in frustration) and have yet to find a solution that works for me.