如何从数据库中检索照片这里是我的注册页面代码

问题描述

嘿，我想从数据库中检索照片，我存储了文件名，但图片保存在网站内的图片文件夹中



下面是我的注册页面代码我必须上传照片

protected void Button1_Click（对象发件人，EventArgs e）

{

int userid = 1;

string pathname =images /+ FileUpload1.PostedFile.FileName;

//字符串pathname = Path.GetFileName（FileUpload1.PostedFile.FileName）;

//FileUpload1.SaveAs(Server.MapPath(\"image/+ pathname））;

SqlCommand cmd = new SqlCommand（insertregister，con）;

cmd。 CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add（@ username，SqlDbType.VarChar，50）.Value = TextBox1.Text;

cmd.Parameters。添加（@ password，SqlDbType.VarChar，50）.Value = TextBox2.Text;

cmd.Parameters.Add（@ email，SqlDbType.VarChar，50）.Valu e = TextBox4.Text;

cmd.Parameters.Add（@ createdate，SqlDbType.DateTime）.Value = DateTime.Now;

cmd.Parameters.Add（ @images，SqlDbType.VarChar，50）.Value =（FileUpload1.PostedFile.FileName）;

cmd.Connection = con;

con.Open（）;

userid = Convert.ToInt32（cmd.ExecuteScalar（））;

cmd.ExecuteNonQuery（）;

cmd.Dispose（）;

con.Close（）;

FileUpload1.SaveAs（Server.MapPath（〜/ images /+ FileUpload1.PostedFile））;

//FileUpload1.SaveAs(Server.MapPath(\"image/\"+pathname））;

string message = string.Empty;

switch（userid）

{

case -1：

message =用户名已存在;

休息;

案例-2：

message =已使用电子邮件;

br eak;

默认：

message =注册seccussfully+ userid.ToString（）;

休息;

}

ClientScript.RegisterStartupScript（GetType（），alert，alert（'+ message +'）;，true）;

TextBox1.Text = string.Empty;

TextBox2.Text = string.Empty;

TextBox3.Text = string.Empty;

TextBox4.Text = string 。空;

TextBox1.Focus（）;



}





i使用了模板字段，然后是eval但没有显示照片

hey i want to retreive photo from database where i stored the filename but image is saved in images folder inside the website

below is my code for register page where i have to upload a photo
protected void Button1_Click(object sender, EventArgs e)
{
int userid=1 ;
string pathname = "images/" +FileUpload1.PostedFile.FileName;
//string pathname = Path.GetFileName(FileUpload1.PostedFile.FileName);
//FileUpload1.SaveAs(Server.MapPath("image/" + pathname));
SqlCommand cmd = new SqlCommand("insertregister",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = TextBox1.Text;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = TextBox2.Text;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = TextBox4.Text;
cmd.Parameters.Add("@createdate", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@images", SqlDbType.VarChar,50).Value = (FileUpload1.PostedFile.FileName);
cmd.Connection = con;
con.Open();
userid = Convert.ToInt32(cmd.ExecuteScalar());
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
FileUpload1.SaveAs(Server.MapPath("~/images/" + FileUpload1.PostedFile));
//FileUpload1.SaveAs(Server.MapPath("image/"+pathname));
string message = string.Empty;
switch (userid)
{
case -1:
message = "username already exist";
break;
case -2 :
message = "email already used";
break;
default:
message="registered seccussfully"+ userid.ToString();
break;
}
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
TextBox4.Text = string.Empty;
TextBox1.Focus();

}


i have used template field and then eval but not displaying photo

推荐答案

这篇关于如何从数据库中检索照片这里是我的注册页面代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！