Hi!
I love to put the whole code. But when running I receive this message
The name "Images1" does not exist in the current contextusing System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.ComponentModel;
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.IO;
public partial class Default2 : System.Web.UI.Page
{
public string GetConnectionString()
{
//we will set up the configuration which will call our
//web.config file to provide the database details because
//in configuration file we have created the <connectionStrings>
//in the process we draged and droped. It creates automatically.
//We normally put the database details in web.config file or
//machine.config file because it is very sensitive information
//usually there IP address of remote database, passwords and
//user names are stored.
return System.Configuration.ConfigurationManager.ConnectionStrings
["onlineapplicationformConnectionString1"].ConnectionString;
//in above line "onlineapplicationformConnectionString1" is
//our configuration name which is inside the web.config file.
}
//private void execution(string fname, string lname, string dob, string gender, string fathername, string contact, string address)
private void execution(string fname, string lname, string dob, string gender, string fathername, string contact, string address, byte[] photo)
{
//In above line we declaring different variables same as backend
SqlConnection conn = new SqlConnection(GetConnectionString());
//In above line we are calling connection
//string function which is defined already on top
string sql = "INSERT INTO onlineapplication (fname, lname, dob, gender, fathername, contact, address, photo) VALUES "
//+ " (@fname, @lname, @dob, @gender, @fathername, @contact, @address)";
+" (@fname, @lname, @dob, @gender, @fathername, @contact, @address, @photo)";
//In above lines we are just storing the sql commands which
//will insert value in onlineapplication named table,
//using variable named sql.
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
//In above lines we are opening the connection to work and
//also storing connection name and sql command in cmd variable
//which has 'SqlCommand' type.
SqlParameter[] pram = new SqlParameter[8];
//In above lines we are defining 7 sql parameters will be use
//In below lines we will not disscuss about id column
pram[0] = new SqlParameter("@fname", SqlDbType.VarChar, 50);
pram[1] = new SqlParameter("@lname", SqlDbType.VarChar, 50);
pram[2] = new SqlParameter("@dob", SqlDbType.VarChar, 50);
pram[3] = new SqlParameter("@gender", SqlDbType.Char, 10);
pram[4] = new SqlParameter("@fathername", SqlDbType.VarChar, 50);
pram[5] = new SqlParameter("@contact", SqlDbType.Int, 20);
pram[6] = new SqlParameter("@address", SqlDbType.VarChar, 100);
pram[7] = new SqlParameter("@photo", SqlDbType.Image, 100);
//Now we set-uped all fiels in database in above lines
//Now we will set-up form fields
pram[0].Value = fname;
pram[1].Value = lname;
pram[2].Value = dob;
pram[3].Value = gender;
pram[4].Value = fathername;
pram[5].Value = contact;
pram[6].Value = address;
pram[7].Value = photo;
//Now create loop to insert
for (int i = 0; i < pram.Length; i++)
{
cmd.Parameters.Add(pram[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch(System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//the problem it's here
Images1(); }
}
protected void Image()
{
DirectoryInfo dir = new DirectoryInfo(MapPath("Images"));
FileInfo[] files = dir.GetFiles();
ArrayList listItems = new ArrayList();
foreach (FileInfo info in files)
{
listItems.Add(info);
}
//dtlist.DataSource = listItems;
Image1.DataBind();
//dtlist.DataBind();
}
protected void submit_Click(object sender, EventArgs e)
{
//Here is the command inside the click event of button
if(fname.Text=="")
{
Response.Write("Please complete the form.");
}
else
{
int length = FileUpload1.PostedFile.ContentLength;
//create a byte array to store the binary image data
byte[] imgbyte = new byte[length];
//store the currently selected file memory
HttpPostedFile img = FileUpload1.PostedFile;
//set the binary data
img.InputStream.Read(imgbyte, 0, length);
//execution(fname.Text,lname.Text,dob.Text,gender.Text,fathername.Text,contact.Text,address.Text);
execution(fname.Text, lname.Text, dob.Text, gender.Text, fathername.Text, contact.Text, address.Text, imgbyte);
conform.Visible = true;
fname.Text="";
lname.Text="";
dob.Text="";
gender.Text="";
gender.Text="";
fathername.Text="";
contact.Text="";
address.Text="";
}
}
}
//////////////////////////////////////
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Simple Application Form in ASP.Net</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div>
<strong><span style="font-size: 14pt; color: #0000ff">Simple Application Form In ASP.Net</span></strong><br />
<br />
<br />
<br />
<table>
<tr>
<td style="width: 123px">
First Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="fname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Last Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="lname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Date of Birth</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="dob" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Gender</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="gender" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Father's Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="fathername" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Contact Number</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="contact" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Address</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="address" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Select Photo</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:FileUpload ID="FileUpload1" runat="server"/></td>
</tr>
<tr>
<td style="width: 123px; height: 21px">
</td>
<td style="width: 63px; height: 21px">
</td>
<td style="width: 193px; height: 21px">
<asp:Label ID="conform" runat="server" Text="Submitted, thank you !" Visible="False"
Width="152px"></asp:Label></td>
</tr>
</table>
<td style="width: 153px" >
<div>
<asp:Image Width="100" ID="Image1" ImageUrl='<%# Bind("Name", "~/SimpleApplicationFormInAsp/{0}") %>' runat="server" />
<br />
</div>
<tr>
<td style="width: 123px">
</td>
<td style="width: 63px; text-align: center">
</td>
<td style="width: 193px">
<asp:Button ID="submit" runat="server" Text="Submit" OnClick="submit_Click" /></td>
</tr>
</div>
<br />
<br />
<strong><span style="text-decoration: underline">Database Details</span></strong><br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:BoundField DataField="fname" HeaderText="fname" SortExpression="fname" />
<asp:BoundField DataField="lname" HeaderText="lname" SortExpression="lname" />
<asp:BoundField DataField="dob" HeaderText="dob" SortExpression="dob" />
<asp:BoundField DataField="gender" HeaderText="gender" SortExpression="gender" />
<asp:BoundField DataField="fathername" HeaderText="fathername" SortExpression="fathername" />
<asp:BoundField DataField="contact" HeaderText="contact" SortExpression="contact" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
<asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:onlineapplicationformConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:onlineapplicationformConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [fname], [lname], [dob], [gender], [fathername], [contact], [address], [photo] FROM [onlineapplication]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>