sqlÁ¬½Ó´úÂë
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
namespace WebApplication1
{
public class Message
{
public static IList<MessageInfo> GetMessages()
{
IList<MessageInfo> msgs = new List<MessageInfo>();//×Ô¶¨ÒåÁôÑÔʵÌåµÄ¼¯ºÏ
//´ÓÅäÖÃÎļþÖлñÈ¡Á¬½Ó×Ö·û´®
string connstr = WebConfigurationManager.ConnectionStrings["GuestBookDBConnectionString"].ConnectionString;
//´´½¨Á¬½Ó¶ÔÏó
SqlConnection conn = new SqlConnection(connstr);
//´´½¨ÃüÁî¶ÔÏó
SqlCommand cmd = new SqlCommand("select * from MsgInfo", conn);
//´ò¿ªÊý¾Ý¿âÁ¬½Ó
conn.Open();
//Ö´ÐÐÃüÁî¶ÔÏóÖеÄsqlÃüÁ»ñÈ¡Êý¾Ý
//×¢ÒâdatareaderµÄÌØµã£¬Ö»¶Á£¬Ïòǰ£¬Ã¿´ÎÒ»Ìõ¼Ç¼¡£
SqlDataReader dr = cmd.ExecuteReader();
//Ñ»·¶ÁÈ¡Êý¾Ý¿â¼Ç¼£¬Ã¿´ÎÒ»ÐÐ
while (dr.Read())
{
 
Ïà¹ØÎĵµ£º
create table tabReProc
(
name varchar(30),
age integer,
primary key(name,age)
)
insert into tabReProc values('x7700',20)
insert into tabR ......
×öÒ»¸öϵͳµÄºǫ́£¬»ù±¾É϶¼ÉÙ²»ÁËÔöɾ¸Ä²é£¬×÷Ϊһ¸öÐÂÊÖÈëÃÅ£¬ÎÒÃDZØÐëÒªÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete£¡ ÏÂÃæ¶ÔÕâËĸöÓï¾ä½øÐÐÏêϸµÄÆÊÎö£º
¡¡¡¡ ÊìÁ·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽ ......
ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼
ÎÄÕÂÀ´×Ô£ºhttp://www.cnblogs.com/lindayyh/archive/2010/04/05/1704763.html
ÔÚÎÒÃÇ¿ª·¢ÉÌÎñÈí¼þµÄʱºò£¬³£³£»áÓöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣺ÔõÑù·ÀÖ¹Óû§Öظ´µÇ¼ÎÒÃǵÄϵͳ£¿ÌرðÊǶÔÓÚÒøÐлòÊDzÆÎñ²¿ÃÅ£¬¸üÊÇÒªÏÞÖÆÓû§ÒÔÆä¹¤ºÅÉí·Ý¶à´ÎµÇÈë¡£
¿ÉÄÜ»áÓÐÈË˵ÔÚÓû§ÐÅÏ¢±íÖмÓÒ»×Ö¶ÎÅÐ ......
/*********************************************************/
Ŀ¼Çåµ¥CONTEXT LIST
/*********************************************************/
1.Êý¾Ý¿âDataBase
1.1Êý¾Ý¿â½¨Á¢/ɾ³ýcreate/drop database
1.2Êý¾Ý¿â±¸·ÝÓë»Ö¸´backup/restore database
/***************************************************** ......
USE [master]
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
GO
USE [Database_Name]
&nb ......