bri189a

Drag it from the tool box on to the web form.

I don't know what a compound file is, but 5 seconds on Google resulted in the following which I think will help since it references the IStorage API which is used on compound files it appears: http://www.codeproject.com/csharp/DecompilingCHM.asp

Zip up your dataset and your method for reading the text file and post it. When I have a change later this week or this weekend I'll throw it together for you. I'll need a text file that has some of the data in it too to make sure it works....in fact just zip you whole project and post it with some test data. Shouldn't take me long, just have to have the time to do it.

Let's assume the dataset looks like this Book -------- ID - Integer (Primary Key - Auto Generated) Name - String BookContents -------------- ID - Integer (Primary Key, Auto Generated) Book - Integer (relates back to 'Book') Chapter - Integer Verse - Integer Text - String Now go through each line of the text file - I assume you know how to do that. Then break the line into a string array: Dim s as String() = LineOfText.Split(":"c, 3) The 3 signifies the maximum number of items to return is 3 - mean that the first item in the array will be the chapter, the second item will be the verse, and the third will be the text. Now I also assume your using a strongly typed dataset. So from here you simply: Bible.BookContents.AddNewBookContentsRow(book, s(0), s(1), s(2)) book represents the 'Book' row that you should already have. I hope this at least points you in the right direction.

I agree that leadership should be 'activity' based...so many posts per month. I understand people get busy and there status should change to 'retired' leader or 'out of office'. But the name 'leader' implies leading. If my Senior Architect didn't advise me at least a few times a month I would wonder why he is a senior architect. See what I'm saying? If a leader becomes active again he would have the 'out of office' status removed or maybe 'been away on vacation'. :)

A dataset has tables is in it - you need to check all the tables for no rows. Your sql just returns an empty cursor but still causes there to be a table. What you need to do is: bool dsEmpty = true; int tbCount = 0; while(dsEmpty && tbCount < dsChg.Tables.Count) { if(dsChg.Tables[tbCount].Rows.Count > 0) dsEmpty = false; else tbCount++; } //Now dsEmpty holds whether the ds is 'empty' or not.

Unless the last post was removed what I saw as his last post looked pretty harmless.

Lift the ban on Joe! His honesty is needed here!

I wonder if she means some sort of processing that is happening on the server. If that's the case I imagine she could post via RPC which would handle the validation she mentioned. Wish I had time to write an example but I'm pretty new to RPC still and haven't done a heck of a lot. But yeah, 'it can't be done' isn't part of my vocabulary either; it's 'how much are you willing to pay me' that determines whether it will or won't be done. :)

All you newbies out there...you should read these posts about 20 times in a row!!! btw nice example Joe of Singleton pattern.

I would use a trigger as Joe mentioned. That's your best bet. I'd consider anything else poor design.

Well where to begin... 1. You're opening and closing a connection in a loop. 2. You're adding parameters inside a nested loop rather than reusing existing parameters. 3. You never dispose your command objects or connection object which (see #1). I can't say I particularly like the whole idea and design, but I don't know the overall purpose of the program to say much about it.

Yes, it's an ASP.NET control. Documentation can be found in MSDN.

Well obviously your going to use a plain data repeater. Your item td tag will have the row span eqaul to the number or records for that particular row. It would be a bit challenging, but with your repeater looking at parent/child relationships you should be able to come up with something - it may not be elegant, but if it works so be it.

Most clients only think they need excel to work with, when in reality all they want is tabulated data - which is what a data grid is for. They want excel so they can use their formula's, column resizing, etc. So when those requirements come across my email (for my home business) I tell them I can either write a web application/windows application that can export data to CSV, SLK, or XLS, or they can make their own Excel workbook (because I'm not going to), or they can spend the extra money for me to develop (actually for them to license, it's already developed) a custom control that works a lot like Excel (resizing, freezing columns, etc...not the formulas). I'm not afraid to turn work down...I rather loose out on one job than take a job that will be 6 months of headaches. Point is, you're suppose to be writing a web application, not an Excel workbook. It's a common mistake to let users dictate how you will implement there requirements. And 'I want it to look like Excel' is not a functional requirement - a weak arguement could be made that it's a supplemental requirement - I wouldn't buy it though... You go down the road of trying to make you application work or look like Excel you're in for a very long, ugly, project. Even buying a control that encapsulates the functionallity will result in a lot of headaches because the users are still going to want their Excel formulas and things that may not be in the control. They only want Excel because that is what they are comfortable with. It's your job to make them comfortable with something new. Change is good.

Definitely, I was also refering to the ASP datagrid too, so my appologies to any confusion I may of caused anyone out there.

I override the Render method in my base page because LinkButtons don't cause a form onsubmit event to fire. I use the innerHTML property as preference...if I wrote javascript that was cross platform (document.all is IE only) setting the visibility would work too. Keep in mind you're seeing the output of a base class too, I don't actually put that in the pages anywhere by hand...html or code behind.

Go for it! (just give me a thanks somewhere in you comments)

AJAX is a buzz word for JavaScript RPC (Remote Procedure Call). Look for the article "Life without Refresh" on msdn, which is a good article and points out a few things, that by some may be considered flaws, about AJAX. I have no opinion on AJAX yet, still to new to the subject. Basically JavaScript RPC allows you to update the contents of a page without reloading it. It is a good amount of work though for anything complex, and it hasn't been tested to be secure, so I've heard. Many of my collegues refuse to look at it because it was a known flaw in ASP 3.0 - not something I know much about so they may right, may be not.

Problem is Joe, that while we know that, this new version of VS is going to encourage more of that kind of thinking with it's 'new' datagrid that let's you put the SQL in as a property...of coarse you and I will continue use the n tier level approach and the 'object' data source and having a true 'presentation layer', but we're going to see more of this thought encourage by that control. I wish they would take out that feature...can you imagine people putting SQL in html view - I mean for proof of concepts, okay, but anything other than throw away code forget it! Well, at least we won't have to worry about job security! :)

You won't find anything: A DataView is a sorted and/or filtered list of rows from 1 table only. Also, the Select method is on the DataTable and as such - can't look at other tables. (from http://objectsharp.com/Blogs/datasetfaq/) Follow the advice at that link. If that doesn't help let us know.

The driver will allow 10 connections, but I've heard it get's flakey after 5, that's by word of mouth (the flakey connection part, not that it maxes at 10), haven't seen documentation on it or seen it myself.

An alternative I've been playing with, and there are some post on this forum regarding it, is dynamically loading DLL's in another app domain, this way when a new one is loaded it can unload the original and load the new one without restarting. I haven't been able to perfect the process yet, but I've read that it is possible. Something to think about.

Sounds like bad design. Look at using cookies.

Okay, it was my brain freeze - always forget that VB.NET puts on default namespaces and if you specify a namespace, that namespace is actually on top of the default namespace.