title: Creating SQL Server Table in C#
body: <p>I am trying to create in asp.net using c# but i am getting syntax error here is the my code</p>
  
  <pre><code>string connectionstring = "server=AMAN;database=student;Integrated Security=True";
          string table = "CREATE TABLE IF NOT EXISTS details( Admission_no  char(50),First_Name char(50),Father_name char(50),recepit_no char(50),selectdate  datetime,acedemic_year char(50),class1 char(50),section char(50), roll_no char(50);";
           string fee_table = "CREATE TABLE IF NOT EXISTS fees(Admission_no char(50),  prospectues_fee float, registration_fee float,admission_fee float,security_money float,misslaneous_fee float,development_fee float,transport_fair float,computer_fee float,activity float,hostel_fee float,dely_fine float,back_dues float,tution_fee float,other_fee float,total float;";             
          SqlConnection conn = new SqlConnection(connectionstring);
          SqlCommand cmd;
          SqlCommand command;
          try
          {
              conn.Open();
  
              using (command = new SqlCommand(table, conn)) ;
              using ( cmd = new SqlCommand(fee_table, conn)) ;
              command.ExecuteNonQuery();
              cmd.ExecuteNonQuery();
              MessageBox.Show("connection open");
  
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.ToString());
          }
  
      }
  </code></pre>
  
  <p>i am getting exception syantax error near the if</p>
  
  <p>here is error message </p>