Upload Image to Database in Asp.net
Database
|
Column Name
|
Data Type
|
Allow Nulls
|
|
Id
|
int(set identity property=true)
|
No
|
|
Class
|
varchar(50)
|
Yes
|
|
Year
|
varchar(50)
|
Yes
|
|
Branch
|
varchar(150)
|
Yes
|
|
Roll
|
Varchar(150)
|
Yes
|
|
Image
|
Varchar(150)
|
Yes
|
Once table creation completed open visual studio and create new website. After that write the following code in your aspx page like this
<table class="main" cellpadding="10px" style="margin: 0 auto">
<colgroup>
<col width="25%" />
<col width="25%" />
<col width="25%" />
<col width="25%" />
</colgroup>
<tr>
<td colspan="4">
<asp:Label runat="server" ID="lblmsg" Text="" ForeColor="Red"></asp:Label>
</td>
</tr>
<tr>
<td align="left">Passing Year</td>
<td align="left"><asp:DropDownList runat="server" ID="ddlPYear">
<asp:ListItem Value="00">--Select--</asp:ListItem>
<asp:ListItem Value="2013">2013</asp:ListItem>
<asp:ListItem Value="2014">2014</asp:ListItem>
<asp:ListItem Value="2015">2015</asp:ListItem>
<asp:ListItem Value="2016">2016</asp:ListItem>
<asp:ListItem Value="2017">2017</asp:ListItem>
</asp:DropDownList></td>
<td align="left">Branch</td>
<td align="left"><asp:DropDownList runat="server" ID="ddlBranch">
<asp:ListItem Value="00">--Select Branch--</asp:ListItem>
<asp:ListItem Value="01">AYUSHI NTT CENTER, MEZA, ALLD</asp:ListItem>
<asp:ListItem Value="02">BDRB NTT COLLEGE, BANDA</asp:ListItem>
<asp:ListItem Value="03">Bharat School of Education, Chunar</asp:ListItem>
<asp:ListItem Value="04">BHARAT SCHOOL OF EDUCATION, MAU, CHITRAKOOT</asp:ListItem>
<asp:ListItem Value="05">BHARAT SCHOOL OF EDUCATION, MEZA ALLD</asp:ListItem>
<asp:ListItem Value="06">BHARAT SCHOOL OF EDUCATION. JARI ALLD</asp:ListItem>
<asp:ListItem Value="07">CAREER POINT COACHING, GHAZIPUR</asp:ListItem>
<asp:ListItem Value="08">GAUTAM BUDDHA NTT CENTER, GHAZIPUR</asp:ListItem>
<asp:ListItem Value="09">HI-GEN COMPUTER INSTITUTE, BELTHARA BALIA</asp:ListItem>
<asp:ListItem Value="10">Jai Maa Janaki, Saidpur, Ghazipur</asp:ListItem>
<asp:ListItem Value="11">LPRA Rashtriya NTT Center, Sikandra, Jaunpur</asp:ListItem>
<asp:ListItem Value="12">MAHAMAYA NATIONAL DEFENCE ACADEMY, GHAZIPUR</asp:ListItem>
<asp:ListItem Value="13">MCCI COACHING DHOTARI, GHAZIPUR</asp:ListItem>
<asp:ListItem Value="14">MCCI COACHING. FULLANPUR</asp:ListItem>
<asp:ListItem Value="15">NERMAL GYANODAY, RAM NAGAR, VARANASI (U.P.)</asp:ListItem>
<asp:ListItem Value="16">Prince Nur. Teacher Training, Pratapgarh</asp:ListItem>
<asp:ListItem Value="17">RB NTT CENTER, SANGULPUR, JAUNPUR</asp:ListItem>
<asp:ListItem Value="18">ROHAN TEACHER'S TRAINING, NAINI, ALLD</asp:ListItem>
<asp:ListItem Value="19">SAMAR BAHADUR NTT CENTER, JAUNPUR</asp:ListItem>
<asp:ListItem Value="20">SUNBEEM NTT CENTER, MAHUARI, NAINI</asp:ListItem>
<asp:ListItem Value="21">VAISANAVI SIKSHAN SANSTHAN, DLW, VARASANI</asp:ListItem>
<asp:ListItem Value="22">YASODA NTT CENTER, JAUNPUR (U.P.)</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td align="left">Class</td>
<td align="left"><asp:DropDownList runat="server" ID="ddlclass">
<asp:ListItem Value="00">--Select Class--</asp:ListItem>
<asp:ListItem Value="01">1st</asp:ListItem>
<asp:ListItem Value="02">2nd</asp:ListItem>
</asp:DropDownList></td>
<td align="left">Roll No</td>
<td align="left"><asp:TextBox runat="server" ID="txtRoll"></asp:TextBox></td>
</tr>
<tr>
<td align="left">Upload Image</td>
<td align="left"><asp:FileUpload runat="server" ID="fileuploadimages" /></td>
<td colspan="2">
<asp:Button runat="server" ID="btnsubmit" Text="Submit" CssClass="button_example"
onclick="btnsubmit_Click" />
</td>
</tr>
</table>
After completion of aspx page design add the following namespaces in code behind
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Drawing;
using System.Web.UI.HtmlControls;
using System.Collections;
using System.Text;
using System.Net;
using System.IO;
public partial class Admin_Upload : System.Web.UI.Page
{
//Your Connection String//
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CS"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
private void save()
{
try
{
if (fileuploadimages.HasFile)
{
string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
string extension = Path.GetExtension(fileuploadimages.PostedFile.FileName);
fileuploadimages.SaveAs(Server.MapPath("~/uploads/" + txtRoll.Text + extension));
// fileuploadimages.SaveAs(Server.MapPath("~/uploads/" + filename));
string img = "~/uploads/" + txtRoll.Text + extension;
DateTime dt = DateTime.Now;
DateTime dateOnly = dt.Date;
string date = dt.ToShortDateString();
con.Open();
SqlCommand cmd = new SqlCommand("insert into result values ('" + ddlclass.SelectedItem + "', '" + ddlPYear.SelectedValue + "', '" + ddlBranch.SelectedValue + "', '" + txtRoll.Text + "', '" + img + "')", con);
//SqlCommand cmd = new SqlCommand("insert into Result(Name,email,CollegeName,Address,url,comment, Edate,Status) values('" + txtname.Text + "','" + txtEmail.Text + "','" + txtCollege.Text + "','" + txtAdd.Text + "', '" + img.ToString() + "','" + FreeTextBox1.Text + "', '" + date + "', '0')", con);
cmd.ExecuteNonQuery();
lblmsg.Text = "Saved";
con.Close();
}
else
{
lblmsg.Text = "Please Select Image Of Result";
}
}
catch (Exception ex)
{
lblmsg.Text = "Error";
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
save();
ddlBranch.SelectedValue = "00";
ddlclass.SelectedValue = "00";
ddlPYear.SelectedValue = "00";
txtRoll.Text = "";
}
}
No comments:
Post a Comment