How to insert data into SQL Server

Question

What the problem on my coding  I cannot insert data to ms sql   I m using C  as front end and MS SQL as databases     name   tbName Text  userId   tbStaffId Text  idDepart   int Parse cbDepart SelectedValue ToString      string saveStaff    INSERT into tbl staff  staffName userID idDepartment                           VALUES       name            userId           idDepart           SqlCommand querySaveStaff   new SqlCommand saveStaff    try   querySaveStaff ExecuteNonQuery      catch     Error when save data  MessageBox Show  Error to save on database    openCon Close    Cursor   Cursors Arrow

User · Answer

string saveStaff    INSERT into student  stud id stud name        VALUES       SI           SN          cmd   new SqlCommand saveStaff con   cmd ExecuteNonQuery

User · Answer

I think you lack to pass Connection object to your command object  and it is much better if you will use command and parameters for that   using  SqlConnection connection   new SqlConnection  ConnectionStringHere          using  SqlCommand command   new SqlCommand                  command Connection   connection                 lt    lacking         command CommandType   CommandType Text          command CommandText    INSERT into tbl staff  staffName  userID  idDepartment  VALUES   staffName   userID   idDepart            command Parameters AddWithValue   staffName   name           command Parameters AddWithValue   userID   userId           command Parameters AddWithValue   idDepart   idDepart            try                       connection Open                int recordsAffected   command ExecuteNonQuery                      catch SqlException                           error here                   finally                       connection Close

User · Answer

You have to set Connection property of Command object and use parametersized query instead of hardcoded SQL to avoid SQL Injection    using SqlConnection openCon new SqlConnection  your connection String                string saveStaff    INSERT into tbl staff  staffName userID idDepartment  VALUES   staffName  userID  idDepartment           using SqlCommand querySaveStaff   new SqlCommand saveStaff                     querySaveStaff Connection openCon           querySaveStaff Parameters Add   staffName  SqlDbType VarChar 30  Value name                          openCon Open              querySaveStaff ExecuteNonQuery

[c#] How to insert data into SQL Server

Examples related to c#

Examples related to sql

Examples related to sql-server