-
May 27th, 2009, 08:19 PM
#1
Thread Starter
Lively Member
[RESOLVED] Adding textbox value to Datagrid column
is this possible?
-
May 28th, 2009, 01:58 AM
#2
Thread Starter
Lively Member
Re: Adding textbox value to Datagrid column
i already figure it out... hehehehe.. thanks anyway to all who's trying to solve this..
-
May 28th, 2009, 02:10 AM
#3
Member
Re: Adding textbox value to Datagrid column
Originally Posted by __wired__
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
-
May 28th, 2009, 02:40 AM
#4
Thread Starter
Lively Member
Re: Adding textbox value to Datagrid column
vb Code:
DataGrid1.Columns(2) = Text12.Text DataGrid1.Columns(3) = Text13.Text 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|