Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Inserts (create) a new table

using System; using System.Data.SqlClient; public class UpdateRecord {     public static void Main()      {         string connectionString = "Data Source=localhost;" +                       "Initial Catalog=Northwind;Integrated Security=SSPI";         string SQL = "CREATE TABLE Users (UserName nvarchar(20), Password nvarchar(20) )";         SqlConnection con = new SqlConnection(connectionString);         SqlCommand cmd = new SqlCommand(SQL, con);         con.Open();         int rowsAffected = cmd.ExecuteNonQuery();         con.Close();         Console.WriteLine(rowsAffected);     } }