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: *

  • Users: DSect
  • Content: Threads
  • Order by date
  1. DSect

    Powerbuilder 10.x PDF Question

    Hello, I'm a .NET programmer helping someone with PDF creation in PB 10. We ran into a roadblock using the GhostScript technique of PDF writing as we are not allowed to have kernel-mode drivers on our server (it is not an option on this production server ie because of company policy). I don't...
  2. DSect

    Let's talk about desktop / web app DB considerations.

    What do you do if you have a desktop app that uses a locally-housed DB on a local server, but you also have a website that would also like to use the local DB's data? A good example is a scheduling application: Your desktop app handles scheduling and you'd like customers to be able to schedule...
  3. DSect

    SQL Bluk / Batch update

    I've searched but have been unable to find info on this operation: I have data that looks like this: Row_ID | Value --------------- 10 | 8273 15 | 211 23 | 214 28 | 4432 31 | 232 I need to update a table with this info. where the Row_Id corresponds to a Row_ID in table...
  4. DSect

    ZIP'ing from ASP.NET

    I have some files stored in folders. I have the path & file name in a DB. I'd like to let people download the files (each record has one or more files) in the DB / folder as a ZIP. Does anyone recommend a good ZIP component? I'm messing with SharpZipLib now...
  5. DSect

    Adding controls @ runtime - How can I put a <BR> between them?

    Hello - I have 2 tables that I creat @ run time in my application and I make them appear by doing Page.Controls.Add(myTable) This works great, but since I am adding 2 tables, I am unable to get a <BR> (line break) between them. So, by adding them at runtime I'm unable to format the space...
  6. DSect

    For..Loop: Stepping through columns and values in a DataReader

    Hello - I'm trying to figure out how to step through the DataReader when building a "confirmation page" for my app. Basically - I'd like to see code to Response.Write the Column Name and the Value of that column.. This record set is only one record, with about 8 columns. In long hand, it...
  7. DSect

    Outputting BIT datatypes as a word?

    Hello - Is there an easy way to do a T-SQL SELECT statement and have the results return the word "YES" for 1 and "NO" for 0 for a BIT datatype column? REPLACE can do one part of it, I think.. But, I'm not sure of how to do it for YES and NO. Sample data: ------------------ 1 0 0 1 0 Sample...
  8. DSect

    Select 2 columns as 1, based on values in columns? (samples)

    I have 2 columns: Title_A and Title_B In each row, Title_A or Title_B may be NULL, but both columns will never have NULL on the same row. How can I return a singular "Title" column in a SQL Server 2K Stored Procedure? Sample of table data: Sample of desired output: Proper normalization...
  9. DSect

    Function to Return Datareader?

    Hello - I'm at an interim point in my learning, here.. I'm starting to understand "objects" and OOP and their roles. In fact, I'm finding out more and more that what I need is some kind of Data Manager or Data Access Class. So - I tried something like this in it's simplest form. I wanted to...
  10. DSect

    [DB Design Advice] How to handle this situation.

    Hello - I'm trying to unify many satellite DBs @ my work. Right now, they do not share the same "Customers" table. I'm trying to bring the systems together with a new DB. Here's the structure of some of these DBs: Customers Orders Order Details Payment Information ^ All structured like a...
  11. DSect

    Outlook / Exchange Q?: How to remove &quot;Exchange Account&quot; option 4 send.

    Quick question: I have an IMAP server for internet mail and an Exchange 2K server that I use for various other things. In order for people to use the stuff on the exchange server, I have to "add" it as an account to Outlook. Here's the problem: The Exchange server is not a real mail server...
  12. DSect

    Loop through a table - For Each Record in table, execute an SP

    Hello - I'm new to "looping" in MS SQL Server 2K and I have this question: How can I loop through a database table, for each record in the table I need to execute a stored procedure and update a temporary table based on the SP results? I know how to do everything but the loop.. Here's an...
  13. DSect

    How to add rows to a table control? [Beginner]

    Here's a basic question: I'm trying to add rows to a table dynamically. My current code only creates 1 row w/ 2 cells in it: Dim r As New TableRow() Dim c As New TableCell() c.Controls.Add(New LiteralControl("ROW 1")) r.Cells.Add(c) tbl.Rows.Add(r)...
  14. DSect

    Does autocomplete work when in HTML mode (no code behind page)

    Question: If I make a simple ASPX page and type some VB in between <script> tags, the autocomplete feature seems to not work (where it shows the methods & properties of an object). Does VS not autocomplete on a one-page .ASPX file as compared to how it works in something like a codebehind...
  15. DSect

    Need Advice: How to Wrap This DB Activity in Try..Catch..Finally

    Ok - here's the simplified work flow w/ no error handling - 1. Start SQLTransaction 2. Insert Data 3. Grab @@Identity 4. Do A Work Process (Process a credit card) 4a. If Work Fails Rollback Trans - Close Connection - Exit 4b. If Work Passes Go to #5. 5. Insert More Data 5a. If Insert ok , then...
  16. DSect

    Selecting &quot;most current info&quot; without using a date datatyped field.

    I'd like to select information from the current year for each customer. If there is no information for the current year, I'd like to move to the earlier year range. The current year changes after July 1st. If you updated your information right now, it would be tagged with "2004-2005". If you...
  17. DSect

    ASP.NET Panels for Multi-Section Form = NETSCAPE Problems

    I was testing a simple form: 2 Panels Each panel has a textbox, requiredfield validator and a button On page load, panel 1 is visible, panel 2 is not visible. Panel 1's textbox has required field validator Clicking button on panel one makes Panel 1 not visible and Panel 2 visible Here's the...
  18. DSect

    CustomValidator - Making it do more..

    Hello - I'm new to ASP.NET and I like the validation controls. But - I would like to use the CustomValidator to check for string length. Problem: Say I have 6 text boxes, all requiring validation restricting string lengths. If I use the CustomValidator as is, I am limited to providing...
  19. DSect

    Validating a textbox / Check for 2 Conditions / CustomValidator

    Hello - I'm an ASP 3.0 person who's new to .NET and I'm trying to figure out how to do something I do in ASP. I would like to validate a textbox for 2 conditions: Is textbox empty / null and is the string length over 30 chars. In ASP, I'd do it like this (using 2 custom functions): If...
  20. DSect

    ASP.NET 2.0

    I use ASP 3.0 and will soon be moving to ASP.NET. I've read a bit on ASp.NET 2.0 and I am wondering if it's available for use now? Does it require a different ver. of the .NET framework? What version of Visual Studio is best for ASP.NET 2.0 development? Thanks - I've been unable to find...

Part and Inventory Search

Back
Top