调用存储过程代码,C代码库,德仔网

代码语言

代码分类

【C】调用存储过程

作者:郭剑锋 / 发布于2013/6/20/ 722


	using namespace System;
	using namespace System::Data;
	using namespace System::Data::SqlClient;

	void main()
	{
	 SqlConnection myConnection = nullptr;
	
	 try
	 {
	 myConnection = gcnew SqlConnection("Data Source=localhost;Database=UltraMax; UID=sa; PWD=");
	 myConnection->Open();
	
	 SqlCommand myCommand = gcnew SqlCommand("GetMusicByGenre",myConnection);
	 myCommand->CommandType = CommandType::StoredProcedure;
	
	 SqlCommandBuilder::DeriveParameters(myCommand);

	 for ( int i = 0; i < myCommand->Parameters->Count; i++ )
	 Console::WriteLine("Name={0}; Type={1}; Direction={2}",
	 myCommand->Parameters[i]->ParameterName,
	 myCommand->Parameters[i]->DbType,
	 myCommand->Parameters[i]->Direction);
	
	 myCommand->Parameters->Clear();
	 myCommand->Parameters->Add("@Genre", SqlDbType::Char);
	 myCommand->Parameters["@Genre"]->Value = "Classical";

	 SqlParameter returnValue = gcnew SqlParameter("RETURN_VALUE",SqlDbType::Int);
	 returnValue->Direction = ParameterDirection::ReturnValue;
	 myCommand->Parameters->Add(returnValue);
	
	 myCommand->ExecuteNonQuery();

	 Console::WriteLine("Count = {0}",myCommand->Parameters["RETURN_VALUE"]->Value);
	 }
	 catch(Exception e)
	 {
	 Console::WriteLine(e->Message);
	 }
	 finally
	 {
	 myConnection->Close();
	 }
	}

试试其它关键字

　调用存储过程　

同语言下

可能有用的

郭剑锋贡献的其它代码(14)