nvarchar将sql server 2008映像到水晶报告“ [英] nvarchar to image sql server 2008 to crystal report"

问题描述

大家好，



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屋！