How do I merge two tables in sql server SPECIFICALLY using WINDOWS FORM C# and not SQL : I have two tables:

    StudentSection1 with the following fields and information:
    
    StudentID (int)(PK)     StudentName (varchar(100))     StudentGender (varchar(100))
    1                        Henry                                 Male    
    2                        Scarlette                            Female
    
    StudentSection2 with the following fields and information:
    
    StudentID (int)(PK)     StudentName (varchar(100))     StudentGender (varchar(100))
    1                        Jack                                  Male    
    2                       Elizabeth                            Female

Name of database: StudentDB

*I know that there are related questions here, but all I see are answers that only cater to manipulating sql directly and not windows form c#. And I know that there Student ID's should be different, but let's just say each section has it's own ID numbers for it's students (as impossible as it may seem)

Anyway, what I want to know is how I can manipulate this SPECIFICALLY in c# WINDOWS FORM (not in sql server) in such a way that when I press a button in windows form, it will merge both tables together PERMANENTLY in sql server. I would prefer if maybe StudentSection2 is combined into StudentSection1, but any workaround is fine. I'm pretty sure this involves code which contains connectionstring etc, but I'm not really sure about this area. Any help would be really useful, thank you very much guys.