Csharp/C Sharp/Database ADO.net/Database Utilities

Execute your Sql query

<source lang="csharp"> using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data.SqlClient; public class Queries : System.Windows.Forms.Form {

   private System.Windows.Forms.TextBox txtResult;
   private System.Windows.Forms.Label label1;
   private System.Windows.Forms.Label label2;
   private System.Windows.Forms.Button cmdExecute;
   private System.Windows.Forms.TextBox txtSql;
   private System.ruponentModel.Container components = null;
   public Queries() {
       InitializeComponent();
   }
   private void InitializeComponent() {
       this.txtSql = new System.Windows.Forms.TextBox();
       this.txtResult = new System.Windows.Forms.TextBox();
       this.label1 = new System.Windows.Forms.Label();
       this.label2 = new System.Windows.Forms.Label();
       this.cmdExecute = new System.Windows.Forms.Button();
       this.SuspendLayout();
       this.txtSql.Location = new System.Drawing.Point(0, 32);
       this.txtSql.Multiline = true;
       this.txtSql.Name = "txtSql";
       this.txtSql.Size = new System.Drawing.Size(400, 72);
       this.txtSql.TabIndex = 0;
       this.txtSql.Text = "";
       this.txtResult.Location = new System.Drawing.Point(0, 184);
       this.txtResult.Multiline = true;
       this.txtResult.Name = "txtResult";
       this.txtResult.Size = new System.Drawing.Size(400, 88);
       this.txtResult.TabIndex = 1;
       this.txtResult.Text = "";
       this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
       this.label1.Location = new System.Drawing.Point(8, 8);
       this.label1.Name = "label1";
       this.label1.Size = new System.Drawing.Size(384, 16);
       this.label1.TabIndex = 2;
       this.label1.Text = "Type a SQL statement in the text box.";
       this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
       this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
       this.label2.Location = new System.Drawing.Point(0, 160);
       this.label2.Name = "label2";
       this.label2.Size = new System.Drawing.Size(392, 16);
       this.label2.TabIndex = 3;
       this.label2.Text = "Execution Result";
       this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
       this.cmdExecute.Location = new System.Drawing.Point(152, 112);
       this.cmdExecute.Name = "cmdExecute";
       this.cmdExecute.Size = new System.Drawing.Size(104, 32);
       this.cmdExecute.TabIndex = 4;
       this.cmdExecute.Text = "Execute Command";
       this.cmdExecute.Click += new System.EventHandler(this.cmdExecute_Click);
       this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
       this.ClientSize = new System.Drawing.Size(400, 275);
       this.Controls.Add(this.cmdExecute);
       this.Controls.Add(this.label2);
       this.Controls.Add(this.label1);
       this.Controls.Add(this.txtResult);
       this.Controls.Add(this.txtSql);
       this.Name = "Queries";
       this.Text = "Tables and Relationships";
       this.ResumeLayout(false);
  }
  private void cmdExecute_Click(object sender, System.EventArgs e) {
       try{
           SqlConnection conn = new SqlConnection(@"server=(local)\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"); 
           conn.Open();
           string strSQL=txtSql.Text;
           SqlCommand cmd= new SqlCommand(strSQL, conn);
           cmd.ExecuteReader();
           conn.Close();
           txtResult.Text = "SQL executed successfully.";
        } catch (System.Data.SqlClient.SqlException ex) {
           txtResult.Text =
              "There was an error in executing the SQL. " +
              "Error Message:" + ex.Message; 
        }
  }
  static void Main() {
     Application.Run(new Queries());
  }

}

      </source>