patrick24601

First of all... please post a decent subject line next time. We are all professionals so I am so surprised every time I see a subject line like "HELP NEEDED ASAP!!" or "I NEED HELP NOWWW" or "ANSWER MY PROBLEM". Those are the ones I usually skip by. The SUBJECT line is there for a purpose - use it. It will also help people in the future. Now... another possible solution is to immediately spawn another window from your application and close the original window. If you spawn the new window via Javascript you can control everything that appears and does not appear. Menus, toolbars, navigation, etc. Then you add all of your navigation and you don't ever have to worry about problems with back, forward, reload, etc.

Thanks. I now have my eye on that VB also!

I found out that a large (let's call it enterprise) application will have to have an internet facing/hosted server. So we will have an internal server which will have access to port 1433 and the database directly (possibly on a another machine) for the database layer. Then will have an internal IIS Server to talk to it. Then we will have one on the DMZ. The one on the DMZ will not have access to port 1433 - probably only port 80. Should we start planning for web services in the business layer with multiple front ends coming in via different routes ? Depending on the front end you might be able to access the database directly. So we could multiple front ends with each one configurable as to how it will connect to the business/application layer.

I have to write a rather small project quickly, and I am trying to keep every clean and OO. I am fairly new to .NET. I'd like your comments on my proposed solution. Request: Display a list of summary information (hospitals) with some columns of information next to each one. The columns represent how many database records are present, and some other math is done is show statistics of parts based on whole. No record detail is needed, just summary information about the records. Example: Hospital | totals records | type A records | type B records | % of records that are type A | % of records that are type B Walter Reed Hospital | 100 | 10 | 90 | 10% | 90% I then need to click on the hospital and get the department detail with the same columns, but (obviously) just for that department. The data that is being given to me (from an outside product - I have no choice in the design) has 20 tables. 1 table each for the hospital and record type (A or B). 10 hospitals, 2 record types = 20 tables. I am creating my own tables with the hospital and department names. I have the detailed numbers but I need to calculate the percentages. Proposed Solution: Write 2 methods to return the summary information and detail information. The Summary method will return all of the records from the hospital table joined with its data and the calculated percentages. The detail method will take in the hospital number and return all of the records - again with all of the appropriate columns. As I typed this out I realized that I am not sure if I should return a dataset from each method or an array/array list. Even though my database has 4 columns of data, my presentation layer has to display more than 4 columns. It also has to display my calculated percentages. Thanks, Patrick

Does anybody have any recommendations on a company with great Outlook style controls (menu/navigation bar) ? I have already looked at ComponentArt, but I'd like to look elsewhere at the same time. Thanks, Patrick

Has anybody ever written any asp.net code that will connect to, retrieve, and store documents on a sharepoint portal server?

Could you do this in global.asax.vb in the BeginRequest block to check every incoming URL request and redirect them appropriately.

Because the Cache() us an application wide option does that mean that if, for a given user if I stored something in Cache("username") that it will be overlaid everytime anybody else stores something in that same cache item? And if so is there a way to differentiate between items I want cached for a particular session vs. items I want globally cached? P

A simple thanks does not do your post justice. So imagine this is a big giant thank you.

So are you saying that I could have referred to a dataset in the code below (instead of the way I did it) --- Dim cmd As New SqlCommand Dim conn As New SqlConnection(hpdmdbConnString) Dim counter As Integer cmd.Connection = conn cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "usp_rolelookup" cmd.Parameters.Add("@username", currentuser) ' Open the connection conn.Open() ' And run the stored procedure command we have set up in CMD objreader = cmd.ExecuteReader ' Did we get any rows back? If so then loop through our objreader and add the single column of data ' to the arraylist. counter = 0 If objreader.HasRows Then While (objreader.Read()) counter = counter + 1 getUserRoles.Add(objreader.GetString(0)) End While End If

Is it possible to return the results of a stored procedure as an ASp.net dataset? Can I get some hints? I have been looking but cannot seem to find any examples.

A SQL Server database stores a bit value as 1 or 0. Visual Basic stores true false as -1 and 0. As far as I can tell every time you read a bit column you are going to have to multiple it by -1 in order to test for true/false in VB? Did I get this right or is there an easier way (without storing the value as an integer in sql server) ? Thanks, Patrick

Thanks for the response... albeit short ;) That does not work for example if I am on page directory/herethere.aspx and it has a link to /directory/herethere.aspx. What you get is the application trying to go to /directory/directory/herethere.aspx. The "/" is usually relative to the directory the current page is in if I am not mistaken. One of the things I am testing right now is "~/directory/herethere.aspx"

Does anybody have a clean way to manage relative links in an application that has various levels of directories? I'd like to .... 1. Keep all of the my images in applicationroot/images and be able to get to them easily no matter how deep I am in the application (deep meaning directory level). 2. Keep my application code in different applicationroot/modules/modulename directories and be able to navigate easily between them.

For the future... this is and most language syntax can be looked up for free at MSDN.com. Please find it and bookmark it. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemStringClassSplitTopic.asp The only thing special I can think of is that your delimiter may have to sub appended with a c ( as in string.split(mybigstring,'F'c) to make the method happy. It is expecting a character and by default I think 'F' is assumed to be a string.