Click here to Skip to main content
13,044,766 members (44,186 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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.


Narasiman P.
Posted 24-Mar-13 3:14am
Updated 24-Mar-13 3:29am
Maciej Los255.3K
ThePhantomUpvoter 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 24 Mar 2013
Copyright © CodeProject, 1999-2017
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