如何在asp.net中使用c＃在数据库中上传图像 [英] How to upload Image in Database using c# in asp.net
问题描述
ASPX代码：
图像未上传到数据库中。请帮助。
ASPX Code :
Image is not getting uploaded in Database. Please Help.
<asp:Content ID="Content1" ContentPlaceHolderID="body" runat="server">
<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
<h1 class="page-header">Testimonials</h1>
<div class="table-responsive">
<div class="mysidebar-ele">
<dx:ASPxLabel ID="ASPxLabel1" runat="server" Text="Name"></dx:ASPxLabel>
</div>
<div class="mysidebar-ele">
<dx:ASPxTextBox ID="txt_Name" runat="server" Width="170px"></dx:ASPxTextBox>
</div>
<div class="mysidebar-ele">
<dx:ASPxLabel ID="ASPxLabel2" runat="server" Text="City"></dx:ASPxLabel>
</div>
<div class="mysidebar-ele">
<asp:DropDownList ID="ddl_City" Width="20%" DataSourceID="DS_City" CssClass="form-control" DataTextField="CityName"
DataValueField="CityId" AutoPostBack="true" runat="server" ToolTip="City" Font-Size="10" AppendDataBoundItems="true"/>
<asp:SqlDataSource ID="DS_City" runat="server" ConnectionString="<%$ ConnectionStrings:dbconn %>" SelectCommand="sp_city" SelectCommandType="StoredProcedure" />
</div>
<div class="mysidebar-ele">
<dx:ASPxLabel ID="ASPxLabel3" runat="server" Text="Deal_Details"></dx:ASPxLabel>
</div>
<div class="mysidebar-ele">
<dx:ASPxTextBox ID="txt_DealDetails" runat="server" Width="170px"></dx:ASPxTextBox>
</div>
<div class="mysidebar-ele">
<dx:ASPxLabel ID="ASPxLabel4" runat="server" Text="Comments"></dx:ASPxLabel>
</div>
<div class="mysidebar-ele">
<textarea style="width:350px; height:100px;" placeholder="Enter Comment" runat="server" id="txt_comments"></textarea>
</div>
<%-- <div class="mysidebar-ele">
<dx:ASPxLabel ID="ASPxLabel5" runat="server" Text="Upload Photo"></dx:ASPxLabel>
</div>--%>
<div class="mysidebar-ele">
<dx:ASPxUploadControl ID="ASPxUploadControl1" runat="server" UploadMode="Auto" Width="280px"
ShowProgressPanel="true" ShowUploadButton="true" >
<ValidationSettings MaxFileSize="4194304" AllowedFileExtensions=".jpg,.jpeg,.gif,.png" /></dx:ASPxUploadControl>
</div>
<div style="text-align:center">
<div class="mysidebar-ele">
<dx:ASPxButton ID="ASPxButton1" runat="server" Text="Add" OnClick="ASPxButton1_Click"></dx:ASPxButton>
</div>
<p>
<asp:Label ID="lbl_result" runat="server" Text=""></asp:Label>
</p>
</div>
</div>
</div>
</asp:Content>
C＃（ BackEnd Code）：
protected void ASPxButton1_Click（object sender，EventArgs e）
{
if（！IsPostBack == false）
{
if（string.IsNullOrEmpty（txt_Name.Text））
{
lbl_result.Text =姓名要求!!;
返回;
}
if（string.IsNullOrEmpty（txt_DealDetails.Text））
{
lbl_result.Text =Deal需要详细信息!!;
返回;
}
if（string.IsNullOrEmpty（txt_comments.Value） ））
{
lbl_result.Text =需要评论!!;
返回;
}
// protected void UploadTest（）
// {
//字符串filePath = Server.MapPath（〜/ Broc hures /+ UploadTest.FileName）;
//UploadTest.SaveAs(filePath）;
//}
// if（string.IsNullOrEmpty（ASPxUploadControl1。））
// {
// lbl_result.Text =需要注释!!;
//返回;
//}
string cons = WebConfigurationManager.ConnectionStrings [dbconn]。ToString（）;
SqlConnection conn = new SqlConnection（cons）;
conn.Open（）;
SqlCommand cmd = new SqlCommand（sp_add_testimonials，conn）;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue（@ state，0）;
cmd.Parameters.AddWithValue（@ Name，txt_Name.Value）;
cmd.Parameters.AddWithValue（@ City，ddl_City.ToString（））;
cmd.Parameters.AddWithValue（@ Deal_Details， txt_DealDetails.Value）;
cmd.Parameters.AddWithValue（@ Comments，txt_comments.Value）;
cmd.Parameters.AddWithValue（@ photo，ASPxUploadControl1。 SaveAs（../../ images / .jpg））;
cmd.ExecuteNonQuery（）;
conn.Close（）;
}
}
C# (BackEnd Code) :
protected void ASPxButton1_Click(object sender, EventArgs e)
{
if (!IsPostBack == false)
{
if (string.IsNullOrEmpty(txt_Name.Text))
{
lbl_result.Text = "Name Required !!";
return;
}
if (string.IsNullOrEmpty(txt_DealDetails.Text))
{
lbl_result.Text = "Deal Details Required !!";
return;
}
if (string.IsNullOrEmpty(txt_comments.Value))
{
lbl_result.Text = "Comment Required !!";
return;
}
//protected void UploadTest()
//{
//string filePath = Server.MapPath("~/Brochures/" + UploadTest.FileName);
//UploadTest.SaveAs(filePath);
//}
//if (string.IsNullOrEmpty(ASPxUploadControl1.))
//{
// lbl_result.Text = "Comment Required !!";
// return;
//}
string cons = WebConfigurationManager.ConnectionStrings["dbconn"].ToString();
SqlConnection conn = new SqlConnection(cons);
conn.Open();
SqlCommand cmd = new SqlCommand("sp_add_testimonials", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@state", "0");
cmd.Parameters.AddWithValue("@Name", txt_Name.Value);
cmd.Parameters.AddWithValue("@City", ddl_City.ToString());
cmd.Parameters.AddWithValue("@Deal_Details", txt_DealDetails.Value);
cmd.Parameters.AddWithValue("@Comments", txt_comments.Value);
cmd.Parameters.AddWithValue("@photo", ASPxUploadControl1.SaveAs("../../images/.jpg"));
cmd.ExecuteNonQuery();
conn.Close();
}
}
推荐答案
ConnectionStrings：dbconn ％> SelectCommand = sp_city SelectCommandType = StoredProcedure / >
< / div >
< div class = mysidebar-ele >
< dx：ASPxLabel ID = ASPxLabel3 runat = 服务器 文字 = Deal_Details > ; < / dx：ASPxLabel > ;
< / div >
< div class = mysidebar-ele >
< dx：ASPxTextBox ID = txt_DealDetails runat = server 宽度 = < span class =code-keyword> 170px > < / dx：ASPxTextBox >
< / div >
< div class = mysidebar-ele >
< dx：ASPxLabel ID =ASPxLabel4 runat = server 文字 = 评论 > < / dx：ASPxLabel >
< / div > ;
< div class = mysidebar-ele >
< textarea style = width：350px;高度：100px; 占位符 = 输入注释 runat = server id = txt_comments > < / textarea >
< / div >
<％ - < div 类 = mysidebar-ele >
< dx：ASPxLabel ID = ASPxLabel5 runat = server Text = 上传照片 > < / dx：ASPxLabel >
< / div > - ％>
< div < span class=\"code-attribute\">class=\"mysidebar-ele\">
<dx: ASPxUploadControl ID=\" ASPxUploadControl1\" runat=\"server\" UploadMode=\"Auto\" Width=\"280px\"
ShowProgressPanel=\"true\" ShowUploadButton=\"true\" >
<ValidationSettings MaxFileSize=\"4194304\"AllowedFileExtensions=\".jpg,.jpeg,.gif,.png\" /></dx:ASPxUploadControl>
</div>
<div style=\"text-align:center\">
<div class=\"mysidebar-ele\">
<dx:ASPxButton ID=\"ASPxButton1\" runat=\"server\" Text=\"Add\" OnClick=\"ASPxButton1_Click\"></d x:ASPxButton>
</div>
<p>
<asp:Label ID=\"lbl_result\" runat=\"server\" Text=\"\"></asp:Label>
</p>
</div>
</div>
</div>
</asp:Content>
ConnectionStrings:dbconn %>" SelectCommand="sp_city" SelectCommandType="StoredProcedure" /> </div> <div class="mysidebar-ele"> <dx:ASPxLabel ID="ASPxLabel3" runat="server" Text="Deal_Details"></dx:ASPxLabel> </div> <div class="mysidebar-ele"> <dx:ASPxTextBox ID="txt_DealDetails" runat="server" Width="170px"></dx:ASPxTextBox> </div> <div class="mysidebar-ele"> <dx:ASPxLabel ID="ASPxLabel4" runat="server" Text="Comments"></dx:ASPxLabel> </div> <div class="mysidebar-ele"> <textarea style="width:350px; height:100px;" placeholder="Enter Comment" runat="server" id="txt_comments"></textarea> </div> <%-- <div class="mysidebar-ele"> <dx:ASPxLabel ID="ASPxLabel5" runat="server" Text="Upload Photo"></dx:ASPxLabel> </div>--%> <div class="mysidebar-ele"> <dx:ASPxUploadControl ID="ASPxUploadControl1" runat="server" UploadMode="Auto" Width="280px" ShowProgressPanel="true" ShowUploadButton="true" > <ValidationSettings MaxFileSize="4194304" AllowedFileExtensions=".jpg,.jpeg,.gif,.png" /></dx:ASPxUploadControl> </div> <div style="text-align:center"> <div class="mysidebar-ele"> <dx:ASPxButton ID="ASPxButton1" runat="server" Text="Add" OnClick="ASPxButton1_Click"></dx:ASPxButton> </div> <p> <asp:Label ID="lbl_result" runat="server" Text=""></asp:Label> </p> </div> </div> </div> </asp:Content>
C# (BackEnd Code) :
protected void ASPxButton1_Click(object sender, EventArgs e)
{
if (!IsPostBack == false)
{
if (string.IsNullOrEmpty(txt_Name.Text))
{
lbl_result.Text = \"Name Required !!\";
return;
}
if (string.IsNullOrEmpty(txt_DealDetails.Text))
{
lbl_result.Text = \"Deal Details Required !!\";
return;
}
if (string.IsNullOrEmpty(txt_comments.Value))
{
lbl_result.Text = \"Comment Required !!\";
return;
}
//protected void UploadTest()
//{
//string filePath = Server.MapPath(\"~/Broc hures/\" + UploadTest.FileName);
//UploadTest.SaveAs(filePath);
//}
//if (string.IsNullOrEmpty(ASPxUploadControl1.))
//{
// lbl_result.Text = \"Comment Required !!\";
// return;
//}
string cons = WebConfigurationManager.ConnectionStrings[\"dbconn\"].ToString();
SqlConnection conn = new SqlConnection(cons);
conn.Open();
SqlCommand cmd = new SqlCommand(\"sp_add_testimonials\", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(\"@state\", \"0\");
cmd.Parameters.AddWithValue(\"@Name\", txt_Name.Value);
cmd.Parameters.AddWithValue(\"@City\", ddl_City.ToString());
cmd.Parameters.AddWithValue(\"@Deal_Details\", txt_DealDetails.Value);
cmd.Parameters.AddWithValue(\"@Comments\", txt_comments.Value);
cmd.Parameters.AddWithValue(\"@photo\", ASPxUploadControl1.SaveAs(\"../../images/.jpg\"));
cmd.ExecuteNonQuery();
conn.Close();
}
}
C# (BackEnd Code) :
protected void ASPxButton1_Click(object sender, EventArgs e)
{
if (!IsPostBack == false)
{
if (string.IsNullOrEmpty(txt_Name.Text))
{
lbl_result.Text = "Name Required !!";
return;
}
if (string.IsNullOrEmpty(txt_DealDetails.Text))
{
lbl_result.Text = "Deal Details Required !!";
return;
}
if (string.IsNullOrEmpty(txt_comments.Value))
{
lbl_result.Text = "Comment Required !!";
return;
}
//protected void UploadTest()
//{
//string filePath = Server.MapPath("~/Brochures/" + UploadTest.FileName);
//UploadTest.SaveAs(filePath);
//}
//if (string.IsNullOrEmpty(ASPxUploadControl1.))
//{
// lbl_result.Text = "Comment Required !!";
// return;
//}
string cons = WebConfigurationManager.ConnectionStrings["dbconn"].ToString();
SqlConnection conn = new SqlConnection(cons);
conn.Open();
SqlCommand cmd = new SqlCommand("sp_add_testimonials", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@state", "0");
cmd.Parameters.AddWithValue("@Name", txt_Name.Value);
cmd.Parameters.AddWithValue("@City", ddl_City.ToString());
cmd.Parameters.AddWithValue("@Deal_Details", txt_DealDetails.Value);
cmd.Parameters.AddWithValue("@Comments", txt_comments.Value);
cmd.Parameters.AddWithValue("@photo", ASPxUploadControl1.SaveAs("../../images/.jpg"));
cmd.ExecuteNonQuery();
conn.Close();
}
}
please show the error you are getting. what is the data type of @photo in your stored procedure?
you have to convert that image into Byte Array before saving that complete image into database. there are so many examples. just search on Google like this one C# Save and Load Image from Database[^]
please show the error you are getting. what is the data type of @photo in your stored procedure?
you have to convert that image into Byte Array before saving that complete image into database. there are so many examples. just search on Google like this one C# Save and Load Image from Database[^]
Below are some links that will help you to find the best.
http://www.aspsnippets.com/Red/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx[^]
http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-images-to-database-using-Asp-Net-C -Sharp/[^]
http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]
Happy Codding!
Hope this helps.
Avadhesh
Below are some links that will help you to find the best.
http://www.aspsnippets.com/Red/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx[^]
http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-images-to-database-using-Asp-Net-C-Sharp/[^]
http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]
Happy Codding!
Hope this helps.
Avadhesh
这篇关于如何在asp.net中使用c＃在数据库中上传图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
