Execute your Sql query
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
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.ComponentModel.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());
}
}
|
HTML code for linking to this page:
|
|