Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

´«ÖDz¥¿Í—SQLÈëÃÅ

½ñÌì¿ÉÒÔ»»»»ÄÔ×ÓÁË£¬¶ªµôeclipse£¬ÍæÍæsqlÁË£¬ËäȻֻÊÇÔÚÃüÁîÐд°¿Ú
ÏÈ˵һϽñÌìÎÒÓöµ½µÄÎÊÌâ°É£¬¿ªÊ¼°´ÕÕÀÏʦµÄ²¿Êð£¬×öµÄ¶¼ºÜ˳Àû£¬µ«Êǵ±½¨Á¢ºÃÊý¾Ý¿âÖ®ºó£¬½¨Á¢±í½á¹¹µÄʱºò¾Í³ö´íÁË£¬Ô­ÒòÊÇÔÚÅäÖÃmysqlµÄʱºò£¬È¨ÏÞÅäÖôíÁË£¬ËùÒÔ˵ǧÀïÖ®µÌ»ÙÓÚÒÏѨ£¬º¦µÄÎÒÕûÁËÒ»¸öÖÐÎ磬ÕâʱÌáʾµÄ´íÎóÊÇERROR 1005: Can't creat ......

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨

Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£  
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......

ʹÓÃc#´´½¨sql serverµÄ´æ´¢¹ý³Ì_c#Ó¦ÓÃ1

½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêÈ«Ö§³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐÍ°²È«¡ ......

ʹÓÃ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();
}
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ