I want to insert data to sql server wiht loop throught !! I have two list 1> FieldName 2> Textbox.text

See more:

C#

I want to insert data to sql server wiht loop throught !! I have two list 1> FieldName 2> Textbox.text

I am working on save class want to make class library for save button which can implement to my all forms including save button for my window application.

I have made save_rec function with parameters like this

public void SaveRec(String Con_String, String Table_Name, Form Frm, int AddFlag, int EditFlag)

my code is below

  public void SaveRec(String Con_String, String Table_Name, Form Frm, int AddFlag, int EditFlag)
        {
             List<Control> TB_List = new List<Control>();
             List<String> Field_Name = new List<String>();
             List<String> TB_Name = new List<String>();


             foreach (Control childcontrol in Frm.Controls)
             {

                 if (childcontrol is GroupBox)
                 {
                     foreach (Control cc in childcontrol.Controls)
                     {


                         if (cc is TextBox)
                         {
                             TB_List.Add(cc);

                         }

                     }
                 }
             }


            if (AddFlag == 1)
            {
                using (SqlConnection con = new SqlConnection(Con_String))
                {

                    foreach (Control Txt_Name in TB_List)
                    {
                        String TxtName = Txt_Name.Text;
                        String field_name = Txt_Name.Name.Substring(3);
                       
                        Field_Name.Add(field_name);
                       
                        TB_Name.Add(TxtName);
                    }




                    SqlCommand cmd = new SqlCommand("Insert into "+ Table_Name + "('"+ Field_Name + "') Values('" + TB_Name + "')", con);
                   
                    
                    
                    
                    con.Open();
                    //SqlDataReader dr = new SqlDataReader();
                    cmd.ExecuteNonQuery(); 
                    

                }
            }
       }

    }
}

I am getting error -

Invalid column name 'System.Collections.Generic.List`1[System.String]'.

Can you give me way to solve this friends ?