SQL Writable Data
-
Help, I seem to have forgotten the code to write data from a page to SQL. I use C# The code is as follows: SqlCommand RegisterCMD = new SqlCommand("RegisterUser", Conn); RegisterCMD.CommandType = CommandType.StoredProcedure; RegisterCMD.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 25)); RegisterCMD.Parameters(FirstName.Text); The last line I need some help.... Illegal Operation Making Computer Software Talk
-
Help, I seem to have forgotten the code to write data from a page to SQL. I use C# The code is as follows: SqlCommand RegisterCMD = new SqlCommand("RegisterUser", Conn); RegisterCMD.CommandType = CommandType.StoredProcedure; RegisterCMD.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 25)); RegisterCMD.Parameters(FirstName.Text); The last line I need some help.... Illegal Operation Making Computer Software Talk
Well it depends on what your stored proc does - if it does an insert/update call registerCMD.ExecuteNonQuery(); If it return something you can either call registerCMD.ExecuteReader(); or use a SqlDataApabter