sql server 2005 imageÊý¾ÝÀàÐ͵ÄʹÓÃ
×î½ü×öÒ»¸öÏîÄ¿µÄʱºòÐèÒªÍùÊý¾Ý¿âÄÚ²åÈëͼƬ£¬ÉÏÍø²éÁËһϣ¬Ö÷ÒªÓÐÁ½ÖÖ·½·¨£¬µÚÒ»¾ÍÊÇÔÚÊý¾Ý¿âÖд洢ͼƬµÄ·¾¶£¬È»ºóÔÚ³ÌÐòÖиù¾Ý¶ÁÈ¡µÄ·¾¶¶ÁȡͼƬ£»ÕâÖÖ·½·¨¼òµ¥¡¢ÈÝÒ×ʹÓ㬵«ÊÇÔÚͼƬ¹ý¶àʱ²»ºÃ¹ÜÀí¡£
µÚ¶þÖÖ¾ÍÊǽ«Í¼Æ¬×ª»»³É¶þ½øÖÆ´æ´¢ÓÚÊý¾Ý¿âÖУ¬sql server 2005ÓиöimageÊý¾ÝÀàÐÍ,רÃÅÓÃÓڴ洢ͼƬ£¬ImageÊý¾ÝÀàÐÍ´æ´¢µÄÊdz¤¶È²»È·¶¨µÄ¶þ½øÖÆÊý¾Ý£¬×î´ó³¤¶ÈÊÇ2GB¡£
µÚÒ»ÖÖ·½·¨ºÜ¼òµ¥£¬Ö÷ÒªÏëͨ¹ýÒ»¸öÀý×Ó˵һϵڶþÖÖ·½·¨¡£²½ÖèÈçÏÂ:
1.¿ª·¢»·¾³£ºvisual studio 2008 + sql server 2005 ÓïÑÔ£ºC#
2.ÔÚsql server 2005ÖÐн¨Ò»¸öÊý¾Ý¿â±í£¬ÎÒÕâÀïÓõÄÊÇÎÒ×Ô¼ºÏîÄ¿µÄ±í£¬Óï·¨ÈçÏ¡£
CREATE TABLE [dbo].[AdminInfo](
[AdminId] [nvarchar](15) NOT NULL,
[AdminName] [nchar](10) NOT NULL,
[Pas] [nvarchar](25) NOT NULL,
[Rights] [int] NOT NULL,
[Photo] [image] NULL)
×¢Òâphoto×Ö¶ÎÊÇimageÀàÐÍ¡£
3.ÕâÀïÖ÷Ҫͨ¹ýÒ»¸ö¼òµ¥¿ØÖÆ̨ӦÓóÌÐòÑÝʾ²åÈëºÍ¶ÁȡͼƬµÄ¹ý³Ì¡£ÍêÕû´úÂëÈçÏÂ:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data.SqlClient;
using System.Data;
namespace CSharp
{
class insertImage
{
public string sqlconnstr = "Data Source=XIANGZI-PC\\SQLEXPRESS;Initial Catalog=Library;Persist Security Info=True;User ID=xz;Password=comeon";//Êý¾Ý¿âÁ¬½Ó×Ö·û´®;
public void InsertIMG()//²åÈëͼƬ
{
FileStream fs = new FileStream(@"D:\c.jpg", FileMode.Open, FileAccess.Read);//¶ÁÈ¡DÅÌc.jpgת»»ÎªÊý¾ÝÁ÷
Byte[] btye2 = new byte[fs.Length];
fs.Read(btye2, 0, Convert.ToInt32(fs.Length));
&nb
Ïà¹ØÎĵµ£º
Ò»¡¢³õʼ°²×°ÇëÏÈ°²×°sqlserver 2000 ÔÙ°²×°sqlserver 2005
¶þ¡¢Èç¹ûÖÐ;sqlserver2000Óöµ½ÎÊÌâÐèÒªÖØ×°£¬Çë°´ÒÔϲ½Öè
1.ÔÚ¿ØÖÆÃæ°å->Ìí¼Óɾ³ý³ÌÐòÖÐɾ³ýsqlserver2000
2.ÔÚ¹ÜÀí¹¤¾ß->·þÎñÖÐÍ£Ö¹sqlserverµÄËùÓзþÎñ
3.ÊÖ¶¯É¾³ýC:\Program Files\Microsoft SQL ServerĿ¼ÏµÄ80Ŀ¼ºÍMSSQLĿ¼£¨±ØÐëÒªÓеڶþ² ......
c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;D ......
ÍâÁª½Ó:ÍâÁª½Ó¿ÉÒÔÊÇ×óÏòÍâÁª½Ó¡¢ÓÒÏòÍâÁª½Ó»òÍêÕûÍⲿÁª½Ó¡£
ÔÚ from ×Ó¾äÖÐÖ¸¶¨ÍâÁª½Óʱ£¬¿ÉÒÔÓÉÏÂÁм¸×é¹Ø¼ü×ÖÖеÄÒ»×éÖ¸¶¨£º
LEFT JOIN »ò LEFT OUTER JOIN;
×óÏòÍâÁª½ÓµÄ½á¹û¼¯°üÀ ......
½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......
ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
ÕâÒ»½ÚÔÛÃÇÀ´ËµËµClRµÄÐÔÄÜ£¬ÎÒÃDz»ÄÜֻʹÓÃËü¶ø²»È¥¿¼Âǵ½µÍ ΪʲôҪʹÓÃËü»òÊÇÔÚʲôʱºòÓ¦¸ÃʹÓÃËü£¬ÏñÎÒ֮ǰдµÄº¯ÊýµÃµ½Ò»¸ö×Ö·ûµÄ³¤¶ÈµÄ·½·¨¾ÍûÓÐÌ«´ó±ØÒªÁË£¬µ«Èç¹ûÊÇÏñ²ð·Ö×Ö·ûÕâÑùµÄ·½·¨Ó¦¸Ã¾ÍÓбØÒªÁË£¬±ÈÈçc#ÀïµÄSplit ......