Click here to Skip to main content
11,479,170 members (63,741 online)
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)182.3K
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 Sergey Alexandrovich Kryukov 215
1 F-ES Sitecore 195
2 OriginalGriff 185
3 Frankie-C 120
4 DamithSL 85
0 Sergey Alexandrovich Kryukov 7,890
1 OriginalGriff 7,366
2 Sascha Lefèvre 3,064
3 Maciej Los 2,491
4 Richard Deeming 2,335


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 24 Mar 2013
Copyright © CodeProject, 1999-2015
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