我想获取本地一图片 跟一些信息存入数据库
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;public partial class insert : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
System.Drawing.Image Img = System.Drawing.Image.FromFile(@"~/jytp.jpg");
FileStream fs = new FileStream(Img,FileMode.Open);
byte[] imagebyte = new byte[fs.Length];
BinaryReader Br = new BinaryReader(fs);
imagebyte = Br.ReadBytes(Convert.ToInt32(fs.Length)); SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=8325498;database=LPDataDB");
conn.Open;
SqlCommand cmd = new SqlCommand("insertinfo",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UU", SqlDbType.Int, 4);
cmd.Parameters.Add("@Nationality", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@QQ", SqlDbType.VarChar,20 );
cmd.Parameters.Add("@Phone", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Birth", SqlDbType.SmallDateTime,4);
cmd.Parameters.Add("@Constellation", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Characters", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Stature", SqlDbType.SmallInt,2);
cmd.Parameters.Add("@Body", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Marry", SqlDbType.Bit,1);
cmd.Parameters.Add("@SchoolAge", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Vocation", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Joss", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Hobby", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Email", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Reason", SqlDbType.VarChar,50);
cmd.Parameters.Add("@Nickname", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Gender", SqlDbType.Bit,1);
cmd.Parameters.Add("@Age", SqlDbType.SmallInt,2);
cmd.Parameters.Add("@City", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Proclamation", SqlDbType.VarChar,50);
SqlParameter Sqlpa = cmd.Parameters.Add("@Profile", SqlDbType.Image, 16);
cmd.Parameters.Add("@PassWord", SqlDbType.VarChar,50);
cmd.Parameters["@UU"].Value = 500002;
cmd.Parameters["@Nationality"].Value = 中国;
cmd.Parameters["@QQ"].Value = 370317869;
cmd.Parameters["@Phone"].Value = 022 - 28593293;
cmd.Parameters["@Birth"].Value = 1986 - 7 - 24;
cmd.Parameters["@Constellation"].Value = 黑牛座;
cmd.Parameters["@Characters"].Value = 活泼开朗;
cmd.Parameters["@Stature"].Value = 175;
cmd.Parameters["@Body"].Value = 苗条;
cmd.Parameters["@Marry"].Value = 1;
cmd.Parameters["@SchoolAge"].Value = 硕士;
cmd.Parameters["@Vocation"].Value = 计算机;
cmd.Parameters["@Joss"].Value = 毛泽东;
cmd.Parameters["@Hobby"].Value = 玩耍;
cmd.Parameters["@Email"].Value = 454465;
cmd.Parameters["@Reason"].Value = 向毛主席学习;
cmd.Parameters["@Nickname"].Value = 阿毛;
cmd.Parameters["@Gender"].Value = 1;
cmd.Parameters["@Age"].Value = 22;
cmd.Parameters["@City"].Value = 地心城; cmd.Parameters["@Proclamation"].Value = 所困定界符哭诉;
Sqlpa.Value = imagebyte;
cmd.Parameters["@PassWord"].Value = 500002;
}
}
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;public partial class insert : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
System.Drawing.Image Img = System.Drawing.Image.FromFile(@"~/jytp.jpg");
FileStream fs = new FileStream(Img,FileMode.Open);
byte[] imagebyte = new byte[fs.Length];
BinaryReader Br = new BinaryReader(fs);
imagebyte = Br.ReadBytes(Convert.ToInt32(fs.Length)); SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=8325498;database=LPDataDB");
conn.Open;
SqlCommand cmd = new SqlCommand("insertinfo",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UU", SqlDbType.Int, 4);
cmd.Parameters.Add("@Nationality", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@QQ", SqlDbType.VarChar,20 );
cmd.Parameters.Add("@Phone", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Birth", SqlDbType.SmallDateTime,4);
cmd.Parameters.Add("@Constellation", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Characters", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Stature", SqlDbType.SmallInt,2);
cmd.Parameters.Add("@Body", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Marry", SqlDbType.Bit,1);
cmd.Parameters.Add("@SchoolAge", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Vocation", SqlDbType.VarChar,10);
cmd.Parameters.Add("@Joss", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Hobby", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Email", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Reason", SqlDbType.VarChar,50);
cmd.Parameters.Add("@Nickname", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Gender", SqlDbType.Bit,1);
cmd.Parameters.Add("@Age", SqlDbType.SmallInt,2);
cmd.Parameters.Add("@City", SqlDbType.VarChar,20);
cmd.Parameters.Add("@Proclamation", SqlDbType.VarChar,50);
SqlParameter Sqlpa = cmd.Parameters.Add("@Profile", SqlDbType.Image, 16);
cmd.Parameters.Add("@PassWord", SqlDbType.VarChar,50);
cmd.Parameters["@UU"].Value = 500002;
cmd.Parameters["@Nationality"].Value = 中国;
cmd.Parameters["@QQ"].Value = 370317869;
cmd.Parameters["@Phone"].Value = 022 - 28593293;
cmd.Parameters["@Birth"].Value = 1986 - 7 - 24;
cmd.Parameters["@Constellation"].Value = 黑牛座;
cmd.Parameters["@Characters"].Value = 活泼开朗;
cmd.Parameters["@Stature"].Value = 175;
cmd.Parameters["@Body"].Value = 苗条;
cmd.Parameters["@Marry"].Value = 1;
cmd.Parameters["@SchoolAge"].Value = 硕士;
cmd.Parameters["@Vocation"].Value = 计算机;
cmd.Parameters["@Joss"].Value = 毛泽东;
cmd.Parameters["@Hobby"].Value = 玩耍;
cmd.Parameters["@Email"].Value = 454465;
cmd.Parameters["@Reason"].Value = 向毛主席学习;
cmd.Parameters["@Nickname"].Value = 阿毛;
cmd.Parameters["@Gender"].Value = 1;
cmd.Parameters["@Age"].Value = 22;
cmd.Parameters["@City"].Value = 地心城; cmd.Parameters["@Proclamation"].Value = 所困定界符哭诉;
Sqlpa.Value = imagebyte;
cmd.Parameters["@PassWord"].Value = 500002;
}
}
CREATE PROCEDURE [dbo].[insertinfo]
@UU int,
@Nationality varchar(20),
@QQ varchar(20),
@Phone varchar(20),
@Birth smalldatetime,
@Constellation varchar(10),
@Characters varchar(20),
@Stature smallint,
@Body varchar(20),
@Marry bit,
@SchoolAge varchar(10),
@Vocation varchar(10),
@Joss varchar(20),
@Hobby varchar(20),
@Email varchar(20),
@Reason varchar(50),
@Nickname varchar(20),
@Gender bit,
@Age smallint,
@City varchar(20),
@Proclamation varchar(50),
@Profile image,
@PassWord varchar(50)
AS
INSERT INTO MakeFriends (UU,Nationality,QQ,Phone,Birth,Constellation,Characters,Stature,Body,Marry,SchoolAge,Vocation,Joss,Hobby,Email,Reason,Nickname,Gender,Age,City,Proclamation,Profile,Password) values(@UU,@Nationality,@QQ,@Phone,@Birth,@Constellation,@Characters,@Stature,@Body,@Marry,@SchoolAge,@Vocation,@Joss,@Hobby,@Email,@Reason,@Nickname,@Gender,@Age,@City,@Proclamation,@Profile,@Password)
RETURN
GO
FileStream fs = new FileStream(Img,FileMode.Open);
这里出错
cmd.Parameters["@Nationality"].Value = "中国";
cmd.Parameters["@QQ"].Value = "370317869";
cmd.Parameters["@Phone"].Value = "022 - 28593293";
cmd.Parameters["@Birth"].Value = "1986 - 7 - 24";
cmd.Parameters["@Constellation"].Value = "黑牛座";
cmd.Parameters["@Characters"].Value = "活泼开朗";
cmd.Parameters["@Stature"].Value = "175";
cmd.Parameters["@Body"].Value = "苗条";
cmd.Parameters["@Marry"].Value = "1";
cmd.Parameters["@SchoolAge"].Value = "硕士";
cmd.Parameters["@Vocation"].Value = "计算机";
cmd.Parameters["@Joss"].Value = "毛泽东";
cmd.Parameters["@Hobby"].Value = "玩耍";
cmd.Parameters["@Email"].Value = "454465";
cmd.Parameters["@Reason"].Value = "向毛主席学习";
cmd.Parameters["@Nickname"].Value = "阿毛";
cmd.Parameters["@Gender"].Value = "1";
cmd.Parameters["@Age"].Value = "22";
cmd.Parameters["@City"].Value = "地心城"; cmd.Parameters["@Proclamation"].Value = "所困定界符哭诉";
Sqlpa.Value = imagebyte;
cmd.Parameters["@PassWord"].Value = "500002";
少了个括号。。
cmd.Parameters.Add("@Proclamation", SqlDbType.Image,50);
应该是image或者Binary
FileStream fs = new FileStream(@"~/jytp.jpg",FileMode.Open);
byte[] imagebyte = new byte[fs.Length];
BinaryReader Br = new BinaryReader(fs);
imagebyte = Br.ReadBytes(Convert.ToInt32(fs.Length));
cmd.ExecuteNonQuery();
conn.Close();
?
还有我存的时候出错了
"将参数值从 String 转换到 Boolean 失败。"
....顺便问下SQL2000的存储过程 如何执行 算是生成成功呢?