foreach (Control ctrl in Controls) { if (ctrl is Button) { ctrl.Click += new EventHandler(btn1_Click); string strConn = string.Empty; strConn = ConfigurationManager.AppSettings["DataDB"]; //SqlConnection _con = new SqlConnection(conString); SqlConnection _con = new SqlConnection(strConn); _con.Open(); //create command SqlCommand cmd = _con.CreateCommand(); // cmd.Parameters(1); //specify stored procedure to execute cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Each_Values"; DataTable rdr = new DataTable(); rdr.Load(cmd.ExecuteReader()); Console.WriteLine(rdr.Rows[0][0].ToString()); } }
Each_Values
btn1_Click
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)