ListView subitems problem... finds column but throws error.. DRIVING ME NUTS! - C# Discussion Boards

NarendraSinghJTV wrote:
done all the coading in onstart(),

Well don't. OnStart is just for that. Move your code and try debugging by connecting to your service from the ide - and you cannot debug the OnStart code. Also try logging errors soemwhere (say a file) so you can see whats going wrong.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

thanks bob for ur valuable response

thanks for all the responses
regards
narendra singh

Debug your services. It throwing some exception at runtime ! Smile | :)

That's why you are getting this message.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

yes abhijit u r absolutely right it is throwing an exception
actually i m using single database in both application as well as service. but sql server is not allowing to access the database which is already in use, it is generating a error which says .mdf file is already in use

thanks for ur response

Hi,

I would like to know, when I click a button, whcih other events are called before button click event is called.

thank you,

You can write a small program which subscribes to button events and shows an event on the screen Smile | :)

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Are you talking about Windows Form or Web Form ?

I cannot figure this out! It is driving me nuts!

Ok so I can do a IndexOfKey and get the index (which in my case is 24), but when I try to get the text it gives an error:

int index = 0;
index = lstImport.Columns.IndexOfKey("Category");

MessageBox.Show(index.ToString()); // THIS SHOWS 24

if (index == -1) cmd.Parameters.AddWithValue("@Category", "");
else cmd.Parameters.AddWithValue("@Category", lstImport.Items[i].SubItems[index].Text); // THIS ERRORS

ERROR:

System.ArgumentOutOfRangeException was unhandled
  Message="InvalidArgument=Value of '24' is not valid for 'index'.\r\nParameter name: index"
  Source="System.Windows.Forms"
  ParamName="index"
  StackTrace:
       at System.Windows.Forms.ListViewItem.ListViewSubItemCollection.get_Item(Int32 index)
       at Grant_Inventory_Import.frmMain.ImportData() in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\frmMain.cs:line 560
       at Grant_Inventory_Import.frmMain.btnImport_Click(Object sender, EventArgs e) in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\frmMain.cs:line 221
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.Run(Form mainForm)
       at Grant_Inventory_Import.Program.Main() in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\Program.cs:line 18
       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException:

And your row really has 25 columns in it ?

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 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()); // EQUALS 24

MessageBox.Show(lstImport.Columns.Count.ToString()); // EQUALS 29

MessageBox.Show(lstImport.Items[i].SubItems.Count.ToString()); // EQUALS 23

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

Proud to have finally moved to the A-Ark. Which one are you in?
Developer, Author (Guardians of Xen)

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.