Click here to Skip to main content
11,704,044 members (66,355 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WinForm
i want to update data after printing it .
for example if admin enter :

previous account=30
added account=40
then:
total account=70

the result will be stored in DB(total account=70) and also will be printed in gridview

but actually after printing ,i want to update previous account=70
how can i do this

SqlConnection con = new SqlConnection(@"");
           SqlCommand command = new SqlCommand();
           command.Connection = con;
           command.CommandText = "update customer set   jj=@a where jj=@d";
           command.Parameters.AddWithValue("@d",name);
           command.Parameters.AddWithValue("@a",total);
           try
           {
               con.Open();
               int i = command.ExecuteNonQuery();
               if (i > 0)
                   con.Close();
 
           }
           catch(Exception ex)
           {
               throw(ex);
           }
       }
Posted 27-Jan-13 10:17am
Edited 27-Jan-13 11:01am
(no name)183K
v2

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

  Print Answers RSS
0 Maciej Los 530
1 OriginalGriff 510
2 Sergey Alexandrovich Kryukov 421
3 Andy Lanng 294
4 F-ES Sitecore 220
0 OriginalGriff 8,744
1 Sergey Alexandrovich Kryukov 7,747
2 CPallini 5,107
3 Maciej Los 4,716
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web01 | 2.8.150819.1 | Last Updated 27 Jan 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