|
I actually did a lstImport.Columns.Count right after showing the MessageBox that gives 24 and the count comes to 29.
I'm taking data from an excel sheet and trying to import it into the database.
|
|
|
|
|
Ok I did this:
index = lstImport.Columns.IndexOfKey("Category");
MessageBox.Show(index.ToString());
MessageBox.Show(lstImport.Columns.Count.ToString());
MessageBox.Show(lstImport.Items[i].SubItems.Count.ToString());
So the subitems only have 23, the columns is 29, and the index of category is 24. Now if I add this Category column AFTER importing the excel sheet into the listview does the item's not add those columns to the subitems? The values are blank.. but they should still see the new columsn right but just have no value?
|
|
|
|
|
I just went to a Datagridview.. thanks
|
|
|
|
|
And I bet there are some blank columns on the right of your data which probably failed when loading into the listview because they are null
|
|
|
|
|
Well what I did is loaded the list view with data from the excel sheet, and then looked to see if that excel sheet was missing certain columns. If it WAS missing the columns (I.E. not in the list view columns after being loaded), then I would add them at runtime. Like you mention, the problem was is that the ITEMS were added to the list view before adding the new columns. So the ListView itself sees the columns but the items in it don't. I guess I could of stored that information somewhere else that the columns were missing and at import added blank values to those sql parameters for the ones missing. Problem with that is when the user looks at it, the columns are still missing.
So the listview had the correct amount of columns, but the items didn't. Strange, I figured after adding the columns to the listview it would of appended the columns to the end of the items. To fix it I bet I could of looped through each item and added blank subitems to each one of them after adding each column..
But I ended up using a datagridview instead and I was able to make all that work.
|
|
|
|
|
There are only 23 SubItems in the collection (indexed 1 to 23) and you are trying to access index 24, which is causing this error. Try using index-1 instead. I believe IndexOfKey takes into account the first column also (which is not included in the SubItems collection).
|
|
|
|
|
Yes.. the problem was that the items only had 23 subitems, but the listview had 29 columns since the columsn were added after the items. I would of figured adding columns would of appended it to each item. I posted more of an explanation above ^^^
Thanks!
|
|
|
|
|
In ListView, everything except the first column is in SubItems collection. You cannot have anything "after" that. So, if your ListView really has 29 columns, it should have 28 subitems, and conversely, if there are only 23 subitems, it means the ListView has only 24 columns.
|
|
|
|
|
Hi. i would like to built simple video conference application for commercial. just only peer to peer connection.
Can i use RTP in Conference XP 3.0?
Are there rtp api or libraly that i can use ?
|
|
|
|
|
i want source code video conferance
thank you
|
|
|
|
|
Dear techies...
I have a formm(GUI) with 4 buttons and 7 picture boxes...
Nice if someone could help me find a function to disble the whole form (all buttons and picture boxes)..
so that the user cannot click on any of the controls.
thanks a lot !!!!!!!!!!!!!!!
|
|
|
|
|
MyForm.Enabled = false?
Or if you're in WPF, IsEnabled = false
|
|
|
|
|
How will you enable it again ?
|
|
|
|
|
Iterate the members of Controls and disable each?
|
|
|
|
|
Generally (depending on what you want it to look like) I'd stick the controls on a panel (or similar) control and then enable/disable the panel.
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Put all the controls (that need to be disabled) on a panel and disable the panel.
|
|
|
|
|
thanks a lot Ian Shlasko, Shameel, PIEBALDconsult, _Maxxx_....
really appreciate your help...
|
|
|
|
|
Hi
I am looking for help and an example because I want to create an HTML output from a C# app that provides the usual html tags along with a html table with data coming from an object. Does anyone have an example I can follow?
|
|
|
|
|
StringBuilder ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I expect an XmlDocument could do it.
|
|
|
|
|
I think the best way is XML+XSL,but it is not easy and convenient.
|
|
|
|
|
Is the syntax correct? The error that I get is :No overload for method 'CopyTo' takes '1' arguments
//The SortedList.CopyTo() method copies the current sortedlist to an array.
Example
SortedList items = new SortedList();
items.Add("key2", 5);
items.Add("key1", 2);
items.Add("key3", 9);
String[] MyArray = new String[4];
items.CopyTo(MyArray);
MyLabel.Text = "Third item of SortedList is "+MyArray[2];
|
|
|
|
|
Message Closed
modified 23-Nov-14 7:02am.
|
|
|
|
|
will that copy all the values into the array of the sorted list?
|
|
|
|
|
Hi
I am using a OleDb DatabaseConnection, and I am using this connection to take in and read in an excel spreadsheet into an Object.
However, I would like to get the number of rows the DataReader has brought back in order to use in a for loop. I thought, by using another SQL Query, would do the job, but when I run this, it says that the reader has no results to return, which is odd because the main query that is bringing back the rows - works!!! So, does anyone know how to get the count on the number of rows a datareader would bring back from reading in the rows from an excel spreadsheet?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
