My table looks like: Id | _date | about The "_date" is formatted like: 2011, 10, 17 and the "about" is simply text.[code]...
1) I keep getting the error that my command is incorrect. I don't see what's wrong with it.
2) how do I fill the monthcalendar with the dates? (row _date)
1. How can i show the weeknumber in a label from a selected date in a monthcalendar ??2. How can i show the dates from that whole week in 7 seperate labels ??i'm using vb 2005
View 7 RepliesI'm trying to bold dates on a monthCalendar control. Here's what I've got, but it's showing an error of "'Add' is not a member of 'System.Array'.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim calendarArray() As DateTime
[Code]....
All I want to do is bold all of the dates on the calendar that there are files for.
I made a small program that's a calendar that allows you to add notes to selected days. Then when you click on the days again it retrieves and displays the notes or allows you to edit and so forth. It works through an MS Access db. I want the days that have notes to be highlighted or bold. I know this bit of code works, for bold :
[Code]...
How can I change the color of certain dates in the MonthCalendar control in VB.NET? For example, I need to change the color of Jan 21 to Red, Sundays to Orange and so on...
View 3 RepliesI'm Using MonthCalendar Control in my Form to select Multiple Dates. (for eg. 1st April,20th April,25th April). I'm planning to Change the date the user clicked by making it BOLD during run time, so that i can retrieve the results in a Date array. [code] MessageBox clearly shows the date selected, but no effect for the "addboldeddate'.
View 3 Replieshow to load multiple dates onto a month calendar so I could see them all on it. I will need to load the dates from a database on it but if for know somebody could give me an example on how to load at least 5 dates on it that would be good start.
View 2 RepliesI try to make a loop in a table using dates i have this in a asp kode but can't make it work in vb
For i = CDate(strfradato) To CDate(str2tildato)Error1'For' loop control variable cannot be of type 'Date' because the type does not support the required operators.
I am using VB.NET as front end and oracle 9i as db my problem is this i am writing this query to fetch records between two dates from Key_rec table but the problem is this when i enter the report using dtpicker1 and dtpicker2 these two values goes in txtfrom and txtto then i press view report button but it shows blank report but when i enter the date manually from key board it works fine its mean nothing is wrong with the query there is some problem with the dtpicker1 and dtpicker2 here is the query on btnrep[code].....
View 5 RepliesI have two tables: a schedule table that contains information about how an employee is scheduled and a numbers table in which each number corresponds to a date.
[Code]...
I can do this on the SQL side or the code side. I have Linq at my disposal if I need it. The table doesn't need to be compiled by SQL. This will happen dynamically on a website and should be as efficient as possible.I don't want to have to iterate through each and look for breaks in contiguous days if I don't have to.
I have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 RepliesSay the user specifies these two dates....
Start Date: 2010-12-05
End Date: 2011-01-15
If I select December 2010 I should get the folllowing
startdate = 2010-12-05
enddate = 2010-12-31
Select January 2011 then
startdate = 2011-01-01
enddate = 2011-01-15
Should I subtract dates? How can I get the start and enddate for the current month/year based on the overall start and end date.I'm coding in vb.net.
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
[Code]...
i need to show data from a table in a control upon which when the user selects a particular record a box should be displayed and he would add his comments for the selected record. I do not know how to pull the record and show it in which control>
View 6 RepliesI create a DataView that load a table from database.
Dim da As OleDb.OleDbDataAdapter
da = New OleDb.OleDbDataAdapter("select * from customers order by name", cnmain) ' I load complete table
[Code].....
�Thst's all I need? Because when I recover the first row of DataView filtered, it appears the first row initially loaded when I don't put filter.. �Do I need to refresh DataView to view te changes?
sample code or project on how to load a data of a particular table in access database in to a data grid view
View 5 RepliesI have a password protected database (.mdb) which has 2 different tables, and a DataGridView What I want to do is:
[Code]...
you would think that this would be simple, but with some sample code i found i could only get it to load and not save, or it would be written for a datagrid and not a datagridview.
I'm using the following code to import data from a text file into an existing Access table:[code]
View 7 RepliesHow can MS-SQL Database access wise vb.net
1-How can load data to combobox from table filed?
2-How can check how meany data in the database filed.
I have a jump table to relate the Customers and the contact, I want to load all contacts by a customer name.
Dim Q = From Cust In EnData.Customers Where Cust.CustomerID = ID Select Cust
ContactRow = Q.FirstOrDefault.CustomerToContacts.??? here I'm stock...
I receive this error using the following code when the executeNonquery() line I am trying to load data from refnum to a column in the table
The variable name '@refnum' has already been declared. Variable names must be unique within a query batch or stored procedure.[code]...
I'm receiving the following error when trying to use a table adapter to Load data into a form.
"Too many agruments to Public Overridable Overloads Function Fill(dataTable As BCPM_DDBODataSet.LTC_FBSDataTable) As Integer"
I'm using a TeraData backend and this is pulling up the form based on selection from search results.
Search Form:
Private Sub cmdSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSearch.Click
Me.lstResults.DataSource = Nothing
[Code]....
I have a DataGridView that has columns with a value type of boolean.To load the DataGridView, I load values into a DataTable then set theDataGridView.DataSource = theTable What value can I use in the table to load an intermediate check state?
Would it be better to use a check box control with a value than to use a column set to the boolean data type?
The check box is for display only, and will not need to be changed.
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?
View 22 RepliesHow to load data from database table and display in datagrid in VB.NET? I know how it is in C#. I am not familiar with vb.net.
View 1 RepliesI'm attempting to create and populate a table in a new Microsoft Access (Jet) database using VB.Net 2008 Express under Windows XP Pro SP3. The database and table are being created properly, but loading the table proceeds VERY slowly. When I am loading the table, no complicating factors that might impact performance, such as indexes or table relationships have been defined. The table to be loaded is made up of relatively short rows consisting of three single byte columns, and one (four byte) integer column. I am loading approximately 16 million rows, and this is literally taking hours, while the same data can be interactively imported into Microsoft Access from a .csv file in minutes. I am trying to batch load the rows, 64K rows at a time, in order to avoid the overhead of individually transacting/committing each row individually, but suspect that I must not be doing something right. Key code that I am using for this process is provided below.
[Code]...
I have written a program that requires a particular image to appear in a picturebox. The image will be 1 out of 114 possibilites and the correct one is determined at runtime. I have all 114 images loaded into resources and I have the program correctley selecting the name of the jpg. I have the name of the jpg set to a variable (string) named gsSBdetail and I can make the name of the jpg file appear in a textbox. What code would I write to make the jpg in resources with the name assigned to gsSBdetail appear in a picturebox? NOTE: I have all of the names of the jpg's in a table in a SQL server database and use a multi parameter query to select the correct jpg file name, which in turn is assigend to the gsSBdetail variable. Is ther a way to load jpg's into the SQL server table and just select the jpg file itself for the picture box?
View 5 RepliesIn the below code, it is supposed to load the data from the dataset, into the table, so that I can view and navigate the records.My problem is, that when the statement runs, it errors with:
System.Data.ConstraintException was unhandled "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
Here's the code:
[code]...
I am new to VB.net and want to know how I can execute SQL queries from within VB.net code. Example: I want to update some records in a table using SQL query on the Form Load event.
View 2 RepliesThis is one of those problems where there just doesn't seem to be anything of use on Google.Does anyone have any code snippets of how to achieve this? This thread: url...links to a solution but experts exchange has been a paid for service for a while now.Ideally, the solution needs to be able to handle any number of parent/child nodes.
View 3 Replies