i'm using a timer to open a database and drop in a few fields of info, such as date, time and 3 traces.
the timer interval is set to 1000msec, but after its been running for a day or so, i've looked into the data and i can see there are periods where no info has been logged. sometimes its as little as a couple of seconds, and other times its upto a couple of minutes.
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I am fairly new to VB.NET and I am working with an service that implements a timer. The timer action will do some work and then log success/failures to the event log. I am noticing that each time the event log is written to the memory usage of the executable shown in the task manager increases. It does not increase by much, maybe 20k or so. Is this expected? The code below is an example of what I am doing that is causing the memory to increase.[code]......
View 1 RepliesUsing visual studio (Winforms) with sql server (R2). If you can login by inserting the correct values in the textfields (vb.net) that is connected in the database . How do i code the log out?
Data Logging Through Serial Port For Gps
View 1 RepliesI want to create a program in Visual Basic Express which will log into a website byinputting the user name and password for that site and then retrieve certain data fromif such functionality is provided in Visual Basic Express, and if so, what is the method for
View 2 RepliesI want to write my own Datalogging example. But need some simple examples to start from.
View 2 RepliesI've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script etc.
View 1 RepliesHi how's it going. In the middle of coding a banking application for a project. Part of it involves mortgage interest repayments. Was wondering if there was any way of logging the time a new record was created and added to the database and then adding interest to the balance owed periodically every 30 days..
View 3 RepliesFor the past year-ish i have pretty much mastered the httpwebrequest function of programatically logging in to 1 of my websites to retrieve data, while it works well i was thinking about the webbrowser function, would i be better sticking to the webrequest route? it looks like the webbrowser requires much less code which is good lol can the webbrowser do everything httpwebrequests can?
View 1 RepliesI can log into a website great using the webbrowser function then have the fields filled in and the submit/login pressed, i am now trying to do it so i don't need to use the webbrowser function, ideally what i intend doing is grab a piece of information once logged in.i have searched a lot and i know i need to use webRequest and webResponse for this, the part i'm having trouble with is how to deal with posting the actual data to the website, in the webbrowser way you can see the input fields filled in for you but i'm not sure how to post the data this way?
View 2 RepliesI'm writing a VB.Net app using SQL Server 2008. I want to use exception handling but it appears that the way to do that in SQL Server 2008 has changed. I've read about a configuration console to create an exception policy for my app. Where do I find this configuration console?
View 1 RepliesI'm trying to login to a forum based on given details (username + password textbox).
Here is my current
Dim id As String
Dim password As String
Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX1.Click
If TextBoxX1.Text.Length > 0 Then
If TextBoxX2.Text.Length > 0 Then
[Code] .....
But I'm having trouble clicking the "Log In" button on the top floating bar. And the page I'm trying to login to: [URL].
I'm wondering if its possible to log who is connecting remotely to my local hard drive and also log what they do if possible?A lot of people access my hard drive and im curious to what they do while there.
View 1 RepliesAs of now I have the POST data down and am sent to a 'Redirecting..' page.Here I am able to grab some data from the HTML that will be required in future requests.It seems that now, however, I need to authenticate myself.Packet sniffing the data, here is what I need to imitate for a successful login:
HTTP/1.1 302 Moved Temporarily
Set-Cookie: GoogleAccountsLocale_session=de
Set-Cookie: SID=DQAAAG0AAADLKo0PYiFiKAFeYWFSWc8CDvKmmRDmpLLQlmkK0VgnaSxNeLk1FH9rZZ_ztotu-
[code]....
Bolded are the pieces of data which I can extract, underlined is the one I'm not sure of.Anyway, how can I go about setting these cookies to an HTTPWebRequest (well, multiple requests but just the one object)?
I'm trying to use WebBrowser to remotely log into a site and perform a basic action on the site.I'm running into problems though so maybe you brilliant people The first step is logging in to the site. Here's the form code for the login:
<form action="" method="post" id="loginform">
<input type="text" name="username"/>
<input type="password" name="password"/>
[code].....
WebBrowser1.Document.GetElementById("Windows Live ID:").SetAttribute("value", "Textbox1.text")
WebBrowser1.Document.GetElementById("Password:").SetAttribute("value",
[code].....
Is it possible to use a timer to delay code? For example:
[code]...
I'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 RepliesQuick question - if I have a timer set to 5000 (5 seconds) and the code in the timer takes longer than 5 seconds to run because of sql stuff, will the timer wait until the code is done till it fires again?
View 3 RepliesI'm wondering what exactly is the difference System.Timers.Timer and System.Windows.Forms.Timer???
View 4 RepliesI'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 RepliesIs it possible to insert/put a Timer inside the Database?Let say in my Database/Tables i have MemID, Name, Membership Date and Status (Active/Expired).for example MemID [ 1 ] Name [ Juan Paolo ] Membership Date [11-17-10] Status [ Timer ]in Status is it possible to save the time even while the program is close?..or code like if MemID 1 reach 2 Days all of the information of MemID 1 will be clear and Status will become [ EXPIRED ] , while timer is running the Status is Active, and if the Timer Reach 2 Days the Status will become [ EXPIRED ]
View 2 RepliesIm currently writing a sort of Tamagotchi game or "virtual pet". It's really basic, it runs on timers and has a health meter, hygiene, happiness etc. The problem I have is when the program is closed it obviously resets the properties back to the origional settings. Is there a way I can save the state of the program so when the user opens it back up it is as the same as of the point when it was closed?[Just had an idea, would I set a timer to periodically save the value of the variables to a database and then have them load the next time the user opens the program, for example if the health was 50% on closing or at intervals it would save the health into a column in a db table then when the user re opens the program call that db?]
View 5 RepliesIm learning how to work with databases. So far I've created the database (FirstDB.sdf) (without a dataset - because I'm not exactly sure what this is and why it would be needed?)
[Code]...
My Question is. What code do i need to put under the AddDataButton to get the Values of FirstNameTB, LastNameTB and YearTB into the relevant columns in my Pupil Table?
I currently have a program that, when I select an option from a drop down menu, will transmit a character to a microcontroller. I then have to click another option after 10 seconds to send another character. What I would like to do is modify this program to transmit one character for a period of 10 seconds, then transmit another value for another 10 seconds and so on for a defined period of time, say 30 seconds in total.
View 1 RepliesI used to be a web developer in vb.net 2008 , now i get involved in some projects with application development. Which is the right way i mean the proffesional way to connect to database , syntax a query and bind the result to datagrid?I see 2 ways , the first is using the wizard i mean drag to the form the databinder from the toolbox and follow the wizard step by step , the second way is the same way i used in web development i get the connection string from app.config , syntax a query inside my code and follow manually steps to retrive the data from a database.which way to use for a large application projects?
View 5 RepliesAt moment iam trying to fetch some data out of a mysql database.hope i can explain well what i try to do.Okay i made a form with some text field and a combobox.What i want is at start when the form loads that all the last name will get catcht out of the mysql database. all those last names should go in the combobox.now i have a few textboxes like adress phone number living place go onWhat i try to do now is when all those lastnames are in the combo box when i select a nameand press the button to update that it will catch the info from that user out of the mysql database and puts the info in the right textfields.What i got so far is a succesfull connection to the mysql database.
How do i know that my login to the application is also connected to the database and that one works fine ;)the only thing i cant manage is to take the data out of mysql and put it in the textfields.i made a form called test to testthis out so far this is what i have on code
[Code]...
Access data from a .sdf database (2008)?
View 4 RepliesI've a question about vb.net application with ms access 2002 database.I use "Add data source" wizard to setup a connection to a access database.my application read text file into a temp data table at runtime.a button click to import data from temp table into one of access table.problem is data is not added at all.here is the code I use to do update
For Each dr In dt.Rows
DataSet1.tbl2.ImportRow(dr)
Next
DataSet1.AcceptChanges()
TableAdapterManager1.UpdateAll(DataSet1)