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

Image To SQL Server

/*
use master
go
if DB_ID('UserImage') is not null
   drop database UserImage
create database UserImage
go
use UserImage
go
create table Images
(
 Image_Name nvarchar(255) primary key,
 Image_Data Image not null
)
go
create proc InsertImage
(
 @Image_Name nvarchar(255),
 @Image_Data Image
)
as
insert into Images values(@Image_Name, @Image_Data)
go
create proc DeleteImage
(
 @Image_Name nvarchar(255)
)
as
delete from Images where Image_Name = @Image_Name
go
create proc SelectImage
(
 @Image_Name nvarchar(255)
)
as
select Image_Data from Images where Image_Name = @Image_Name
go
*/
using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
namespace ImageDB
{
    public partial class FormImageSQL : Form
    {
        #region
        private SqlConnection sql;
        private DataTable table;
        #endregion
        public FormImageSQL()
        {
            #region
            InitializeComponent();
            openFileImage.Filter = "ͼÏñÎļþ|*.bmp;*.gif;*.jpg;*.jpeg;*.png|ËùÓÐÎļþ|*.*";
            pictureBox1.SizeMode = PictureBoxSizeMode.Zoom; // ͼÏñ´óС°´ÆäÔ­ÓеĴóС±ÈÀý±»Ôö¼Ó»ò¼õС¡£
            table = new DataTable();
            DataColumn column = table.Columns.Add("Name", typeof(String));
      &nb


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL ÁÙʱ±íÓëÁÙʱ±äÁ¿±í

 
         ÔÚSQLServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£ÈçºÎÈ·¶¨Ê²Ã´Ê±ºòÓÃÁÙʱ±í£¬Ê²Ã´Ê±ºòÓñí±äÁ¿ÄØ£¿ÁÙʱ±íºÍ±í±äÁ¿¶¼ÓÐÌØ¶¨µÄÊÊÓû·¾³¡£
¡¡¡¡±í±äÁ¿
¡¡¡¡±äÁ¿¶ ......

SQLÖÐescapeµÄÖ÷ÒªÓÃ;

1.ʹÓà ESCAPE ¹Ø¼ü×Ö¶¨ÒåתÒå·û¡£ ÔÚģʽÖУ¬µ±×ªÒå·ûÖÃÓÚͨÅä·û֮ǰʱ£¬¸ÃͨÅä·û¾Í½âÊÍΪÆÕͨ×Ö·û¡£ÀýÈ磬ҪËÑË÷ÔÚÈÎÒâλÖðüº¬×Ö·û´® 5% µÄ×Ö·û´®£¬ÇëʹÓ㺠WHERE ColumnA LIKE '%5/%%' ESCAPE '/'
2.ESCAPE 'escape_character' ÔÊÐíÔÚ×Ö·û´®ÖÐËÑË÷ͨÅä·û¶ø²»Êǽ«Æä×÷ΪͨÅä·ûʹÓᣠescape_character ÊÇ·ÅÔÚͨÅä·ûǰ ......

SQL ÏÈɸѡÔÚ¹ØÁªµÄÀý×Ó

select ID,Item1,Item2,Item3,Item4
into #Temp
from (
select ID='200910',Item1='A',Item2='B',Item3='C',Item4='T1'
union all
select ID='200910',Item1='',Item2='B',Item3='C' ,Item4='G2'
union all
select ID='200910',Item1='A',Item2='D',Item3='C' ,Item4='T3'
union all
select ID='200910',Item ......

»ñÈ¡SQL Server·þÎñÆ÷ÁбíµÄ¼¸ÖÖ·½·¨

Ò»¡¢ SQL DMO ÃèÊö£ºSQL Distributed Management Objects£¨SQL·Ö²¼Ê½¹ÜÀí¶ÔÏ󣩣¬´æÔÚÓÚSQLDMO.dllÎļþÖУ¬Êµ¼ÊÉÏÊÇÒ»¸öCOM ¶ÔÏó£¬Í¨¹ýµ÷ÓÃSQL DMOµÄListAvailableSQLServers·½·¨È¡µÃ¡£ ÁбíÀàÐÍ£ºÁоÙ×°ÓС°¿Í»§¶Ë¡±ºÍ¡°·þÎñ¶Ë¡±µÄ¼ÆËã»ú¡£ ÊÊÓÃÌõ¼þ£º×°ÓÐ SQL Server£¬ÇÒÓÐSQLDMO.dllÎļþ¡£ ËÙ¶È£ºÖÐ µ÷ÓÃʾÀý£ºGetS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ