Results 1 to 4 of 4

Thread: [RESOLVED] Adding textbox value to Datagrid column

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2009
    Posts
    66

    Resolved [RESOLVED] Adding textbox value to Datagrid column

    is this possible?


  2. #2

    Thread Starter
    Lively Member
    Join Date
    Mar 2009
    Posts
    66

    Re: Adding textbox value to Datagrid column

    i already figure it out... hehehehe.. thanks anyway to all who's trying to solve this..

  3. #3
    Member
    Join Date
    Jan 2009
    Location
    Philippines
    Posts
    36

    Re: Adding textbox value to Datagrid column

    Quote Originally Posted by __wired__ View Post
    i already figure it out... hehehehe.. thanks anyway to all who's trying to solve this..
    im having d same probs.. what did u do? pls tell me..

    thnx in advance....ehehe

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Mar 2009
    Posts
    66

    Re: Adding textbox value to Datagrid column

    vb Code:
    1. DataGrid1.Columns(2) = Text12.Text
    2.     DataGrid1.Columns(3) = Text13.Text
    3.     DataGrid1.Columns(4) = Text14.Text

    but.. instead of creating a new columns.. i just created a new fields to the database.. i leave it empty.... btw.. this text contains numbers.. then i sum it up.. here's my code:

    rs.Open "SELECT IDNO, NAME, PLEVEL, SUM(H_RB)as H_RB, " _
    & "SUM(H_HS) as H_HS, SUM(H_SF) as H_SF, SUM(H_DF) as H_DF, " _
    & "ROOM_BOARD, HOSP_SVCS, SURGIC_FEE, DOCTOR_FEE, SUM(AAR_AMOUNT) as AAR_AMOUNT, SUM(AVAILMENT) as AVAILMENT, SUM(TOTALBEN) as TOTALBEN from qryMB WHERE TRANDATE>=#" & dtp1.Value & "# " _
    & "and TRANDATE <=#" & dtp2.Value & "# GROUP BY NAME, IDNO, PLEVEL, ROOM_BOARD, HOSP_SVCS, SURGIC_FEE, DOCTOR_FEE, AAR_AMOUNT, AVAILMENT, TOTALBEN", conn, 3, 3

    highlighted ones are the value of the 3 textboxes...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width