Search:

Type: Posts; User: callydata

Page 1 of 4 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    757

    Re: Any tips on SQL connection speed?

    I am using the SQL adapter.

    So how do I optimize the code?
    Make it as lean and effcient as possible? Or is there more to optimization than that?
  2. Replies
    4
    Views
    757

    Re: Any tips on SQL connection speed?

    I am using a Data Adapter and dataset.
  3. Replies
    4
    Views
    757

    Any tips on SQL connection speed?

    I am using SQL 2000 and some of my network connections seem slow on the users computer. any tips, tricks, good practices I can use to speed up the connection?

    thanks,
    callly d
  4. Replies
    4
    Views
    452

    Re: Help with operators

    How do I convert an Integer to a Datetime?
    I couldn't find any clear cut documentation on this.
    Do you have any examples or tutorials I could look at?

    thanks,
    cally
  5. Replies
    4
    Views
    452

    Help with operators

    I have a If Else statement that is comparing a date in the
    database with today's date, but I am getting this error when debugging:

    It breaks on this line of code:
    If...
  6. Replies
    3
    Views
    512

    Re: help with Where clause

    I have looked into using a parameter, but I have problems using a string variable. Do you have an example of this?
  7. Replies
    3
    Views
    512

    [RESOLVED] help with Where clause

    I need to set up a WHERE clause based on a string value which comes from a text box on the form. Is this possible? and if so, what is the easiest way to do this?
  8. Replies
    11
    Views
    1,302

    Re: Help with copy and paste

    Janzuk,
    sorry it took so long to....no coding this weekend!!!!

    just to clarify:
    I want to fill the datagridNew with a datatable, then be able to copy and paste into the datagridUsed. I have not...
  9. ....

    ....
  10. Replies
    11
    Views
    1,302

    Re: Is this possible?

    Janzuk,
    When I debug, the datagrid "dataNew" is not filling with any data, then when I press the button on the form to copy and paste, it copies the entire source code from the form into the first...
  11. Replies
    11
    Views
    1,302

    Re: Is this possible?

    do either of you guys have a tutorial or an example file I could look at? I am still a newbie and a lot of the lingo doesn't mean much to me.
    What about the dataTable copy method, I really don't...
  12. Replies
    11
    Views
    1,302

    Re: Is this possible?

    Help, any opinions please!
  13. Replies
    11
    Views
    1,302

    Help with copy and paste

    I am wondering if its possible to copy and paste rows from one datagrid to another datagrid? I want to be able to select a row, press ctrl-c to copy, then ctrl-v to paste into the other datagrid on...
  14. Replies
    10
    Views
    823

    Re: help updating a datagrid

    I don't have the gen.InventoryLib.InventoryComponent and so this gives me a error, how do I solve this?
  15. Replies
    10
    Views
    823

    Re: help updating a datagrid

    Is this shown in the other post?
    If not, can you show me an example of the syntax?
  16. Replies
    10
    Views
    823

    Re: help updating a datagrid

    I do have my datasource set to a dataset, but theres a problem,
    I keep getting this error b/c I don't know how to write the code that finds the key column so it knows what row to write to.

    heres...
  17. Replies
    10
    Views
    823

    Re: help updating a datagrid

    yes, you are correct!

    If you could show me how to rewrite the outlined code above, I think that will help my situation.

    Thanks
    cally
  18. Replies
    10
    Views
    823

    help updating a datagrid

    This update code saves to the database when bound to textboxes, but how do I write the update code when the data is bound to a datagrid?
    Note: txtNmbNumber.Text is not the same key column for this...
  19. Replies
    3
    Views
    626

    [RESOLVED] Formatting Issue

    How can I format all of my currency data types into the 1123.00 format instead of 1123.0000 format?
    I only want 2 decimal places to show.

    Thanks

    Supercallyfragilisticexpialidocious
  20. [RESOLVED] AHHHHRRRGGGG, Crystal is auto rounding numbers!??!?

    This is weird. I don't think I pressed anything, but you never know. Today all of my decimal numbers are rounded. Yesterday, I looked at the same file, and nothing was rounded, but today rounded....
  21. Replies
    4
    Views
    624

    Re: Archiving Datagrid contents

    So this code will have to go before the archive code?
    How would this work together with this code?
    Or do I even need this[code below] to archive the data?
    Dim drUsedCheck As DataRow =...
  22. Replies
    4
    Views
    624

    [RESOLVED] Archiving Datagrid contents

    I need to archive data from one table into another table. I know how to code this using text boxes to display the data, but how do you write the code when using a datagrid to display data?

    thanks!
  23. Replies
    9
    Views
    825

    Re: Proper Code help

    Stupid question....
    where do I put the INSERT, UPDATE, and DELETE statements within the VB code?
    After I call the SQL adapter fill?
    cally
  24. Replies
    9
    Views
    825

    Re: Proper Code help

    Yes, all the same IDs.
  25. Replies
    9
    Views
    825

    Re: Proper Code help

    I have had very bad luck with join statements, when using the data adapter wizard. All of my tables have an idenity key of an ID number and it hasn't liked that at all. How do I program the...
  26. Replies
    9
    Views
    825

    Re: Proper Code help

    1. An unhandled exception of type 'System.NullReferenceException' occurred in BiWeeklyMock.exe

    Additional information: Object reference not set to an instance of an object.
    I keep getting this...
  27. Replies
    12
    Views
    1,077

    Re: Change datareader to dataset

    Its blowing up on a piece of code that I thought was ok? there are not nulls in the database for this column, so I don't understand the


    Here is the code:
    If drAchGen2("SavingsOrChecking") =...
  28. Replies
    7
    Views
    510

    Re: Simple addition

    I didn't see an option for any other version of Crystal.
  29. Replies
    9
    Views
    825

    Proper Code help

    Here's my code for a "find" customer button. but the only way it works is to add error handling code. I need some help with the proper way to code this.
    What I need to happen is when a "wrong" ID...
  30. Replies
    12
    Views
    1,077

    Re: Change datareader to dataset

    I have changed my code to a data Adapter, but now I am getting the error:
    An unhandled exception of type 'System.NullReferenceException' occurred in BiWeeklyMock.exe

    Additional information:...
  31. Replies
    7
    Views
    510

    Re: Simple addition

    I think the RPT document is attached.
    The faulty addition code is in the formatAmount formula.
    Thanks!
  32. Replies
    7
    Views
    510

    Re: Simple addition

    I have changed the formatting, and I made sure the fields I need to add are numeric in the database. But my addition field will not add. All I am writing is ...
  33. Replies
    12
    Views
    1,077

    Re: Change datareader to dataset

    So then how do I write this code to work with the data adapter. its pulling info from 3 different tables, and each table has an "IDNumber" and the "IDNumber" is the key for each table.
    drAchGen =...
  34. Replies
    7
    Views
    510

    [RESOLVED] Simple addition

    I need to know how to format a simple addition problem:
    {@4}+{@5}+{@6}+{@7}
    I want to add the totals of these formulas:
    If {PAYABLES_TRANSACTION.Starting4} < CurrentDate And...
  35. Replies
    12
    Views
    1,077

    Re: Change datareader to dataset

    Ok question:
    For this line of code, what do I replace it with when using a data adapter?

    drAchGen = cmd.ExecuteReader(CommandBehavior.CloseConnection)
  36. Replies
    12
    Views
    1,077

    Re: Change datareader to dataset

    Oh duh, thats what I meant. I need to replace a datareader with data adapter
  37. Replies
    12
    Views
    1,077

    Change datareader to dataset

    How do I change over from a datareader to a dataset?
    Can someone tell me what code to replace and what to replace it with?
    I would use the datareader, but the problem is the looping.
    Its...
  38. Replies
    1
    Views
    534

    Weird problem with link label

    Hopefully this will make sense?
    I have a link label on a form which links to a datagrid, plain and simple, right? I have this on 3 similar forms with the exact same code and it works great on 2 of...
  39. Replies
    4
    Views
    644

    Re: Anchor Links?

    I have a link label control already to go, what I want, is to link this to another form at a certain part of the form. Just like an anchor link in html...
    do you know what I mean?
  40. Replies
    4
    Views
    644

    [RESOLVED] Anchor Links?

    Hi
    I am still wading through the murky waters of VB.Net
    question: Is it possible to create anchor links, like in html?
    If so, does anyone have a tutorial on that or example code?
    Note: the...
Results 1 to 40 of 139
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width