Search:

Type: Posts; User: coolwater

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    11
    Views
    10,887

    VS 2010 Re: Datagridview auto calculate columns.

    Thanks for the reply. My dilema is my UnitPrice column (readonly) is dependent on the combobox column. Everytime the combobox selected value is changed the UnitPrice column is also updated. Somehow...
  2. Replies
    11
    Views
    10,887

    VS 2010 Re: Datagridview auto calculate columns.

    My GetOtherFeeAmount Code:


    Private Function GetOtherFeeAmount(intSLID As Long, intSYID As Long, intSemesterID As Long) As Decimal

    Using con As SqlConnection = New SqlConnection(CS)...
  3. Replies
    11
    Views
    10,887

    VS 2010 Re: Datagridview auto calculate columns.

    BTW: I edited my post above. I noticed I can add new rows with no errors. The error will only occur if I go back to a combobox and change the selection or cancel a new row.
  4. Replies
    11
    Views
    10,887

    VS 2010 Re: Datagridview auto calculate columns.

    Thanks for the reply. I got this error. Unable to cast object of type 'System.Int64' to type 'System.Data.DataRowView',
  5. Replies
    11
    Views
    10,887

    VS 2010 Datagridview auto calculate columns.

    Need Help. I have a Datagridview that have the following columns.


    ID
    Products
    Qty
    UnitPrice
    Total
  6. VS 2010 Re: Refresh Datagridview (datasource is bindingsource).

    I'm still lost. To my understanding to initialize a connectionstring is to open a connection. This is what I did.

    'Set the query filter.
    Using con As SqlConnection = New...
  7. VS 2010 Re: Refresh Datagridview (datasource is bindingsource).

    I modified the 'Set the query filter

    'Set the query filter.

    daChild.SelectCommand.Parameters.Add("@UserID", SqlDbType.BigInt, 8, "UserID")
    ...
  8. VS 2010 Re: Refresh Datagridview (datasource is bindingsource).

    Tnx for replying. I got this error: An SqlParameter with ParameterName 'UserID' is not contained by this SqlParameterCollection.

    This is my GetDataSet Code:


    Private Function GetDataSet()...
  9. VS 2010 Re: Refresh Datagridview (datasource is bindingsource).

    jmcilhinney tnx for replying. Hmmm my user transactions (tblUsers_OR) have a LastUpdate (datetime) and TStamp (timestamp) columns. I don't have a isActive column. I guess I'll go with the 1st...
  10. VS 2010 Refresh Datagridview (datasource is bindingsource).

    I have two datagridviews (parentDatagridview and childDatagridView). The parentDatagridview datasource is Bindingsource1 and childDatagridview datasource is Bindingsource2. Thanks to jmcilhinney for...
  11. Re: Master/Detail (Parent/Child) Data-binding (.NET 2.0+ WinForms)

    ok thanks.
  12. Re: Master/Detail (Parent/Child) Data-binding (.NET 2.0+ WinForms)

    @jmcilhinney I used your code above by using two datagridviews. It worked perfectly. Thanks.

    Question: I would like to put a refresh button to see if there are changes in the child...
  13. Re: [RESOLVED] Print Directly to Printer with RDLC Report

    I also had the same error. I followed the MSDN tutorial to the letter. I got the solution when I read wes4dbt advice to open the rdlc file with the xml editor. In the xml editor I found the xml tag...
  14. VS 2010 Re: Catching errors while using System.Transaction in Using Statement?

    Got it. Again tnx.
  15. VS 2010 Re: Catching errors while using System.Transaction in Using Statement?

    Hi jmcilhinney. tnx for replying.

    BTW I'm using your code. It helped me a lot. Thank you very much.

    I would like the transaction to rollback if errors are detected and commit if there are no...
  16. VS 2010 [RESOLVED] Catching errors while using System.Transaction in Using Statement?

    How can I trap errors by using "Using Statement".

    I would like to use System.Transactions namespace to commit (if no errors) and rollback transactions (if there are errors).

    What is the best...
  17. VS 2010 Re: [RESOLVED] Datagridview Search through all Columns and Rows?

    Thanks Kaliman79912 for the tutorial. Your help is greatly appreciated.
  18. VS 2010 Re: Datagridview Search through all Columns and Rows?

    thanks kaliman79912. It took me awhile to get it to work.

    My code:

    Private Function FindItems(ByVal strSearchString As String) As Boolean

    dgvDisbursements.SelectionMode =...
  19. VS 2010 Re: Datagridview Search through all Columns and Rows?

    Again tnx Kaliman79912 for helping me out. I will try this later. Need to go to sleep (1:30 am).
  20. VS 2010 [RESOLVED] Datagridview Search through all Columns and Rows?

    Is there a way to search all columns and rows in a datagridview? My goal is to have a Search Textbox and Find button. User will enter search string in the textbox and press the find button to search....
  21. Replies
    12
    Views
    11,362

    VS 2010 Re: Datagridview looping issue?

    Thanks kaliman79912 for pointing me the solution.

    Updated code:


    Dim isTrue As Boolean

    If cboisCleared.SelectedIndex = 0 Then
    For Each row As DataGridViewRow...
  22. Replies
    12
    Views
    11,362

    VS 2010 Re: Datagridview looping issue?

    Thaks for replying Kaliman79912. Ok I think I got what you mean. I'll try that.
  23. Replies
    12
    Views
    11,362

    VS 2010 Re: Datagridview looping issue?

    Those are comments. sorry
  24. Replies
    12
    Views
    11,362

    VS 2010 Re: Datagridview looping issue?

    cboisCleared list items


    0 = Uncleared
    1 = Cleared



    This is my code:
  25. Replies
    12
    Views
    11,362

    VS 2010 Re: Datagridview looping issue?

    Tnx kaliman79912 for replying. I've updated my post above. What I meant was I want to loop to the datagridview and check if the checkbox column is true or false and update the database. Right now my...
  26. Replies
    12
    Views
    11,362

    VS 2010 [RESOLVED] Datagridview looping issue?

    I have this Datagridview that has a Checkbox column. I also have a button to update the database. What I want to accomplish is to loop all rows that has a checkbox column value will be submitted to...
  27. Replies
    3
    Views
    4,840

    Re: [RESOLVED] Datagridview checkbox problem

    Thanks IanRyder. I like your solution. It's better.
  28. Replies
    3
    Views
    4,840

    Re: Datagridview checkbox problem

    I got it. I read a solution from this link http://geekswithblogs.net/FrostRed/archive/2008/09/07/125001.aspx
  29. Replies
    3
    Views
    4,840

    [RESOLVED] Datagridview checkbox problem

    Hello. Please bear with me I'm new to vb.net.
    I have this datagridview problem.

    Scenario:

    My Database columns.

    -isCleared (boolean)
    -DateCleared (DateTime)
  30. Re: Help Datagridview error: datagridviewcomboboxcell value is not valid?

    I got it. Stupid of me. I found the error. It's in my update storedproc. I failed to put the original ID parameter.

    Original SP:


    USE [SimpleAcctg]
    GO
    /****** Object: StoredProcedure...
  31. Re: Help Datagridview error: datagridviewcomboboxcell value is not valid?

    I read this article http://www.kebabshopblues.co.uk/2007/03/24/datagridviewcomboboxcell-errors-in-visual-studio-2005/comment-page-1/. I have the exact problem. I followed the author's solution but...
  32. Re: Help Datagridview error: datagridviewcomboboxcell value is not valid?

    Sorry for the late reply. Yes I have checked the size of the fields in my tables. Again it is weird my sqladapter commands are working. Insert, delete and update commands are successfully executed....
  33. Re: Help Datagridview error: datagridviewcomboboxcell value is not valid?

    Yes the user simply go to any cell and edit the values. My DGV is bound to a datatable. To save the data is use sqladapter.update(table). Inserting and deleting data is not a problem. The editing...
  34. Re: Help Datagridview error: datagridviewcomboboxcell value is not valid?

    The combobox is a lookup. User can only select from the list. User cannot add a new item on the combobox. Weird if I delete the row that I want to edit and then add a new row, I get no errors. But if...
  35. [RESOLVED] Help Datagridview error: datagridviewcomboboxcell value is not valid?

    I have a datagridview (bound to a DataTable) that has a combobox column (bound to bindingsource). Inserting data is not a problem. The problem occurs when I edit a row the datagridview throws an...
  36. VS 2010 Re: Help Insert Update Delete Datagridview using MS Sql stored procedures.

    I think I got it. I removed the using statement on my myownSqlCommandBuilderCode sub. Thanks @jmcilhinney for the tutorials.
  37. VS 2010 Re: Help Insert Update Delete Datagridview using MS Sql stored procedures.

    I 'm trying to duplicate the SQLCOMMANDBUILDER by creating my own insert, update, delete commands using storedprocedures. I'm stuck with this error on buttonSave_Click: sqladapter.Update(dtable)...
  38. VS 2010 Re: Help Insert Update Delete Datagridview using MS Sql stored procedures.

    I'm sorry I'm quite slow. When will I call the sub InitialiseDataAdapter()? On Form Load?
  39. VS 2010 Re: Help Insert Update Delete Datagridview using MS Sql stored procedures.

    Thanks for replying. I read your thread. Question: The code InitializeDataAdapter how can I implement this on a Datagridview? Sorry I'm new to .NET. How can I supply the parameters using datagridview...
  40. VS 2010 Re: Help Insert Update Delete Datagridview using MS Sql stored procedures.

    I think I kinda found a solution: (But I really don't understand the side effects on the database side.) Since SQLCommandBuilder made the insert, update, delete commands for me, does it mean I no...
Results 1 to 40 of 215
Page 1 of 6 1 2 3 4



Click Here to Expand Forum to Full Width