Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB
I have combobox, Then Textbox1
 
Then i have button called add
 
Then Flexgrid
 

when i select the combobox item, then type in the textbox1,then i click the add button.
that combobox item and textbox1 values is inserted into the flexgrid.
 

then again i open and double click in the flexgrid that flexgrid values is display into the combobox and textbox1.
 
when i made changes in the textbox1 values for the respective combobox item, that combobox item and textbox1 changes values to be inserted into another table.
 
Another table(Name admin track)
 
admin track database design as follows
 
Type Changes TIme
 
what changes i made in the above screen that changes value to be inserted into the admin track table.
 
combo item COC NO
Textbox1 from IF2434 to IF 2440
 
i made the COCNO changes,in to IF2440.
 
In the admin track inserted as follows
 
Type Changes Time
COC No IF2440 wat time changes made by the user will display into the Time field.
 
My code as follows;
 
    If cocno <> Trim(comboxbox1(j).textbox1.text) Then
            reason =  From : " & Lcocno & " to : " & Trim(combobox(j).textbox1.tex)
            sql = "insert into admin_track values('CHANGE COC', '" & changes & "', & "',getdate())"
            con.Execute sql
        End If
but the above code is not working?
 
Please help me.
 
regards,
 
Narasiman P.
Posted 24-Mar-13 4:14am
Edited 24-Mar-13 4:29am
(no name)151.7K
v2
Comments
ThePhantomUpvoter at 24-Mar-13 10:20am
   
"but the above code is not working?" means absolutely nothing to anyone but you. Is it working or not? What is the problem?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,127
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 24 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100