Add new column in vb.net database

Here are the steps to add a new column to a database table in VB.NET:

Using SQL Server

1. Create a connection to your database using the SqlConnection class:

   Dim conn As New SqlConnection("Data Source=<your_server>;Initial Catalog=<your_database>;User ID=<your_username>;Password=<your_password>")
   conn.Open()

2. Create a SqlCommand object to execute the SQL query:

   Dim cmd As New SqlCommand("ALTER TABLE <your_table_name> ADD <new_column_name> <data_type>", conn)

   Replace <your_server>, <your_database>, <your_username>, <your_password>, <your_table_name>, and <new_column_name> with your actual database credentials and table information.

For example:

Dim cmd As New SqlCommand("ALTER TABLE Customers ADD EmailAddress VARCHAR(50)", conn)

3. Execute the SQL query:

   cmd.ExecuteNonQuery()

   Using ADO.NET

4. Create a connection to your database using the SqlConnection class:

   Dim conn As New SqlConnection("Data Source=<your_server>;Initial Catalog=<your_database>;User ID=<your_username>;Password=<your_password>")
   conn.Open()

5. Create a DataTable object to represent the table:

   Dim dt As New DataTable("Customers")

6. Add the new column to the DataTable:

   dt.Columns.Add("EmailAddress", Type.GetType("System.String"))

7. Update the database table using the DataAdapter:

   Dim da As New SqlDataAdapter("SELECT * FROM Customers", conn)
   da.Update(dt)

   Using Entity Framework

8. Create a DbContext object:

   Dim db As New YourDbContext()

9. Use the DbSet property to access the table:

   Dim customers As DbSet(Of Customer) = db.Set(Of Customer)()

10. Add the new column to the table using the DbSet property:

    customers.Entity.SetColumn("EmailAddress", "string")

11. Save the changes to the database:

    db.SaveChanges()

    Note: The above examples are for adding a new column to an existing table. If you want to add a new table, you can use the CREATE TABLE SQL statement or the DbSet property with the CreateTable method.