I'm using a database to store a load of data and some of which is the date from a datetimepicker and its storing the date and time for me. but its not saving the date and time for me its just leaving it blank any ideas
i set up the database vis the database creater in VB 08
call the field Dateout and the other column "Datetime" and i would of thought that would of saved me date and time.
in datetimepicker_value changed section ive got it down as datetimepicker.text as now.date.tostring
I am new to ADO.Net and I mistakenly using the dataset as how we use recordsets in ADO., I know that it is possible to create a Datatable which will only reside in the memory and hold data. What I need to create is like this.
1. Create Datatable. 2. Fill it with sample data at least 3 lines. 3. Transfer the data from datatable to database (access,sqlsrvr etc).
I'm trying to use a combo box to change the image in a picture box to one that's stored in an external folder. The plan is to, in code, take the part of the file's location that will be constant and concatenate the file name to the end. The file name is stored in a database.
I used a code to get the dates between 2 dates from the database (column with dates dd/mm/yy) , I think it works nice first time,[code]as you see , the code let the user to insert a number and minus it form the date of today , then calculates the date that I want , after that I use BETWEEN Clause to get all dates between them But now , this code gets some data and overpasses others , I mean some of the dates is between the tow dates but the code never get it , why that happens ?
my problem is want to use WHERE clause to extract only year that fulfill a specified criterion. My coding as below, the coding below is extract all the month,day and year. But i only want year only. I am using MS Access. My textbox(cbYear) can select January To December. Can anyone give me a guideline to correct the coding.
sql = "SELECT * FROM sumPercent WHERE plants = '" & yieldsummary.cbPlant.Text & "' AND [b]dates = #" & cbYear.Text & " #[/b] AND line = '" & ds.Tables("sumPercent").Rows(a).Item("line") & "'"
I have an accounts program. My cash book shows data based on date picked from DateTimePicker. Cash book is not entered everyday. I want to make my datetimepicker so that based on dates found in the database, it changes colour or enable / disable some dates, for which cash book has been entered. How is it possible?
I am currently making a college project for which i need to send scheduled emails.I googled for it and found out the we can do it through outlook. Is there any way to automate that process through vb, so that it will check for the dates in the database and send an email whenever necessary?Outlook is not important for me... I just need to send scheduled emails.And i even need to send sms (single and bulk) according to the needs... is there any free API for that too???I have already tried the google sms feature but it didnt work for me
I have a field in my database that holds dates as strings in this format: dd/MM/yyyy Now I want to load then into a var as dates vb.net Dim dte as date I am having problems with the format. Vb doesn't recognize my date format as a date when I use this for expample:
vb.net Dim strDate as string = "22/05/2010" Dim dte as date dte = CDate(strDate)
I'm working with time and attendance application and i need to do something will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
I'm working with time and attendance application and i need to do some thing will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
textbox1 for inserting start of employee code textbox2 for inserting end of employee code textbox3 for inserting the date and time for enter textbox4 for inserting the date and time for leave
I am reading dates from a table in a database to display in a DataGridView column that is formatted as a date. The problem is that when the value is null in the database my program errors out because it cant convert the value to a date. How do you guys handle this? *Edit: If I set the value of my date variable to "Nothing" it displays as "1/1/0001" in my DataGridView, and I would like the cell to be empty for the null dates.
I am currently using VB. I want to do a Calendar Control which have dates highlighted/selected. All these dates are retrieved from a database.
how to put all the dates into an array Second thing I need to know is how to highlight all the dates in the array.
I have done some research on the internet and they said something about selectedDates and selectedDates collection and dayrender. But frankly speaking, I can't really find any VB codes regarding this. Dates format will be in dd/MM/yyyy
Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page
I'm using one Access Database and DataSet, BindingSource And Table Adapter. My question is: how to fill one listbox on my form with dates from one row from Database.
Look at the picture:
[url]
So listbox needs to have 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20.
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information DVD Information Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb] SELECT [Member Information].[Member ID] FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
Ours is a transportation company. We do services/transportation/logistics for various companies.I am working on Scheduling a work order process for those companies who are registered with us.While during the process of registration, a company will specify the week number to execute a job during the contract period.So this will be a routine service which we need to perform for every number of weeks specified For Example: if any company specifies the week number as : 2. that means for every 2 weeks we need to do the service for that company during the contract period.
How to update the dates into the database server for each company for their jobs to be performed.So if my Admin wants to know all the jobs in this current week. I should be able to pick only those companies and their jobs in this week only.
I'm using two datetimepicker controls to set the start and end dates for a range of dates I'm searching for.I want to make sure that the start date selected is not greater than the end date. This code works, but it runs the messagebox prompt twice for some reason. I've tried to ignore it from doing this, but it's not working. Can someone tell me what's wrong?
Private Sub dtpStart_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpStart.ValueChanged
I have one more problem with MonthControl.And when I bold some dates the program doesn't show bold dates on month calendar.When I move on next or previous month and get back to currently month the program normal displays bold dates. What's the problem?
In an attempt to find more or less understandable tutorial I have spent the last 2 days googling and reading, and still couldn't find the answer to my question. So that I decided to ask here:I am intermediate in VBA. I have been programming the tool in Excel, that takes some data from Oracle DB and manages it, stores in tables, shows in forms, creates new SQL-Queries, extracts further data from DB etc.
Couple of days ago it was decided that this tool should be a separate executable multi-user application (cause it actually doesn't have to do anything with Excel). Being still a student, I have downloaded the Visual Studio 2010 for free, bought couple of books and that was it... being stuck at the beginning..My problem is: I have absolutely no idea where to start from. I could have started drawing forms with controls, but I am concerned this ain't a right way. What about the GUI? What about the functionality scatch? What shall I start from, having code in VBA?
So i am currently working on a project about enrollment system and I am having a problem with transferring items from one listview to another. Here's a photo:
I want to be able to transfer from the lower right form's listview to the other form's listview.
I'm currently working with a project where I need to transfer the internal audio (sound from the computer) to another computer and play it back there.
I thought of transferring the audio with a TCP server-client connection since I already have the knowledge of how to do that.
My problem now is that I don't know how I would capture the internal audio and how to be able to play it back as a stream on the target computer. I have searched a bit and many people recommend using MCI but I'm not sure if this will work on an "almost realtime audio stream" connection.
So my question is: What is the best way to grab the audio from the computer and then play back the data on another computer (as a stream)? I want to do it in realtime and not "recording" the sound and then send it to the target computer.
I have the following code in place: Protected Sub btnBuy_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBuy.Click Session("ShoppingList").add(New OrderInfo(txtQuantity.Text)) Server.Transfer("ShoppingCart.aspx") End Sub
