public void btnVisualTest_Click(object sender, EventArgs e) { toGlobal fileStuff = new toGlobal(); //`fileStuff.ee(); SQLfx Data = new SQLfx(); SqlConnection con = Data.openSQLConnection(); // Open SQL Connection SqlCommand cmd = new SqlCommand(); // cmd.Connection = con; SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM trialList", con); DataTable dtbl = new DataTable(); sqlDa.Fill(dtbl); dataGridView1.DataSource = dtbl; }
public Form1() { InitializeComponent(); updateDataTable(); toGlobal tG = new toGlobal(); StringBuilder output = new StringBuilder(); int numEntries = 0; if (!tG.checkEmptyTable("condPresets")) { SQLfx Data = new SQLfx(); SqlConnection con = Data.openSQLConnection(); // Open SQL Connection SqlCommand cmd = new SqlCommand("SELECT condLabel FROM condPresets", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow dr in dt.Rows) { foreach (DataColumn col in dt.Columns) { output.AppendFormat("{0},", dr[col]); } numEntries++; output.AppendLine(); } if (numEntries == 0) { return; } } foreach (string s in output.Replace("\n", "").Replace("\r", "").ToString().Split(',').Distinct()) { Console.WriteLine(s); if (s.Length > 0) { cbPreset.Items.Add(s); } } }
private void btnStart_Click(object sender, EventArgs e) { SQLfx Data = new SQLfx(); SqlConnection con = Data.openSQLConnection(); // Open SQL Connection SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO properties (DCP, NMD, RSD, RND, FCA, PCA, MPA, IST) VALUES (@DCP, @NMD, @RSD, @RND, @FCA, @PCA, @MPA, @IST);"; cmd.Parameters.AddWithValue("@DCP", Convert.ToString(txtDataCollectionPeriod.Text)); cmd.Parameters.AddWithValue("@NMD", txtNearMissDistance.Text); cmd.Parameters.AddWithValue("@RSD", txtRespawnStartDistance.Text); cmd.Parameters.AddWithValue("@RND", txtRespawnEndDistance.Text); cmd.Parameters.AddWithValue("@FCA", txtFullCheckAngle.Text); cmd.Parameters.AddWithValue("@PCA", txtPartialCheckAngle.Text); cmd.Parameters.AddWithValue("@MPA", txtMaxPitchAngle.Text); cmd.Parameters.AddWithValue("@IST", iST.Text); cmd.ExecuteNonQuery(); toGlobal fileStuff = new toGlobal(); if (txtID.Text.Length == 0) { txtID.Text = "ID"; } fileStuff.ee(txtID.Text, txtAge.Text, Sex.Text, txtHeight.Text, txtPath.Text, textBox7.Text); cmd.ExecuteNonQuery(); String query = "DELETE FROM dbo.properties"; cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); Process.Start(@"C:\vr\vr3\main.py"); //txtID.Text = ""; }