C#ÖÐÓÃÓÚÁ¬½ÓSQLÊý¾Ý¿âµÄSQLHelperÀà
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient; //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
/*******************************************************************************
* Name: SQLHelper
* File: SQLHelper.cs
* Description: ÓÃÓÚÍê³É¶ÔÊý¾Ý¿âµÄÏà¹Ø²Ù×÷
* Author: Ñ©ÀÇ
* DateTime: 2010Äê05ÔÂ13ÈÕ
*******************************************************************************/
public class SQLHelper
{
//ÉèÖÃÁ¬½Ó×Ö·û´® —— SQL ServerÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
//public static string strConn = @"server = PANLING;database = StudentMIS;uid = sa;pwd = sa";
//ÉèÖÃÁ¬½Ó×Ö·û´® —— WindowsÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
public static string strConn = @"server = T403-004\HB_SQLSERVER;database = DB_LibraryManage;Integrated Security = SSPI";
/// <summary>
/// ¹¦ÄÜÃèÊö£ºÖ´ÐÐADO.NETÔö¡¢É¾¡¢¸Ä²Ù×÷
/// </summary>
/// <param name="strText">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾ä(ÃüÁîÎı¾)</param>
/// <param name="cmdType">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÃüÁîÀàÐÍ</param>
/// <param name="SqlParams">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾äÖеIJÎÊýÁбí(ÃüÁî²ÎÊýÁбí)</param>
/// <returns>·µ»ØÖ´ÐÐÓ°ÏìµÄÐÐÊý</returns>
public static int MyExecu
Ïà¹ØÎĵµ£º
1¡£ÆóÒµ¹ÜÀíÆ÷
´ò¿ªÄ㽨ÓÐÍâ¼üµÄ±í££ÓÒ»÷±í££Éè¼Æ±í££ÔÚÉÏ·½µã¿ª’¹ÜÀíÔ¼Êø‘££½«¼¶Á¬É¾³ýºÍ¼¶Á¬¸üÐµĹµ´òÉϾͿÉÒÔÁË
2¡£²éѯ·ÖÎöÆ÷
alter table sc
add
constraint forei ......
Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
ÓÐÖ´ÐÐsqlÌõ¼þÓï¾äwhere id in(@²ÎÊý)µÄʱºò£¬Èç¹û´¦Àí²»µ±£¬¾Í»á³öÏÖÎÊÌ⣺
ÈçÏÂÃæÕâ¸ö´æ´¢¹ý³Ì£º
alter proc Web_gettwtwgoldgameserverGoldSell
@ID int
as
declare @twgoldsellID nvarchar(1000)
select @twgoldsellID=twgoldsellID from twgoldgameserver where ID=@ID
set @twgoldsellID=replace(@twgoldsell ......
º¯ÊýÒÀÀµ
==========================================
Ò»¡¢º¯ÊýÒÀÀµ¸ÅÄî
¡¡¡¡º¯ÊýÒÀÀµÊÇ´ÓÊýѧ½Ç¶ÈÀ´¶¨ÒåµÄ£¬ÔÚ¹ØϵÖÐÓÃÀ´¿Ì»¹Øϵ¸÷ÊôÐÔÖ®¼äÏ໥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄÇé¿ö¡£º¯ÊýÒÀÀµÆÕ±é´æÔÚÓÚÏÖʵÉú»îÖУ¬±ÈÈ磬ÃèÊöÒ»¸öѧÉúµÄ¹Øϵ£¬¿ÉÒÔÓÐѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵµÈ¶à¸öÊôÐÔ£ ......