ʹÓÃc#´´½¨sql serverµÄ´æ´¢¹ý³Ì_c#Ó¦ÓÃ2
{
SqlConnection cnn = new SqlConnection
("context connection=true");
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select * from customers";
SqlDataReader reader = cmd.ExecuteReader();
SqlContext.Pipe.Send(reader);
reader.Close();
cnn.Close();
}
Õâ¸öGetAllCustomers()·½·¨ÓÃÁËÒ»¸ö[SqlProcedure]ÊôÐÔÀ´ÐÞÊΡ£ ÔÚ·½·¨ÄÚ´´½¨Ò»¸öSqlConnectionºÍÒ»¸öSqlCommand¶ÔÏó¡£ È»ºóʹÓÃExecuteReader()·½·¨À´Ö´ÐÐSELECTÓï¾ä¡£ ½ÓÏÂÀ´ÓÃSend()·½·¨½«È¡µÃµÄSqlDataReaderÊý¾Ý·¢Ë͵½¿Í»§¶Ë¡£ ×îºó¾ÍÊǹرÕSqlDataReaderºÍSqlConnection¡£ ÔÚÕâÖÖ·½·¨ÖУ¬ÊÇÎÒÃÇ×Ô¼º´´½¨µÄSqlDataReader¡£ Æäʵ£¬ÎÒÃÇÒ²Äܹ»°ÑÕâ¸öÈÎÎñ½»¸øSqlContextÀàÈ¥Íê³É£¬´úÂëÈçÏ£º
[SqlProcedure]
public static void GetCustomerByID
(SqlString CustomerID)
{
SqlConnection cnn = new SqlConnection
("context connection=true");
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select * from customers
where customerid=@p1";
SqlParameter p1 = new SqlParameter("@p1", CustomerID); °æȨÉêÃ÷£º±¾Õ¾ÎÄÕ¾ùÀ´×ÔÍøÂç.
cmd.Parameters.Add(p1);
SqlContext.Pipe.ExecuteAndSend(cmd);
cnn.Close();
}
GetCustomerByID()·½·¨ÐèÒªÒ»¸ö²ÎÊý – CustomerID£¬Ëû½«´ÓCustomers±íÖзµ»Øij¸öcustomerµÄ¼Ç¼¡£ Õâ¸ö·½·¨ÄڵĴúÂ룬³ýÁËExecuteAndSend()·½·¨Í⣬ÄúÓ¦¸Ã¶¼ÒѱȽÏÊìϤÁË¡£ ExecuteAndSend()·½·¨½ÓÊÕÒ»¸öSqlCommand¶ÔÏó×÷Ϊ²ÎÊý£¬Ö´ÐÐËû¾Í»á·µ»ØÊý¾Ý¼¯¸ø¿Í»§¶Ë¡£ .¡¡
ÓÐÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì
ÎÒÃÇÔÚʹÓô洢¹ý³Ìʱ£¬¾³£»áͨ¹ýÊä³ö²ÎÊý·µ»ØÒ»¸ö¾¹ý¼ÆËãµÄÖµ¡£ ËùÒÔ£¬ÏÖÔÚÈÃÎÒÃÇÀ´¿´Ò»¿´ÈçºÎ´´½¨¾ß±¸Ò»¸ö»ò¶à¸öÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì¡£
[SqlProcedure]
public static void GetCompanyName
(SqlString CustomerID,out SqlString CompanyName)
{
SqlConnection cnn = new SqlConnection
("context connection=true");
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select companyname from
customers where customerid=@p1";
SqlParameter p1 = new SqlParameter
("@p1", CustomerID);
cmd.Parameters.Add(p1);
object obj = cmd.ExecuteScalar();
cnn.Close();
CompanyName =
Ïà¹ØÎĵµ£º
VC2005ÖÐCÔËÐÐʱ¿âÑ¡Ôñ²»µ±µ¼ÖµÄÁ´½ÓÎÊÌâ¼°½â¾ö·½°¸
ÔÚMicrosoft Visual C++ 2005ÖУ¬Èç¹ûÒ»¸öEXEÖ÷¹¤³ÌÓ¦ÓóÌÐòҪʹÓÃÒ»¸ö»ò¼¸¸ö¾²Ì¬LIB¿â£¬ÄÇôÁ´½Óʱ¾³£»áÓöµ½·ûºÅÖظ´¶¨ÒåµÄ´íÎó£¬Èç¹ûÅųý¿â²»µ±ÓÖ»áÓöµ½ÕÒ²»µ½Ä³Ð©·ûºÅµÄÎÊÌ⣬Èç¹ûÇ¿ÖÆʹÓà /forceÑ¡ÏîÁ´½Ó¹ýÈ¥ÓÖ¿ÉÄÜ·¢ÉúһЩÒâÏë²»µ½µÄÔËÐÐʱÎÊÌâ¡£
  ......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
& ......
#include <unistd.h>
#include <fcntl.h>
#include
<sys/types.h>
#include <sys/ioctl.h>
#include
<stdlib.h>
#include <stdio.h>
#include
<linux/soundcard.h>
/* ÏÂÃæµÄÈý¸ö²ÎÊýÊǸú¾ßÌåÎļþÏà¹ØµÄ£¬ÎļþʲôÑù£¬¾ÍÒªÉèÖóÉʲôÑù */
#define RATE 11025&nbs ......
½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêÈ«Ö§³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐÍ°²È«¡ ......