----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: SanjayG Message 8 in Discussion Mahesh in your code following if stmt is present -- if (res!>0) do u mean if (res > 0) -----Original Message----- From: mahvb [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 2:54 PM To: MumbaiUserGroup Subject: Re: ExecuteNonQuery Problem New Message on MumbaiUserGroup ExecuteNonQuery Problem Reply Reply to Sender Recommend Message 6 in Discussion From: mahvb Hi Ajay, Here is the code : str to be passed is " update state set fullName='aaaaa' where stateid=1" public int ExecuteCommand(string str) { try { SqlConnection cn = new SqlConnection("connection string"); cn.Open(); SqlCommand cmd = new SqlCommand(str,cn); int res; res= cmd.ExecuteNonQuery(); cn.Close(); if (res!>0) { return 1; } else { return 0; } } catch ( Exception ex ) { return 0; } } Regards Mahesh B. View other groups in this category. "This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group.Before opening any attachments please check them for viruses and defects." ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
