C#

try
{
con.Open();
String q3 = "update testreport set patientname='" + textBox2.Text + "',address='" + textBox3.Text + "',testreports='" +textBox5.Text + "',reportno='" + textBox6.Text + "',date='" + dateTimePicker1.Value.ToString("dd-MMM-yyyy") + "',takentest='" + textBox4.Text + "'where patientid='" + textBox1.Text + "' ";
                cmd = new SqlCommand(q3, con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("details updated successfully");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "details  not updated");
            }
            con.Close();

using ActiveDirectoryCommon; 
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Windows.Forms; 
using System.Collections.Specialized; 
using System.Deployment.Application; 
using System.Diagnostics; 
using System.Reflection; 
using System.Runtime.Remoting; 
using System.IO; 
using System.Web; 
using System.Configuration; // required to obtain the values from the 
ConfigurationManager.Appsettings in the app.config file 
using System.Security.Principal; 
using System.Threading; 
 
 
namespace File_Reject 
{ 
    static class Program 
    { 
        /// <summary> 
        internal static ActiveDirectoryUser CurUser; 
        [STAThread] 
      
 
        static void Main() 
          { 
              try 
              { 
              Application.EnableVisualStyles(); 
             Application.SetCompatibleTextRenderingDefault(false); 
             CurUser = new ActiveDirectoryUser(); 
             if 
(!Thread.CurrentPrincipal.IsInRole(Environment.UserDomainName + "\\" + ConfigurationManager.AppSettings["role_File_Upload"])) 
              { 
                MessageBox.Show("You do not have authortity to access File Transfer. Please contact your network administrator if you have any 
questions.", "File Transfer Error", MessageBoxButtons.OK, MessageBoxIcon.Error); 
                      return; 
                  } 
                  Application.Run(new FileReject()); 
              } 
                catch (Exception e) 
              { 
                  //console.write(e.Message); 
                 
              } 
 
        } 
    } 
} 
---------- 

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Text; 
using System.Diagnostics; 
using System.Reflection; 
using System.IO; 
using System.Threading; 
using System.Web; 
using System.Windows.Forms; 
using System.Security.Principal; 
 
 
namespace ActiveDirectoryCommon 
{ 
    public class ActiveDirectoryUser 
    { 
        public ActiveDirectoryUser() 
        { 
            
AppDomain.CurrentDomain.SetPrincipalPolicy(PrincipalPolicy.WindowsPrincipal); 
            Thread.CurrentPrincipal = new WindowsPrincipal(WindowsIdentity.GetCurrent()); 
        } 
    } 
} 
-----------
<?xml version="1.0"?> 
<configuration> 
 
  <appSettings> 
    <add key="role_File_Upload" value="File_Upload" /> 
  </appSettings> 

</configuration> 
------------