eramgarden

some good examples: http://communityserver.org/files/40/releases/entry516270.aspx http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=4531&lngWId=10 http://www.asp.net/default.aspx?tabindex=5&tabid=41 Those links are from this thread : http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21832997.html

and I started it with my question :( Anyway, look at this example : http://aspnet.4guysfromrolla.com/articles/102302-1.2.aspx Scroll down to : "Fleshing out the Business Object" and there's a pseudocode there. Now, if this is a business layer..shouldnt that DB connection, data reader stuff be in the data layer? I would think it should be in a function in the data-layer, then that layer would "'return the built-up UserCollection object." Any constructive :D thoughts on that?

yeah, what's wrong with that question?? Better i ask than mess a project! Thanks mskeel and marble_eater.

In my application, I'll be calling either SQL Server or AS400. Is there a way to have an "providor independent" data acess layer. I dont want to repeat code. Have a set of DAL for sql and another set for AS400 and another set , for example, for Oracle. Any examples?

Ok, i think i'm confusing myself here.. I want to have a 3 tier app: presentation, business and dataacess. I've read a lot about all 3 and have an understand of how to separate them. Got an example from 15Seconds website. But where do my classes belong to? I have a "debtor" class: person who owes money with their data like name, address, how much they owe "collector" class: info about the person who's collecting :ID, phone number, etc "account" class: this is the company/client who wants the money etc... but what layer do these classes belong to?? should I just create a folder named Classes and inherit from those ?? Kinda lost here..i think ineed a big picture.

When I opened VS2005 for the first time, it asked me to choose an enviroment setting. Not sure if I choose "VB setting" or "web setting". I cant choose both seems like. I can import under "tools/import exort" but i think it always imports one setting. Found this site as well but still not clear: http://www.c-sharpcorner.com/Code/2005/May/NewIDEFeaturesinVS2005.asp I'd be developing in VB.Net ..which setting should I import?

Second week at my new job and looking at the DB :) 1.They have made every field either char or numeric or created user-defined database type. Read about the diff between char and varchar:Char being faster and it's used for "fixed length" if it's less than 30 bytes. Varchar used for "variable length". 2. They have made ALL char fields NOT NULL with default value of BLANK. Questions 1. Still not sure what variable length and fixed length mean. How would I know if the data is less than 30 bytes? 2. Is there a downside to making everything NOT Null and having default of blank?

I'm at a new job and looking at their app... Last application I worked with was an internal application to the company that was developed for us by a vendor. They used windows authentication: There was table with userNames in them..one field was the "windows usename" that the users would type in. So when the app was launched, the windows login was checked against that field. And if I remember correctly, the database had a LOGIN user that was used in the web.config to connect to the database. Current app I'm looking at is not fully developed yet but in the database, I can see login names. This app is NOT an internal application...it will be sold to potential clients . Would it be better to use "windows authentican" method instead of creating logins..what if a company has 1000 users..then they have to create all these logins. Any thoughts?

At my job, there's a windows app done in a language that's similar to VB. It's like Forms. Not a ASP.Net application. We want to create a ASP.Net/VB.Net application. One feature that the Windows app has is to that the user can change the labels on the form . There's a menu item, user clicks it, a new window pops up, it has the default values for the lables, user updates them with new values. So next time, the user sees the new values they selected. How can this be done in ASP.Net/VB.Net? How can I mark the labels on the changeble?? Any design idea or sample code would be great.

I'm looking for a simple sample code to download and just look at the strutcure...how different layers are organized.. For example, should I create a "data layer" folder and just add the ".vb" classes under them...in VS2003, there's like a template for "business" layer ...should I use that , then create the ".vb" classes under it...should I create "class libraries" ?? I looked at MS site, I downloaded code but there's no "sln" to click on and open up the projects.

Never Mind.

Ok, this is my 3rd day on this new job and this is what my manager just said to me: " the companty we do business with has a lot of stored procedures etc in tempdb AND DO A LOT OF THINGS THAT ARE NOT CONSIDERED GOOD PRACTICE. We are kind of stuck in that, I read up and from my reading CLUSTER for primary key is always a good idea and there are no downsides. As soon as I did that, the app quite working". What should my response be?? Who puts stored procs in TempDB? What are the side effects down the road? If ONE client is doing that..should I suggest that we leave that client alone but for the rest, we need to change the schema?? any advice would be great.

I have a new job and there's no VSS for source control here. My manager asked me this: "Could we use the source control with non .NET code?" They use IBM/AS400 and code in a language that's similar to VB6. I know .txt and other files besides .net code can be kept in VSS but how about non-microsoft code?

Thanks for the good advice... Last app i worked on was done by MCxxx and "MS gold partners" developers. A nightmare of timeouts , deadlocks and performance issues.. I know they used SPs and caching but not sure why it had so many issues.. any thoughts on how to keep the performance in mind?

we have a desktop application done by a vendor. Not sure the language it's done with..i know it's not dotnet. We're going to write an ASP.Net/VB.Net application using that desktop as our blue-print. In general, what should we keep in mind when designing a dotnet web application from scratch? We're going to use VS2005/ASP.net2.0 and 3-tier. Should we use caching? do we need to keep machine.config in mind (change it to make performance better), I know we're gonna use stored procs, should we use sessions, what about security, garbage collection.. what should we absoultley keep in mind ..a rule of thump?

A developer here was telling us we can design side menu using XML. For example, The menu can have "option1, option2, option3" , then under for example..."option1" can have a submenu of "option1-a", etc. Then when a user clicks on "option1", the sub-menus are displayed where then u can choose from the sub-menu, click on the sub-menu and it takes you to a ASP.net aspx file. I've seen an example of the XML file with the attributes and links to the correct aspx file but how do you code the "click event" in xml? how do wire it to the asp.net/vb.net code for the click event??

I'm continuing reading the article about Classes. In this one, it's talking about having constructors... http://www.developer.com/design/article.php/10925_3464311_2 I use vb.net/asp.net. Question: Do i have to use it? i'm looking at the application that was designed by another developer and he doesnt have it in every class. This article says to use it when you want to init attributes.

is this a typical design that more experienced developers follow? what are other options besides what I do and besides having a "database access class" designed? For example, what would u (and other experienced developers on this forum) suggest?

I've been reading this aeticle: http://www.developer.com/design/article.php/10925_3347291_2 to get a better grip on OO design and thoughts. On this section of the article, it talks about "a database access class". It has DB open, close, etc. question: What I've done in my small asp.net/vb.net app is to repeat the conenction string, opening of database, closing it, etc in each subroutine/function So how can I avoid this reapeating of code..actually build a class to do all the DB stuff as this article suggests? anyone with a good example i could look at it?

but in what event?..in page_load??

Trying to understand the ASP.Net Page Life Cycle. Reading this article: http://www.aspfree.com/c/a/ASP.NET/ASP.NET-Life-Cycle-and-Best-Practices/ Under "1. Object Initialization" section it has: However, if any of your objects are controls specified within your ASPX file, at this point the controls have no attributes or properties. It is dangerous to access them through code, as there is no guarantee of what order the control instances will be created .. My question is: Then when are the controls get their attriubes..when can they be accessed then?

Found a good code example: http://www.megspace.com/computers/aspdotnet/article/asp-2001082002.htm

Sorry, I meant i like to see an actuall code.

Thanks for all the input. Now, Ploymorphism is bothering me :-) I found this example and it says if u think you're gonna use "case", then see if u can replace it with Polymorphism. Where can I find a good (reallife) example of polymorphism? http://www.informit.com/articles/article.asp?p=28482&seqNum=6&rl=1

Where can I find examples of these "study great designs"? That's what I like to look at and step thru