C - Create SQL Server table programmatically

Question

I am trying to create a SQL Server table programmatically  Here is the code   using  SqlConnection con   new SqlConnection conStr          try                             Open the SqlConnection                     con Open                          The following code uses an SqlCommand based on the SqlConnection                     using  SqlCommand command   new SqlCommand  CREATE TABLE Customer First Name char 50  Last Name char 50  Address char 50  City char 50  Country char 25  Birth Date datetime     con               command ExecuteNonQuery               catch  Exception ex                MessageBox Show ex Message             When I m running this application second time I m getting an exception       There is already an object named  Customer  in the database     but when I check database I don t see such a table  Here is my connection string    lt connectionStrings gt     lt add name   AutoRepairSqlProvider  connectionString        Data Source   SQLEXPRESS AttachDbFilename  DataDirectory  AutoRepairDatabase mdf       Integrated Security True User Instance True   gt   lt  connectionStrings gt    When I am running select query  I am getting results from existing tables so I think connection string should be OK  Hope you ll see the problem

User · Answer

If you don t like remembering SQL syntax  using Mig  you can simply   var schema   new DbSchema ConnectionString  DbPlatform SqlServer2014   schema Alter db   gt  db CreateTable  Customer         WithPrimaryKeyColumn  Id   DbType Int32  AsIdentity         WithNotNullableColumn  First Name   DbType String  OfSize 50        WithNotNullableColumn  Last Name   DbType String  OfSize 50               If you are not sure if it already exists  call DropIfExists before   db Tables  Customers   DropIfExists

User · Answer

Try this     Check if table have there   and drop the table   then create    using  SqlCommand command   new SqlCommand  IF EXISTS   SELECT   FROM sys tables WHERE name LIKE   Customer    DROP TABLE  Customer CREATE TABLE Customer First Name char 50  Last Name char 50  Address char 50  City char 50  Country char 25  Birth Date datetime     con

User · Answer

Try this   protected void Button1 Click object sender  EventArgs e        SqlConnection cn   new SqlConnection  Data Source  LocalDB   v11 0 AttachDbFilename  DataDirectory   Database mdf Integrated Security True        try               cn Open            SqlCommand cmd   new SqlCommand  create table Employee  empno int empname varchar 50  salary money     cn           cmd ExecuteNonQuery            lblAlert Text    SucessFully Connected           cn Close              catch  Exception eq                lblAlert Text   eq ToString

User · Answer

using System  using System Data  using System Data SqlClient   namespace SqlCommend       class sqlcreateapp               static void Main string   args                        try                               SqlConnection conn   new SqlConnection  Data source USER-PC  Database Emp123 User Id sa Password sa123                    SqlCommand cmd   new SqlCommand  create table  lt Table Name gt  empno int empname varchar 50  salary money     conn                   conn Open                    cmd ExecuteNonQuery                    Console WriteLine  Table Created Successfully                       conn Close                              catch Exception e                                Console WriteLine  exception occured while creating table     e Message     t    e GetType                               Console ReadKey

User · Answer

You haven t mentioned the Initial catalog name in the connection string  Give your database name as Initial Catalog name    lt add name   AutoRepairSqlProvider  connectionString        Data Source   SQLEXPRESS  Initial Catalog MyDatabase  AttachDbFilename  DataDirectory  AutoRepairDatabase mdf       Integrated Security True User Instance True   gt

User · Answer

First  check whether the table exists or not  Accordingly  create table if doesn t exist   var commandStr   If not exists  select name from sysobjects where name    Customer   CREATE TABLE Customer First Name char 50  Last Name char 50  Address char 50  City char 50  Country char 25  Birth Date datetime     using  SqlCommand command   new SqlCommand commandStr  con   command ExecuteNonQuery

User · Answer

For managing DataBase Objects in SQL Server i would suggest using Server Management Objects

[c#] C# - Create SQL Server table programmatically

Examples related to c#

Examples related to .net

Examples related to sql-server

Examples related to create-table