How can i use HiddenField id as a variable for its value in c#

Question

I have 1000 hiddenfield. How can i put their value in sql database using for loop. Like:

for (int i = 1; i < 1000; i++)
{
    Control hiddenfield = this.FindControl("HiddenField" + i);
        
    String p = Convert.ToString(hiddenfield.Value);
    string sqlquery = ("INSERT INTO [" + table_name2 + "] (CT1) VALUES ('" + p + "')");

    SqlCommand command = new SqlCommand(sqlquery, Connection);
    command.ExecuteNonQuery();
}

Answer 1

change tablename as requred!

        string query = "INSERT INTO tablename ( CT1 ) VALUES ( @value )";
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(query, con);
        try
        {  
            cmd.Parameters.Add("@value", System.Data.SqlDbType.VarChar);
            con.Open();
            for (int i = 1; i < 1000; i++)
            {
                Control hiddenfield = this.FindControl("HiddenField" + i);        
                String p = Convert.ToString(hiddenfield.Value);

                cmd.Parameters["@value"].Value = p;
                cmd.ExecuteNonQuery();
            }
        }
        catch (Exception ex)
        {
            //Show exception as required!
        }
        finally
        {
            con.Close();
            con.Dispose();
            cmd.Dispose();
        }