You may follow below steps to work with your Dynamic Button and Textboxes.
1) Create an Event for your Dynamic Button and assign it to EventHandler of your Button.
btnMyDynamicButton.Click += new System.EventHandler(this.btnMyDynamicButton_Click);
void btnMyDynamicButton_Click(object sender, System.EventArgs e)
{
}
2) Try as below code for you Data-Insertion.
SqlConnection conn = new SqlConnection("Your connection string here.");
string sql = "INSERT INTO connect_com (col1,col2,col3) VALUES (@Val1,@Val2,@Val3)";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Val1", myDynamicTextbox1.Text);
cmd.Parameters.AddWithValue("@Val2", myDynamicTextbox2.Text);
cmd.Parameters.AddWithValue("@Val3", myDynamicTextbox3.Text);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
}
finally
{
conn.Close();
}