نوشته شده توسط
hakelberfin
سلام
کد رو به این صورت اصلاح کنید
ALTER PROCEDURE dbo.checkpicnull
(
@edit nchar(20),
@flag3 int OUTPUT
)
AS
SET NOCOUNT ON;
DECLARE pic1 IMAGE
select pic1=pic from users where iduser = @edit
IF (@@ROWCOUNT <> 0)
IF (pic1 IS NULL )
begin
set @flag3 = 1
end
من از کد زیر برای فراخوانیش استفاده میکنم اشتباهه؟
SqlCommand cmd = newSqlCommand();
cmd.CommandText = "dbo.checkpicnull";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@edit", edit);
cmd.Parameters.AddWithValue("@flag3", flag3);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
if (flag3==1)
{
byte[] imageData = (byte[])dataGridView1.CurrentRow.Cells[4].Value;
//Initialize image variable
Image newImage;
//Read image data into a memory stream
using (MemoryStream ms = newMemoryStream(imageData, 0, imageData.Length))
{
ms.Write(imageData, 0, imageData.Length);
//Set image variable value using memory stream.
newImage = Image.FromStream(ms, true);
}
//set picture
pictureBox1.Image = newImage;
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;