Comments by woopsydoozy (Top 54 by date)

Sorry, there's too much code here for me to spend time reproducing or reading through it all. Narrow down the problem. Put a breakpoint in your Remove method and check each time through it to see if people.count is ever <> listView1.Items.count, and if so, try to figure out why. Check both at the start and end of the method--if it becomes out of synch at the start of the method, then presumably some other method is removing an item and needs to be fixed; if it gets out of synch at the end of Remove, then your problem is in Remove.

Thanks, that's a useful link. You can get pretty much the same thing using the Database Documenter on the Database Tools tab, but using VBA, maybe you could drill down through lower level stuff (the Documenter only gives you the level of the report).

Ah yes, gotcha. But my initial comment still holds. The Report properties show me the name of the Access table, and the properties for any particular field show me the name of the field used to populate that position in the report. But is there a shortcut back to see where the original data from an external DB is coming in? Been googling, and looks like the answer is no--I have to bounce through several steps to try and find the actual source.

yep

I've got 2010, so I don't see anything called a "Details" section. But I can select any field on the report, right click and select Properties, which opens a Property Sheet window. In the ControlSource row there, I can see the name of my data field: CURR_%_POOR_DPMSBSTR_W_ABUT_BSP. Now clearly that's not a DB field, but some field internal to Access. But ultimately, I know that the data used to produce this value comes from the DB. So how do I trace backward to find its actual DB source?

what mechanism are you using to apply the sort on the front end? The Sort property of a DataView, I assume? Probably need to add a data column that will do the sort for you. Like add a case column to your query, something like: CASE WHEN InvoiceItemLevel LIKE 'Package Total%' THEN 'AAAAA' ELSE InvoiceItemLevel END AS SORTVAL

Don't know why the correct answer got voted down, but whatever. If you're not getting any error as you step through, then likely the mail is going out and getting stuck somewhere in the network. As a starting point, if you've got virus protection on your machine, that may be blocking it--you might see it blocked in the virus protection's log. If it got off your machine and didn't make it to the target, you might need a network admin's assistance--you're beyond a software problem at that point. I'd start by trying a local SMTP server and see if you can make it work there.

Yes, this is the normal practice. If you don't specify the prefix, then it doesn't know to use the namespace you've defined. Note that you can define your prefix as anything you want, though, so you can make it a single character, if that helps. For processing any XML with a namespace, you can remove the namespace attributes and reload it into your object, then you don't need to worry about namespaces anymore. But I don't recommend that--namespaces aren't that bothersome once you've worked with them a little.

This happens to me sometimes when I add controls to the HTML while I'm debugging. I usually stop the debugger, backspace over the HTML of the control I've added, and when I re-type the ">" to close the element, the designer kicks in, gives the tag the correct closing tag, and adds the control correctly to the designer file so it can be accessed in my class.

Ideally never more than 1. It's meant to be invoked through a nightly automated process, but for now we're doing it manually on a hidden admin page.

How are you adding the signature? There ought to be a way to control the default namespace

By the definitions provided, I'd say I'm doing delegation, and it follows the second pattern in your details, but I'm using a fixed account rather than "flowing" the original caller. I don't want to use the original caller, because most of those people should not have direct access to the share. TransmitFile should have worked, but many report problems with it and UNC; I got it to work locally, but not on the server--perhaps there is something missing that Kerberos delegation would fix? Not thrilled with handling the stream myself, but it worked--see my solution.

I am neither confused nor mixing things, but thanks for the detailed response. Unfortunately, your response is all about impersonation, which I am already doing successfully. What I need is a way to transmit/stream/whatever the file down to the user. My initial attempt using Response.Write(SharePath) does not work because it attempts to open the file from the client, and the client doesn't know anything about the need for impersonation in accessing the file. It appears that Response.TransmitFile should work, but I have a UNC to the file, so maybe I can't do that either? It also looks like opening the file as a stream and then writing it to Response.OutputStream will work, but that seems messy. Any other solutions? (sorry, don't know why there's no button to "reply" to your comment Zoltan--hope you see this)

well, no, because if your attribute names are duplicated inside a tag, you have invalid XML.

eh, OK, yes, depends on the size of the data. If your datasets are large, paging on the DB server is the way to go. Anything under ... say (SWAG) 10K records? Get the whole thing and go for it.

I did an EXE (Windows Form Application) initially, but I also tried it as a DLL (Class Library), and that worked fine, too.

I took a quick glance, but see no documentation of this package. There is a link to source code, but that's not likely to help you. I suggest you ask your question in the hydrogenaudo forum, as that's where you got this.

Still not clear. "If option 2, then true or false." Well, which is is it? What decides that? If there's any complex logic, you have to write it, and if the logic is different for each dropdown selection, you're not going to have much option but to write it in your code. If, however, you're not using your dropdown value for anything, then you could put your boolean there, and use that to set the Checked property of your checkbox.

We're not seeing everything, so hard to tell. I'd suggest putting a break point at the start of BindCategoryTenderList. When it hits there, is gvTenderListByCategory.PageIndex still set to what you want? If so, is your exception handler getting hit?

Makes sense. The error says your constructor on MainWindow is failing on line 4. Line 4 is your instantiation of WebKitBrowser. Try commenting out third party stuff and seeing if you compile. Then put the 3rd party stuff back in little by little to narrow down where your problem is.

I'm still not getting it. You seem to need some basic SQL training--try http://www.w3schools.com/sql/default.asp, and get into your DB manager and just keep tweaking your query until you get the result you want. Sounds like you're looking for another JOIN, likely something like this: AUTH LEFT OUTER JOIN pers ON pers.company = AUTH.company LEFT OUTER JOIN Post ON pers.company = Post.company. The data you want from the post table, I still don't see--are you trying to get a count of the people at that company, or the number of transfers, or ...? And where does unit come in?

Thanks--the navigation may indeed be the only purpose of the right-hand dropdown. The left? Maybe just for cases when multiple classes are in a single file? (Anyone doing that a lot?)

what kind of DB are you hitting (SQLServer, Oracle, other?), and what kind of object are you using to query it (what type is your db variable, and what type does Query return)?

OK, so you already have a gridview loaded with data--did that data not come from Oracle? Where are you stuck? What code do you have so far?

what are you asking? How to get data from an Oracle DB, or how to bind your data to a gridView?

That's some error coming from your Excel interop. It's probably this line, which attempts to put the cell, rather than the cell value, in the array: myArray(r, c) = DataGridView1.Rows(r).Cells(c). Instead, try myArray(r, c) = DataGridView1.Rows(r).Cells(c).Value. Also check to make sure you're populating all your array elements--I don't know that the interop deals well with Nothings.

Think of the dimensions of your array as row/column for your grid, so something like ArrayName(grid.Row.Count - 1, grid.Columns.Count - 1). Then walk your grid with nested for loops, loading each item to the appropriate spot in the array, like: For r = 0 to grid.Rows.Count - 1 : For c = 0 to grid.Columns.Count - 1: ArrayName(r,c) = grid.Rows(r)(c): Next c: Next r

A loop will work fine, but is slow. My question was whether your code is really stuck (likely some interop issue with Excel) or whether you're just not waiting long enough for it to complete. If it's in your loop, wait longer. If you want to speed up the processing, look into loading your sheet via an array; another question from today should help guide you: http://www.codeproject.com/Answers/626941/vb-net-copy-array-to-excel-spreadsheet

When you stop the debugger, where is the code? Are you in your loop? Populating the sheet this way is slow, so if you have a lot of data, it will take awhile.

Also, see 2nd solution for http://www.codeproject.com/Questions/606812/transferplusanplusarrayplusofplusdataplustoplusapl

Yes, that's an Excel error. But you weren't getting that before, so what's changed? From a quick search, that seems to come up when people reference a cell with 0 as an index--need to use 1 as the base instead.

What's the context of your button? Is it in something like an UpdatePanel?

Thanks to you both--I updated to show some code. No autopostback, and no registered events that I don't want to happen. I just don't expect the onchange to happen immediately when the grid is bound.

what do they say about great minds?

What you put in the parantheses after Session is a session variable name, and that's a string. Best to make the string a constant, so there are no fat-finger typos, and you can use it anywhere else in you class that it's needed. Note also that I've moved the assignment to the session variable before the Return statement.

Const MY_DATA As String = "SomethingUniqueToIdentifyYourDataset"

Protected Function GetData1() As DataTable
Dim dt As DataTable = Session(MY_DATA)
If dt Is Nothing then dt = FormatDataTable()
Dim dr As DataRow
' Populate the datatable with your data (put this in appropriate loop)
dr = dt.NewRow()
dr("id") = TextBox1.Text
dr("text") = TextBox2.Text
' Add the row
dt.Rows.Add(dr)
dt.AcceptChanges()
Session(MY_DATA) = dt
Return dt
End Function

I'd guess there's been tinkering with the CSS. Check your stylesheets or inline style attributes, if they've changed.

I struggled with printing in Silverlight, too. In the end what worked for me was generating a new image of the selected stackpanels with Imaging.WriteableBitmap, and adding those new items to my printing container.

Agreed, now they're basically the same. One caution: I don't think you should count on a Close counting as a Dispose--again, depends on the object.

Can you show us how you're putting the value INTO session?

OK, so cell_value.Replace(" ", ((char)10).ToString());

OK, from your screenshot, it appears that you want to control where the break occurs. So you have to change the string you write to the Value property, inserting the correct character at the right places. I thought (char)10 should work--maybe you have to set WrapText along with it? Try this:
range.WrapText = True;
range.Value2 = cell_value.Replace(" ",(char)10); //assumes space is your delimiter

A swastika in the DLL name? Clearly Nazis have infiltrated your machine.

answer's above: xsl changes or manipulates data, xsd defines data's structure

Looks OK--what's happening in the constructor/FormLoad of ActionForm?