Display record in gridview at the time of page load and download picture from gridview

Sandeepraturi
Posted by Sandeepraturi under C# category on | Points: 40 | Views : 1490
--------------------database----------------------

Table Name: tb_download

id= int(auto increment and primary key)
Name=varchar(50)
Date=Datetime
upload=varchar(50)


-------------put this code in body tag-----------------
<div>
<asp:ScriptManager ID="sp" runat="server"></asp:ScriptManager>
<table>
<h1>Information</h1>
<tr><td>
&nbsp;&nbsp;
Name:<asp:TextBox ID="txtname" runat="server"></asp:TextBox></td></tr>
<tr><td> &nbsp;&nbsp;&nbsp; Date:<asp:TextBox ID="txtdate" runat="server"></asp:TextBox><cc1:CalendarExtender
ID="CalendarExtender1" runat="server" TargetControlID="txtdate">
</cc1:CalendarExtender></td></tr>
<tr><td>Upload:<asp:FileUpload ID="file" runat="server" /></td></tr>
<tr><td align="center"><asp:Button ID="btn" runat="server" Text="Upload"
onclick="btn_Click" /></td></tr>
</table>
<asp:GridView ID="gv" runat="server" AutoGenerateColumns="False"
Height="188px" Width="300px" CellPadding="4" ForeColor="#333333"
GridLines="None" >
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns><asp:TemplateField HeaderText="Name">

<ItemTemplate>

<%#Eval("Name") %>
</ItemTemplate>

</asp:TemplateField>
<asp:TemplateField HeaderText="Date" >
<ItemTemplate>
<%#Eval("Date") %>

</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Download">
<ItemTemplate>
<a href='/upload/<%#Eval("Upload") %>'><%#Eval("Upload") %></a>

</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>


</div>

---------c# code------------------------
Note: Add upload folder in your project

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace sandeep
{
public partial class WebForm2 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=SANDEEP-PC;database=Example;integrated security=true");

protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack != true)
{
BindData();
}
}
protected void btn_Click(object sender, EventArgs e)


{
if (file.HasFile)
{
String path = Server.MapPath("upload/");
String filename = file.FileName;
file.SaveAs(path + filename);
SqlCommand cmd = new SqlCommand("insert into tb_download values('" + txtname.Text + "','" + txtdate.Text + "','" +filename + "')", con);
con.Open();
cmd.ExecuteNonQuery();
clear();
con.Close();
BindData();
}
}

protected void clear()
{
txtdate.Text = "";
txtname.Text = "";
}

protected void BindData()
{
SqlDataAdapter dap = new SqlDataAdapter("select * from tb_download ", con);
DataSet ds = new DataSet();
dap.Fill(ds);

gv.DataSource = ds;
gv.DataBind();
}

}

}

Comments or Responses

Login to post response