Search results for query: *

I ended up taking a different approach to solve this. In the engine, I was selecting all the columns I was going to be checking, and then just checking the count of the rows in C# to see if any data had been selected. With the nature of this engine, most of the result sets were empty anyway...

Yeah, I think that's slow. SQL Server and this application are on a dedicated server with 2 gigs of RAM and 2 CPUs. They are all simple TSQL statements with minimal joins. We had an old version of this engine where the bulk of the code was actually in a stored procedure that basically ran...

We've basically built a rule engine here. Rules are built where you specify criteria that will be applied when the application is run for "approval". What it boils down to is I have about 250-350 unique TSQL statements (they're basic TSQL statements, no subqueries and just 2-3 joins max) that...

Thanks! As far as using only stored procedures, I would love nothing more than to use that method, but we have so many websites in house (all of them super important... /sarcasm), we have to resort to quick and dirty dynamic SQL methods. :(

I'm trying to limit the permissions granted to the people using the databases through the websites (we have one webuser per web application). Currently that web user is part of the db_owner role, but I don't think that's right. That means any user who's accessing the database through our...

You're opening a real can of worms with that. I had a similar task when I went to create a report designer for my application. I literally had to write all the GDI+ code to give visual cues for moving and sizing controls, including drag and drop functionality. If I remember correctly, there...

Looking at the trace info for when the page first loads, I see the Viewstate Size (excluding children) for each of my dynamically created DropDownLists is 0 bytes while the render size fluctuates depending on the # of ListItems it contains. My guess is when the page posts back (and the...

Just keep in mind anything you store in session will remain there for the entire session, unless you unload it explicitly. That can add up rather quickly if you're storing one or more datasets per form and then multiplied per user. I recently came from an applications programming background...

So I've fought and fought and fought some more, and I've finally got my dynamic DataGrids saving to and loading from viewstate properly... or so I thought. A quick description of the page. It contains a dynamic # of 4 different types of datagrids. Each row in each datagrid will contain a...

Hmm... I think that advice helps me quite a bit. I guess I'm placing too much importance on making as few trips to the database as possible? It just seems strange to me that I have to make another call to the database on basically every click. I'm used to getting a copy of the data from the...

I'll just concentrate on one page for now. This page has 4 datagrids. During Page_Load and !Page.IsPostBack I'm retrieving the data that will be shown in these datagrids into DataTables. Because I'll be using this data during postbacks, I store all these tables to Session. The DataGrids are...

As a former .NET windows applications programmer, I'm having a bit of a hard time in my transition to web programming. This stateless thing is killing me. Basically, I want to use anywhere from one to three different DataTables for each web page for this site. All the pages are working just...

I've finally finished all the forms for my project and I'm now tackling the issue of reports. In an effort to keep the cost for the program lower, I believe I am going to try to avoid using Crystal Reports or any other reporting software that isn't free, so I'm designing my own reports using...

I really don't like the behavior when using the DropDownList style and I was trying to avoid adding more code (to search the ListItems after text is entered for a match when the text entered is a direct match, it doesn't seem unreasonable for a combobox to accomplish this), but it looks like it...

Maybe I'm not understanding ComboBox events properly but it seems like these events aren't working as they should be. I have a System.Windows.Forms.ComboBox placed on a form and its Items list is populated with items. When I open the dropdown box and click on an item, the SelectedIndexChanged...

Five months after quitting my old job to become a self-employed programmer I find myself wondering if I made a mistake. I have not seen a real paycheck in five months. Instead I've been developing the product I'm intending to sell. I'll be the first to admit that when I quit I was not ready...

Umm... see, that's the problem. It's thrown in Non-User code. The final line in the Call Stack shows ValidateThroughAncestor which is a method of ContainerControl, but I don't have the code for that procedure because it is internal to .NET. Anyway, I think I have a general idea of what is...

I have a custom control that is acting like an MS Access subform. When I modify a new record, it is supposed to add a new blank record to the subform, just like MS Access does (in the subform the record has a * indicating it is a new and blank record). In my project, if I modify a text box and...

I've spent the last five months working on a project full time. I'm currently using VS.NET 2003, and the entire project is in C#. I'm not going to deny there are benefits to using my IDE. Control placement becomes extremely easy with the GUI, as does hooking events. Basically it's great for...

Thanks for the book recommendations. After doing some research on them I think I'll be buying GOF's Design Patterns and possibly Fowler's Patterns of Enterprise Application Architecture as suggested. Also, I found the following article to be very detailed and helpful (would it be wrong to give...