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()); } }