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;
public partial class admin_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=ZENGDAN;database=tushu; user id=sa;pwd=111");
conn.Open();
string selectstr = " SELECT COUNT(*) FROM BookInfo WHERE (BookName = @dname)";//OR (PublishingHouse =@dpublish) OR (Author =@dauthor) OR (Translator =@dtranslator) OR (ISBN =@disbn) OR (PublishDate =@dpublishdate) OR (Price =@dprice) OR (Description =@ddescription) OR (suoyinhao =@dsuoyinhao)";
SqlCommand cmd1 = new SqlCommand(selectstr, conn);
cmd1.Parameters.Add("@dname", SqlDbType.VarChar, 80).Value = TextBox1.Text.ToString();
SqlDataReader dr = cmd1.ExecuteReader();
if (dr.Read())
{
if ((int)dr.GetValue(0) > 0)
{
Response.Write("<script>alert(\"图书类型名已经存在\")</script>");
}
else
{
dr.Close();
conn.Close();
string Sqlstring = "Insert into BookInfo(BookName,PublishingHouse,Author,Translator,ISBN,PublishDate,Price,Description,suoyinhao,booktype)values(@dname,@dpublish,@dauthor,@dtranslator,@disbn,@dpublishdate,@dprice,@ddescription,@dsuoyinhao,@dbooktype)";
conn.Open();
SqlCommand cmd = new SqlCommand(Sqlstring, conn);
cmd.Parameters.Add("@dname", SqlDbType.VarChar, 80).Value = TextBox1.Text.ToString();
cmd.Parameters.Add("@dpublish", SqlDbType.VarChar, 80).Value = TextBox9.Text.ToString();
cmd.Parameters.Add("@dauthor", SqlDbType.VarChar, 80).Value = TextBox3.Text.ToString();
cmd.Parameters.Add("@dtranslator", SqlDbType.VarChar, 80).Value = TextBox7.Text.ToString();
cmd.Parameters.Add("@disbn", SqlDbType.VarChar, 80).Value = TextBox4.Text.ToString();
cmd.Parameters.Add("@dpublishdate", SqlDbType.VarChar,80).Value = TextBox8.Text.ToString();
cmd.Parameters.Add("@dprice", SqlDbType.VarChar, 80).Value = TextBox5.Text.ToString();
cmd.Parameters.Add("@ddescription", SqlDbType.Text, 16).Value = TextBox10.Text.ToString();
//cmd.Parameters.Add("@dcover", SqlDbType.VarChar, 50).Value = TextBox2.Text.ToString();
cmd.Parameters.Add("@dbooktype", SqlDbType.Int, 4).Value = Convert.ToInt32(DropDownList1.SelectedValue);
cmd.Parameters.Add("@dsuoyinhao", SqlDbType.VarChar,80).Value = TextBox6.Text.ToString();
cmd.ExecuteNonQuery();
Response.Write("<script>alert(\"添加成功\")</script>");
conn.Close();
Response.Write("<br><br><meta http-equiv='refresh' content='1;url=booklitterset.aspx'><br>");
//Response.Redirect("booklitterset.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
int a = 1;
bool fileOK = false;
string path = Server.MapPath("~/admin/upload/");
if (FileUpload1.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
string[] allowedExtension ={ ".bmp", ".pcx", ".png", ".tiff", ".dxf", ".cgm", ".cdr", ".wmf", ".eps", ".jpeg", ".gif", ".jpg" };
for (int i = 0; i < allowedExtension.Length; i++)
{
if (fileExtension == allowedExtension[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
// string a="~/admin/upload/";
try
{
FileUpload1.SaveAs(path + FileUpload1.FileName);
Label1.Text = path + FileUpload1.FileName;
a = 2;
}
catch (Exception ex)
{
// Label4.Text = "文件上传不成功!";
//Response.Write("<script>alert(\"文件名称和描述不能为空!\")</script>");
}
}
else
{
Response.Write("<script>alert(\"只能够上传图片文件!!\")</script>");
}
try
{
if (a != 1)
{
SqlConnection conn1 = new SqlConnection("server=ZENGDAN;database=tushu; user id=sa;pwd=111");
conn1.Open();
string insertstr = "insert into image(image) " + "values ('" + this.Label1.Text.ToString() + "')";
// string insertstr = "insert into login (useName,password) values ('" + nameTxt.Text.ToString() + "','" + a.ToString() + "')";
SqlCommand cmd1 = new SqlCommand(insertstr, conn1);
cmd1.ExecuteNonQuery();
Response.Write("<script>alert(\"插入成功\")</script>");
conn1.Close();
}
else
{
Response.Write("<script>alert(\"插入失败!\")</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert(\"文件上传不成功!!!文件名相同,请修改图片名称!\")</script>");
//Response.Write("<script>alert(\"文件名称和描述不能为空!\")</script>");
}
}
}
怎么把要上传的图片用 Image1 显示出来 并把它保存到数据库去
我这段代码的结果是其它信息都保存进去数据库了
但是图片 cover 数据类型是 image 这项是空
请各位高手给点意见