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
Ïà¹ØÎĵµ£º
½ñÌì¿ÉÒÔ»»»»ÄÔ×ÓÁË£¬¶ªµôeclipse£¬ÍæÍæsqlÁË£¬ËäȻֻÊÇÔÚÃüÁîÐд°¿Ú
ÏÈ˵һϽñÌìÎÒÓöµ½µÄÎÊÌâ°É£¬¿ªÊ¼°´ÕÕÀÏʦµÄ²¿Êð£¬×öµÄ¶¼ºÜ˳Àû£¬µ«Êǵ±½¨Á¢ºÃÊý¾Ý¿âÖ®ºó£¬½¨Á¢±í½á¹¹µÄʱºò¾Í³ö´íÁË£¬ÔÒòÊÇÔÚÅäÖÃmysqlµÄʱºò£¬È¨ÏÞÅäÖôíÁË£¬ËùÒÔ˵ǧÀïÖ®µÌ»ÙÓÚÒÏѨ£¬º¦µÄÎÒÕûÁËÒ»¸öÖÐÎ磬ÕâʱÌáʾµÄ´íÎóÊÇERROR 1005: Can't creat ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......
½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêÈ«Ö§³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐÍ°²È«¡ ......
{
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();
}
......