1.

How Do U Call And Execute A Stored Procedure In .net?

Answer»
  1. system.Data;
  2. system.Data.SqlClient;
  3. SQLCONNECTION sqCon = NEW SqlConnection(?CONNECTION STRING);
  4. SQLCOMMAND sqCmd = new SqCmd();
  5. sqCmd.Connection = sqCon;
  6. sqCmd.CommandText = procedure_name;
  7. sqCmd.CommandType = CommandType.StoredProcedure;
  8. sqComd.ExecuteReader(); 


Discussion

No Comment Found

Related InterviewSolutions