nvarchar将sql server 2008映像到水晶报告“ [英] nvarchar to image sql server 2008 to crystal report"
本文介绍了nvarchar将sql server 2008映像到水晶报告“的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
m sql转换新手,
i想转换
hi all,
m new to sql conversion ,
i want to convert
convert nvarchar to image sql server 2008
提前感谢
thanks in advance
推荐答案
using (MemoryStream ms = new MemoryStream(nvarchar, 0, nvarchar.Length))
{
ms.Write(nvarchar, 0, nvarchar.Length);
newImage = System.Drawing.Image.FromStream(ms, true);
}
试试这个代码
try this code
image is also binary bits in sql server. u dont need to convert
C#Corner:store-and-retrieve-image-on-crystal-report-from-sql-database [ ^ ]
不知道这是不是你真正想要的?
C# Corner : store-and-retrieve-image-on-crystal-report-from-sql-database[^]
Do not know if is this what you really wanted ??
不知道你为什么要这样做,但这是一种可以做到的方式。
只在MSSql服务器2012上测试但它应该适用于2008年
注意:来自谷歌翻译的文字:)(相应地更正)
Not sure why you would want to do it, but here is a way it can be done.
Only tested on MSSql server 2012 but it should work for 2008
note: text from google translate :) (correct accordingly)
declare @nvarchar nvarchar(max);
set @nvarchar = N'here is nvarchar text --- 這裡是nvarchar的文本 --- هنا هو النص nvarchar ---';
with nVarCharToImage as (
select convert(image,
convert(varbinary(max),@nvarchar)
) nVarCharImage
)
, ImageTonVarchar as(
select
convert(nvarchar(max),
convert(varbinary(max),nVarCharImage)
) ImgageTonVarChar from nVarCharToImage
)
select
(select nVarCharImage from nVarCharToImage) nVarCharImage,
(select ImgageTonVarChar from ImageTonVarchar) ImgageTonVarChar
;
如果只是转换varchar,你可以直接进行varchar到图像转换:
If just converting varchar, you can do a direct varchar to image conversion:
declare @varchar varchar(max);
set @varchar = 'here is varchar text';
with VarCharToImage as (
select convert(image, @varchar) VarCharImage
), ImageToVarchar as(
select convert(varchar(max), convert(varbinary(max),VarCharImage)) ImgageToVarChar from VarCharToImage
)
select
(select VarCharImage from VarCharToImage) VarCharImage,
(select ImgageToVarChar from ImageToVarchar) ImgageToVarChar
;
希望能帮到你。
Hope that helps you out.
这篇关于nvarchar将sql server 2008映像到水晶报告“的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文