I am not too advanced with vb.net and up until now any programs I have created that needed a database were for personal use and due to the nature of why I needed the programs, I utilized excel in the code to store the data.
Recently, a good idea and plenty of inspiration sees me currently creating a game for users other than myself.
The game will include a built in "Auction" site. I would like to add the feature to sort said auctions in several ways, (i.e by price, by time ending soonest etc etc).
I was using a simple text file to manage the Auction data which was working fine until I decided to add the above sorting feature. Now it is just becoming inconvenient and I am wasting time and computer resources managing the database.
I am not sure how things work on the other end of the program. i.e I assume that unless end-user has excel or access, they cannot use a program where excel and access are a part of the program's function, therefor the reason I used a text file as the database is because I know most end-users have .txt function.
Firstly, am I right in this assumption?
And if yes, what is the most convenient way for me to add a localized database to my program so that any user with a windows system can play my game without the need for an internet connection or any other third party software?
Some trivia if it helps:
The Auction Database is small. It will have 17 fields/columns with 250 entries/rows per field.
As Auctions end every 90 seconds or so, and due to the dynamic nature of an Auto-Bid feature as well as End-Users bidding, my concern is with updating/saving the database after every auction-related event to prevent loss of data should a program be terminated incorrectly.
There exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
I'm trying to see if the microphone on a PC is working correctly by utilizing the SpeechRecognitionEngine class.I'm using the following
VB.NET Dim RecognitionEngine As New SpeechRecognitionEngine(New CultureInfo("en-US")) 'Dim synth As New SpeechSynthesizer 'synth.SpeakAsync("Microphone")
[code]....
When I run this code, the microphone runs until it detects a sound. If the room is silent, it never stops. At least so much as I can tell so far.But I need a way to detect when it can't detect a sound within a specified interval.I looked on MSDN and all I could find was a property called, BabbleTime. I can specify a TimeSpan that will time out the speech recognition, but from that, I can't determine if it was the timeout that caused the code to continue or if it detected sound.
I have created a class (pasted below in case I did something wrong) for which I want to create an instance that is usable across forms/modules. I can create an instance of the class in a single form/module no problem via DIM User as New User but how do I go about create a public instance accessible from all parts of my program?
I am new to the world of VB.NET and have been tasked to put together a little program to search a directory of about 2000 Excel spreadsheets and put together a list to display based on the value of a Custom Document Property within that spreadsheet file. Given that I am far from a computer programmer by education or trade, this has been an adventure.
I've gotten it to work, the results are fine. The problem is, it takes well over a minute to run. It is being run over a LAN connection. When I run it locally (using a 'test' directory of about 300 files) it executes in about 4 seconds.I'm not sure even what to expect as a reasonable execution speed, so I thought I would ask here.The code is below, if anyone thinks changes there might be of use in speeding things up.
Private Sub listByPt() Dim di As New IO.DirectoryInfo(dir_loc) Dim aryFiles As IO.FileInfo() = di.GetFiles("*" & ext_to_check)[code]....
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
I am on a windows application form where people can log in and add status ... and it's all online via sql database.
What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time the status have been changed .
this what do for summing total records....when it's integer it's fine ..but i m doing summing for time...late_time is datetime...it gives me error..how can i add all total time from ltae_time column....???
I created access database while runtime. Now I want to know how to set a time format in that created date/time field. I need to set as Short time for that field.
I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so I am assuming I have to choose "Add Connection" first ...[code]...
I have an app that I have made. The application generates 14million combinations of numbers and inserts them into an Access Database. As you can imagine, this takes AGES (whole night) to compute. Is it possible to make the same method call twice so instead of one combination being generated and inserted, two or more are?
My objective is to connect my application to a database for the first time. I've never done this before so it's essentially a learning exercise. Within visual studio i've followed the "Connect to database" in the Tools tab and followed the connection wizard. My understanding is i need to connect to my local sql server (this may be incorrect) and i cant find it. I'm not sure how to even get started, what do i need to download in order to create a database on my laptop?
I m writing a Auto Sms Sending application which will work in the background. I m using VB2010 and Sql 2008 This application will check SMS table every 5 seconds to check new records if it finds a new record it will sent three sms at an interval of 6 hours.The problem is I don't know How to Extract Value of a 'Time' Column and Compare it with system time.i simply want to Compare value of 'Time' column and system Time if Time Deference >= 6 hours the application will sent SMS
i need to get date from database table and compare it either it today or tomoe..after that need to compare time.I got table where the format is 'datetime' contains like = 4/11/2010 12:00:00AM'....so i need to get the date only...how to do that?...when get the date ...ithen i need to compare a time.
with two fields each and write the results to a third Access database as part of a data mining program with finance applications.Here is the code in question:
Imports System.Data.OleDb Partial Class Form1 Dim DMDatabase01 As OleDbConnection = New
I am converting an application to work with SQL.I need the application to monitor a specific table, so it can instantly pick up on changes.The sql server database is on the same machine.The table it needs to monitor is called MaintenanceRecords and it is inserted into via web service.I need to display a message in my VB project when an insert occurs in MaintenanceRecords table.
I would like to update an Access database at a particular time.For example:I have a startdatetime = 11/08/2011 8:00 AM.I want to update the database when DateTime.Now = Startdatetime.AddMinutes(30)I thought about using a Timer, but i am not sure how to update the database when the timer stops.Note: This statement will be in a loop, because I will be updating e.g For i = 1 to n
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
I'm using ASP.NET/VB and I'm trying to insert a date and time into an Access date/time field, but I'm getting an error (Data type mismatch in criteria expression). Here's a simplified version of my code:
Dim myDate As Date = Now() Dim myIns1 As New OleDbCommand("INSERT INTO tableCourse (date_submitted) VALUES (?)", myConn) myIns1.Parameters.AddWithValue("@myDate", myDate) myIns1.ExecuteNonQuery()
Not sure why I'm getting the error, and not quite sure if this is even the correct way to approach inserting the current date. From looking at other similar questions it appears there are a few different ways to do this, but my technical knowledge is kind of limited so I'm having a hard time figuring it out (in other words deciphering the answers that use technical terms I know nothing about).
I just started using VS2010. I am very familiar with Visual Basic 6 and was very comfortable with it.I was able to take a variable and assign a database field to iwithout using data binding. I can't seem to figure out how to do thatin VS2010 What I am trying to do is have the use enter a password to gain access to the program. The password is stored in a database so that the user/owner can change this password to suit their preference.
I have a date that I retrieve from database. I want to give ability to edit time on my gridview, as my date is date+time, I want to show the time on my database as my selected value on the dropdown list and a ability to choose other times from the list and save back again with date+time on the database.[code]
I am trying to insert date and time in dtime column in oracle database by using this code but it gives me following error ORA-01830 date formate pictures ends before converting entire output.
I like to update data from an access database every 100ms. This works fine, but it does not look good on the screen. It refresh the whole screen on my laptop and it is not looking good. Is it a good way of updating data without getting this disturbanses in the screen?
I want to store date time picker into database .I am using date to search my reservation information and how is the code for search out the information from database.
