I am creating my Excel great, except that a field that contains numbers ie 1-10 or 2-5 keep getting changed to the equivilant in date. I don't want dates. If I format to text, then it cuts off part of the original data.
View 1 RepliesI am Importing a Excelsheet(xls) in to my Application, but the date and Number column showing blank in dataset when comes to application. The values are there in Excel. Any other way to import the excel sheet to application, so that i should get all the values same as there in the excel sheet.
View 1 Replieshow can i add two excel sheets with numbers and the equal (similar)numbers to save once
View 1 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.
It seems that on clicking datagridview column header, the column will be automatically sorted based on the column type. I have a column showing some numbers. If column type is string, it sorts "1","20","3" into "1","20","3". If column type is double, it sorts into "1","3","20" which is the result that I want. However, there might be some erros in the numbers and error messages(text) will show in the cell instead of numbers. So I cannot set the column type as double. I want to ignore these error messages and sort all the numbers. How can I do this?
Also, I need to add some background colors to different rows in datagridview. So in the column header click event, I call the bkgColor Sub to achieve this. My question is that how can I override the sorting method in this event?
Private Sub DataGridView1_ColumnHeaderMouseClick(sender As Object, e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView1.ColumnHeaderMouseClick
Try
[code]....
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 RepliesI have an access form that shows a data table. when the form is opened, I want to filter the data in the date column to show only the records that don't have a date entered into the field.
View 8 RepliesWould it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 RepliesI have a calendar column which is generated on from load. Its value is assigned to todays date - for instance 04/04/2012
I also have a comboBox with a list of months.
Is there a way I can change the value of my calendar column to reflect the chosen month?
For example, if I select January from my comboBox then have the date as 01/01/2012.[code]...
It is supposed to change the forecolor if the listview date in the first column is less than label 3's date.
For ii = 0 To Me.ListView1.Items.Count - 1
Dim iInvoiceDate As ListViewItem = Me.ListView1.Items(ii)
If iInvoiceDate.ToString < Me.Label3.Text Then
[Code]....
No errors and all the variables are returning what i am expecting but it doesn't change the forecolor.
I am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet
how can I create following thing with Visual basic?I would like my excel to check the date value in a cell and compare it to current date and if the value in the cell is older than 2 months compared to current date it would change the cell's colour.
View 1 Repliesi need to do a macro. this is what my excel looks like
1 2 3 4
seq1 name name seq2
abcde vv1 abcdddd
abcxy vv2 abcdlmn
[code]....
I would like to know how to coding in VB 2010 as this problem:The sequence numbers I want as the following:
Date 08 October 2010 --> 10-10-08
The first number is --> 10-10-08-01
The second number is --> 10-10-08-02 and so on
Date 12 October 2010 --> 10-10-12
The fourth number is --> 10-10-12-04
The ninth number is --> 10-10-12-09 and so on
How can I do it?
i have the following setup What i am trying to do is, when the user clicks on the 'calculate age ' button it must calculate the age and display the result based upon the selection in the combobox i.e if 'Days' are selected then it must display in days, if weeks are selected then it must display in weeks..etc
Similarly when the user clicks on the 'convert to date' button , it must subtract the given days(or weeks or months or years) from Todays date and set it to the maskedbox
I have a datagridview with a column called "Total Price". This is set to a string value type because I need to always show 2 decimals. For example:
4,3
must be in the datagridviewcolumn:
4,30
So I use string.format for this. However, now I have a problem with sorting because the column is a string value type and numbers get sorted like this:
50
4000
40
300
30
20
10000
1
How to override the sort method or something that is called when a user clicks on the column header and the most effective way to sort it programmatically?
For my database I need to create unique numbers and insert them in the column "ID". Can I add them via a SQL query? The numbers would simply be 0001 to whatever.I'm using the "Show Table Data" gui.
View 7 Replieshow do i go about creating an id column in a form using sql database which generates numbers automatically?
View 2 RepliesI have a DataGridView1 where I have 6 columns and 0 rows (they are added additionaly in the application) and also have a TextBox1. How can I calculate all data from the second column to the TextBox1? For example, I'll run the application and add rows, where the text in the second column will be: (4, 8, 9, 1)... it means 4 rows...
So how can I make the value of those numbers (22) show in the TextBox1, so that it will calculate the numbers and show the sum in the TextBox1?
I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from another table (tblMain) linked in this table (tblPrem) where it is the primary key, and just repeatedly generated after the clicking save button. Here is my current code which saves the data but does not do anything on the textbox1 + textbox2, and has an error message "At most one record can be returned by this subquery":
sqlQrySave = "UPDATE tblPrem SET premamt = " & textbox1 & " + " & textbox2 & " WHERE premno=(SELECT MAX(premno) FROM tblPrem GROUP BY contno);"
What I expect to happen is like this:
contno | premno | premamt
1................1.............45
1................2.............45
[Code].....
I found this from a Google search and I need the VB.NET equivalent to Martin Liss' code
Dim lngIndex As Long
Dim lngTot As Long
For lngIndex = 1 To lv.ListItems.Count
lngTot = lngTot + lv.ListItems(lngIndex).SubItems(1)
Next
[Code]...
Value of type 'System.Windows.Forms.ListViewItem.ListViewSubItem' can not be converted to 'Integer'Basically, I need to total up a number column in a ListView.
I have 5 columns of 11 textboxes each on my form the textboxes are generated with this code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'column 1 textboxes
[Code].....
i need a code to generate all the possible combination of the numbers a user types into the textboxes i have two images (Panel3: the textboxes where added during design time) image2: the textboex were added using the code i gave about
generate all the possible combinations of numbers typed into the textboxes (Example see panel3.jpg image),
The user will type in the desired unique numbers into the textboxes without repetition (Please see the image i did not repeat any number, so can the code detect when a number have been typed twice?) Else when running the program i will be carefull not typing two numbers twice, but its adviceable to detect when a number is typed more than once.
Then the amount of unique number the user will type or supply to the desired textboxes does not matter here and as you can see in the image the amount of numbers in each column is not the same ie it may or may not be same amount (but number must be unique. Please try and see if it can be done to prompt user to enter the amount of numbers to supply in each column)
Then After supplying the numbers just like the one in Image, The button Click will generate all the Possible Combinations of the all the numbers typed into the textboxes in the columns.. Then After generating the combinations in the Listbox, the next Button will be able to delete them from the Universal 90c5 just like the former.
i have wrote a loop to search for duplicate numbers within a column in a database which i have got fine but when i find a duplicate i would like to get the all of the row so if 33 was a duplicate i would like to get the following row.
33MarkWhitesideM12/07/1958Michaeluuu
I have tried to do this buy use something i saw on msnd's website:
Dim foundRow() As Data.DataRow = customerDS.Tables("Details").Select("HNCNO Like '33%'")
However if i change the line to notice the i beside the like
Dim foundRow() As Data.DataRow = customerDS.Tables("Details").Select("HNCNO Like 'i%'")
but i get Index was outside the bounds of the array. Ok i know that means that there is nothing in my array. What i would like is to find the duplicate row associated i. you will probably understand me better when you see the code.
Private Sub checkRowsForDups()
Dim customerDS As DataSet
Dim dupArray As New ArrayList
[Code].....
I have a question regarding unusual date format. I have validation set to where users must input 8 digits for the date that I intend on formating dd/mm/yyyy. Is there a date function in .NET that I can use or am I going to have to manually set up my own function to output those numbers in that format?
View 2 RepliesHow do I get the current line and column numbers in a RichTextBox in a Winforms application?
View 3 RepliesI haven't used VBA in a very very long time. So, go easy on me. I'm trying to do an IF THEN ELSE function where whatever the pVal cell says, Excel will input the correct currency value in the next cell. I have the cell format in the Excel workbook set to currency with 2 decimal places. However, when I add the UDF, it rounds up! I basically copied and pasted this code from an online website, but theirs did not have any decimals. I've tried calcvalue = Format("48.95","Currency") but it still rounds. I'm sure I'm leaving out something simple. Here's my function formula so far.
[Code]...
I'm using EPPlus 2.9.0.1 with Visual Basic.I have a DataTable with 35 Rows and 4 Columns and the code below:[code]When method 'LoadFromDataTable' is called, I get an ArgumentException (Negative row and Columns numbers are not allowed). I don't have negative numbers in row or column numbers, as far I know.
View 1 RepliesI'm trying to add a string to a access database, for a column that was originally designed for numbers, i have changed the data type under the design view from number to text, yet I still get a error saying that it cannot convert the string expected int32
Input string was not in a correct format.Couldn't store in Parent_ID Column. Expected type is Int32.This is the full exception, i would have put it into code display but the option wasn't there
System.ArgumentException was unhandled
Message=Input string was not in a correct format.Couldn't store <A-238> in Parent_ID Column. Expected type is Int32.
Source=System.Data
StackTrace:
[code]....
I am looking to print invioce numbers on stationary. So, for example, the invoice number is located in cell I1 of the excel spread sheet and starts at 100600. I want to print 150 invoices with the invoice number going up by 1 in each increment. So, I have thus far written:
[Code]...
What i need to achieve as you can now see is that the macro picks up the invoice number and does this however many times (or however many invoices I want to print.
currently i need to use 4 different texts files in order to read data and run my program, is there any way that i can just use 1 text file or 1 excel spreadsheet? here are my codes now.
Dim File1 As New System.IO.StreamReader("C:Documents and SettingsUserDesktopWindDirectionLanding.txt") 'Calling out the file.
Dim File2 As New System.IO.StreamReader("C:Documents and
[Code]....