How to add Extra Fields to Table Student in SQL From select query in c# In Case OF these Fields Not Exist in Table Student dynamically ?

[engahmedbarbary]

Problem

How to add Extra Fields to Table Student in SQL From select query in c# In Case OF these Fields Not Exist dynamically ?

I have Table Student have 3 fields

StudentId INT,

StudentName nvarchar(50),

Address nvarchar(100)

In c# windows form Visual studio 2015

I have select query

select StudentId,StudentName,Address,Age from Student .

Actually I need IF selectquery Have Extra Fields Alter that in Table dynamically without write Alter statement .

I do Changes More From c# so that I need to alter Table Student By Compare Between Select Query In c# and Table Student in Sql Server Database .

In my case Age will automatically alter table Student when compare structure of Student Table And Query have sql statement ( select StudentId,StudentName,Address,Age from Student ) in c# .

Can Any One Tell Me How to do that Please ?

Continue reading...