private void button1_Click(object sender, EventArgs e) { try{ var cn = new Connection_Handler(); string input = selectinput.Text; string reader = cn.Execute_SQL(input).ToString(); MessageBox.Show(reader); } catch(Exception ex){ MessageBox.Show(ex.Message); } } class Connection_Handler { SqlConnection cn; void ConnectiontoSQL() { string str = "server=xxx; database=jobSearch; user=sa; password=xxx"; cn = new SqlConnection(str); cn.Open(); } public int Execute_SQL(string select) { ConnectiontoSQL(); string Query = "select " + select + " from jobSearch where searchID = 1"; SqlCommand cmd = new SqlCommand(Query, cn); SqlDataReader reader = cmd.ExecuteReader(); return Convert.ToInt32(reader); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)