Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. keyser456

    250+ unique TQL requests, best way to go about it?

    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...
  2. keyser456

    250+ unique TQL requests, best way to go about it?

    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...
  3. keyser456

    250+ unique TQL requests, best way to go about it?

    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...
  4. keyser456

    Proper permission setup for use with an ASP.NET web app?

    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. :(
  5. keyser456

    Proper permission setup for use with an ASP.NET web app?

    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...
  6. keyser456

    Form Designer Application...

    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...
  7. keyser456

    DropDownList woes in Dynamic Datagrid

    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...
  8. keyser456

    Postback questions

    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...
  9. keyser456

    DropDownList woes in Dynamic Datagrid

    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...
  10. keyser456

    Session State - When to use and how to clean up?

    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...
  11. keyser456

    Session State - When to use and how to clean up?

    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...
  12. keyser456

    Session State - When to use and how to clean up?

    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...
  13. keyser456

    Printing - Best to print from Server or from local data?

    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...
  14. keyser456

    ComboBox Event Problems

    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...
  15. keyser456

    ComboBox Event Problems

    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...
  16. keyser456

    Programming - A perfectionist's worst nightmare?

    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...
  17. keyser456

    Can't track this error

    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...
  18. keyser456

    Can't track this error

    ...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 tab out to or click on another field in the same record, a new...
  19. keyser456

    The IDE - Friend or Foe?

    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...
  20. keyser456

    Business Logic Layer - How to implement?

    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...

Part and Inventory Search

Back
Top