Wednesday, 8 October 2014

Image Insert & Upload Bind GridView Using Asp.Net C#

IMAGE UPLOAD & BIND GRIDVIEW



Image Upload  And  Bind The   Gridview  After Inserted  Images Using Asp.Net C#


Multiple Image Upload
Image Update in Gridview   
Show Image Preview
Restrict Upload File Size
Image Insert Bind  GridView
Without Database Upload Image Show
          
                              
                                               DEMO



   HTML Coding


<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Save Images In Folder and Display Images in Gridview from folder</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
    <table><tr><td class="auto-style1"></td></tr>
        <tr><td>    <asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
</td><td>    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td></tr>
        <tr><td ><asp:Label ID="Label4" runat="server" Text="Age"></asp:Label>
</td><td><asp:TextBox ID="txtAge" runat="server"></asp:TextBox></td></tr>
   <tr><td ><asp:Button ID="btnSubmit"
        runat="server" Text="Submit" onclick="btnSubmit_Click" />
</td></tr>
    <asp:Button ID="Button1"
        runat="server" OnClick="Button1_Click1" Text="Show All Images" />
  
    <asp:GridView ID="GridView1"
        runat="server" AutoGenerateColumns="False">
        <Columns>
            <asp:TemplateField HeaderText="Name">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server"
                        Text='<%# Eval("name") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Age">
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server"
                        Text='<%# Eval("age") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="ImageName">
                <ItemTemplate>
                    <asp:Image ID="Image1" runat="server"
                         ImageUrl='<%# Eval("imagepath") %>' />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
                </table>  
</div>
</form>
</body>
</html>



C# Coding

Image Upload & insert 

NameSpace


using System.IO

 protected void btnSubmit_Click(object sender, EventArgs e)
    {       
      
        if (FileUpload1.PostedFile != null)
        {
            name=Path.GetFileName(FileUpload1.PostedFile.FileName);

            FileUpload1.SaveAs(Server.MapPath("files/" + name));

    SqlCommand cmd = new SqlCommand
        ("insert into upload(name,age,imagename,imagepath)values('" +txtName.Text   + "','" + txtAge.Text  + "','" + name + "','" + "files/" + name + "')", con);
            cmd.ExecuteNonQuery();
            con.Close();
            Response.Write("<script>alert ('Data Inserted')</script>");

        }
    }




Gridview Bind All Table Values (Select query)

                 
protected void Button1_Click1(object sender, EventArgs e)
    {
        dbcon();
        query = "select * from upload";
        cmd = new SqlCommand(query, con);
        adp = new SqlDataAdapter(cmd);
        ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }







   











               
   




                                  

                                    
                                     


                





0 comments:

Post a Comment