Search:

Type: Posts; User: Tom Sawyer

Page 1 of 13 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    4
    Views
    1,195

    Re: Linked Lists

    Ya, that was just for one specific example. I can't, for instance, see a situation where I'd use a LinkedList instead of a List and numerous articles about performance tests between the two seem to...
  2. Replies
    4
    Views
    1,195

    Re: Linked Lists

    Ya, that's kind of the heart of the question that I was asking. Are they a general theoretical concept that it's nice to know to be able to better understand the technical concepts behind...
  3. Replies
    4
    Views
    1,195

    Linked Lists

    I had a job interview yesterday and it came with a C# technical test involving building a class that did stuff with a LinkedList. I've never used one of those in my life and a basic google around...
  4. Replies
    0
    Views
    868

    Scripting Stored Procedures in Sybase

    Does anyone know how to go about scripting out all the stored procedures in a Sybase database? We're putting them into source control, but I can't find a way to do it any other way than by going...
  5. Replies
    1
    Views
    763

    Update and Group By

    I have a query that I'm running:

    SELECT ProductSymbol, COUNT(ProductKey)
    FROM OptClosePrice
    GROUP BY ProductSymbol
    HAVING COUNT(ProductKey) = 1

    What I want to do is update a field for the...
  6. Replies
    2
    Views
    1,120

    Re: Add Subrow to an MSHFlexGrid

    Ya, it looks like I'm stuck with something like that.
  7. Replies
    2
    Views
    1,120

    Add Subrow to an MSHFlexGrid

    I have a heirarchial flex grid which I've added a bunch of data to using some custom functions. It works fine as a grid, but now I want to get it to expand a subrow for some of the rows to display...
  8. Replies
    4
    Views
    3,948

    Re: SSRS Report Events

    Ya, unfortunately we're using a Sybase database, so we can't put them into stored procedures.
  9. Replies
    4
    Views
    3,948

    Re: SSRS Report Events

    Actually, the database fields are encrypted and the decryption routines are done in .NET (it's a Sybase database which was built for a VB6 appliaction, so the encryption is weird). Basically, the...
  10. Replies
    4
    Views
    3,948

    SSRS Report Events

    I have an application which uses the ReportViewer control to load up some SSRS reports and display them within the app. We have some custom code that runs on the RenderingBegin and RenderComplete...
  11. 3.0/LINQ Re: Concatenate List of custom type based on a property

    Ya, got that. The problem was that I hadn't made the ColumnName property public so it wasn't coming up as a valid option.

    Doh. :(

    Thanks a lot.
  12. 3.0/LINQ [RESOLVED] Concatenate List of custom type based on a property

    I had a program where I was generating dynamic sql queries based on some column information in XML files that I put into a List<string>.

    It was pretty basic along the lines of:



    string...
  13. Re: Logging into a WebService using Network Credentials

    Never mind. The problem was that I was setting the variable historyID to an empty string as opposed to having it be null. That apparently throws an error that's completely unrelated to the problem...
  14. [RESOLVED] Logging into a WebService using Network Credentials

    I have an app where I'm trying to log into an SSRS reporting service on another domain. I have an account on that domain where I'm an administrator both on the SSRS and on the Windows. I am trying...
  15. Replies
    1
    Views
    499

    Re: Read what is "copied"

    You can just use the Clipboard class:



    Dim x as String
    x = Clipboard.GetText()

    MessageBox.Show(x)
  16. VS 2010 Re: Droping Down the list from a ComboBox? [HELP]

    I just tried a test and this worked:


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Me.ComboBox1.Focus()
    ...
  17. VS 2010 Re: Droping Down the list from a ComboBox? [HELP]

    This might help:

    http://stackoverflow.com/questions/4295785/how-do-i-get-datagridview-comboboxes-to-display-their-drop-down-list-in-one-clic

    If, where you want to have the list display, you set...
  18. Replies
    6
    Views
    1,277

    Re: Regex does not end with

    Ya, that works too, but I'd like to know how the "not ends with" works.
  19. Replies
    6
    Views
    1,277

    Re: Regex does not end with

    Ya, I got it done fine without using the regular expressions, but it seems like the kind of thing which regular expressions can do and I want to try them out.
  20. Replies
    6
    Views
    1,277

    Regex does not end with

    I've got an application which loads up some Excel files and imports them into a database. There are only certain of the sheets which I want, which are all timestamped and have either an am or pm on...
  21. Replies
    3
    Views
    12,521

    Re: SSIS locking Excel file

    No, it's not a silly suggestion. It's a goddamned genius suggestion is what it is and it worked!

    If there's an error I can copy the file back to the import folder for a rerun because it's only...
  22. Replies
    3
    Views
    12,521

    [RESOLVED] SSIS locking Excel file

    I have an Excel file that I'm uploading into SQL Server via SSIS. The upload works fine, but I'm having an issue where at the end of the process, I want to move the file from the input folder to a...
  23. Replies
    4
    Views
    610

    Re: [RESOLVED] Math Question about time

    Ya. Oh well. Thanks for your help.
  24. Replies
    4
    Views
    610

    Re: Math Question about time

    Ya, they're actually strings with the 0 added infront for hours where that's needed which I was converting into integers because I thought it would be easier. That failed miserably.

    I did it with...
  25. Replies
    4
    Views
    610

    [RESOLVED] Math Question about time

    I have a database where the times of various trades are stored in an integer format down to the millisecond. For instance, if a stock is bought at 7:15:11.641 seconds, it's stored as 71511641 and if...
  26. Replies
    3
    Views
    1,539

    Re: SSIS Excel Import giving nulls

    Thanks. Your response to my question of how to modify the import to insure it loads as text by telling me I need to modify the import to ensure that it loads as text was most helpful. :D


    I...
  27. Replies
    3
    Views
    1,539

    SSIS Excel Import giving nulls

    I'm importing an Excel file into SQL Server using SSIS. For one of the columns, the data is as follows:

    SubscriberId
    000223OR
    500299
    500299
    500299
    500299
    SF002AD
    SF002AD
  28. Replies
    4
    Views
    556

    Re: Right choice for large database

    I agree that the SQL Server Express would be your best bet. Bulk insert or bcp your files into the database and then you've got a much easier way to access the data that you do when it's in files.
    ...
  29. Replies
    0
    Views
    1,052

    BCP Alternatives in Sybase

    I'm trying to import a file into a table in Sybase, but the xp_cmdshell is locked down and can't be used. If it were SQL Server, I'd use the BULK INSERT command, but that doesn't seem to work in...
  30. Strip characters from the end of a string

    I have a project where I need to strip out the last characters at the end of a string if it ends in a .TO or a .V - but only at the end. It's a field in a Sybase database.

    For instance, if the...
  31. Replies
    7
    Views
    1,493

    Re: Object Libraries (Excel)

    You're looking for a file called Microsoft.Office.Interop.Excel. It's probably in one of the subdirectories of Program Files/Microsoft Office
  32. VS 2008 Re: Coloring Excel sheet - looking for the most efficient way

    Ya, any use of Excel requires Marshalling and releasing the objects.
  33. Replies
    4
    Views
    631

    Re: Sql Statement Issue

    Ya, change the last line to A.ItemID and it's also redundant to have the text for the ItemID both inside and outside the subquery when you already have the A.ItemID = B.ItemID stated.
  34. VS 2008 Re: Coloring Excel sheet - looking for the most efficient way

    Just use a Range object:


    Dim oRange as Microsoft.Office.Interop.Excel.Range oRange = {worksheet}.Range(worksheet.Cells[row1, cell1], worksheet.Cells[row2, cell2])

    oRange.Font.Bold = True
    ...
  35. VS 2010 Re: Webbrowser control has memory leak - any fix?

    Have you checked out the task manager to see if there are any processes that start running when you load a url through the Webbrowser? It might be that it loads a copy of IE or something and doesn't...
  36. Re: why is everyone moaning about programmers using specific form functions?

    I don't see how having the code inside of another form would improve performance. If the form is aleady open and in use, then sure, but otherwise you're adding the overhead of loading up a new form...
  37. VS 2010 Re: Webbrowser control has memory leak - any fix?

    Have you looked into the GC (Garbage Collection) AddMemoryPressure and RemoveMemoryPressure methods? What might be happening is that the Webbrowser control loads the entire webpage into memory but...
  38. Replies
    8
    Views
    872

    Re: totally lost.

    Ya, we're willing to help you with any problems you have and point you in the right direction, but we're not actually going to do the work for you.
  39. Replies
    2
    Views
    675

    Re: Excel Processing Question

    I'd say that you're probably better off reading it into a dataset and then writing it back into Excel. You can do it with Excel automation, but I've found that to generally be more trouble than it's...
  40. Replies
    6
    Views
    1,206

    Re: Changing the connection string

    Do you have any spaces in your login path? I've run into errors opening a connection to Excel when that was the case - ie the file is in C:\App Docs\Database as opposed to C:\AppDocs\Database.

    If...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width