4
Answers

How to bind my picture on image

Divin Mfwamba

Divin Mfwamba

11y
1.1k
1

Hi!

I love to put the whole code. But when running I receive this message The name "Images1" does not exist in the current context

using 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>

Answers (4)