Please refer below sample:
Page 1:
HTML
<div>
Id :
<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
Image :
<asp:FileUpload ID="fileUpload" runat="server" />
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="Submit" />
</div>
Namespace:
using System.Data.SqlClient;
using System.Configuration;
C#
protected void Submit(object sender, EventArgs e)
{
int Id = 0;
string fileName = string.Empty, filepath = string.Empty;
if (int.TryParse(this.txtId.Text.Trim(), out Id))
Id = int.Parse(this.txtId.Text.Trim());
if (fileUpload.HasFile)
{
fileName = fileUpload.FileName;
filepath = "Images/" + fileName;
fileUpload.SaveAs(Server.MapPath(filepath).ToString());
string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO tblImages VALUES(@Id,@FileName,@FilePath)", con))
{
cmd.Parameters.AddWithValue("@Id", Id);
cmd.Parameters.AddWithValue("@FileName", fileName);
cmd.Parameters.AddWithValue("@FilePath", filepath);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}}
}
Screenshot
Page 2:
HTML
<div>
Id:
<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
<asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="Search" />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:TemplateField>
<ItemTemplate>
<asp:Image ID="image" runat="server" ImageUrl='<%#Eval("Image") %>' Width="75" Height="75" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
Namespace:
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
C#
protected void Search(object sender, EventArgs e)
{
int Id = 0;
if (int.TryParse(this.txtId.Text.Trim(), out Id))
Id = int.Parse(this.txtId.Text.Trim());
string query = "SELECT Id, FilePath AS Image FROM tblImages WHERE Id = @Id";
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Id", Id);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}
Screenshot
SQL
CREATE TABLE [dbo].[tblImages](
[Id] [int] NOT NULL,
[FileName] [varchar](50) NULL,
[FilePath] [varchar](200) NULL
) ON [PRIMARY]
GO