Insert (Save) multiple Images and form data on Button Click using C# in ASP.Net

Hi vrindavani,

For displaying the record you can use repeater control. Check below example.

HTML

<div class="row">
    <div class="col-md-12">
        <a href="#">
            <h2 style="text-align: center;"><span style="color: #1b4971; font-weight: bold;">Make Entry</span></h2>
        </a>
    </div>
    <div class="row" style="margin-top: 1.5%">
        <div class="col-md-6">
            <label>Title</label>
            <asp:TextBox ID="txt_title" runat="server" CssClass="form-control" placeholder="Title"></asp:TextBox>
        </div>
        <div class="col-md-6">
            <label>Type</label>
            <asp:DropDownList ID="drptype" runat="server" CssClass="form-control" placeholder="type">
                <asp:ListItem>ABC</asp:ListItem>
            </asp:DropDownList>
        </div>

    </div>
    <div class="row" style="margin-top: 1%">
        <div class="col-md-12 mg">
            <label>P1 Title</label>
            <asp:TextBox ID="txttitle1" runat="server" CssClass="form-control" placeholder="P1Title"></asp:TextBox>
        </div>
        <div class="col-md-12 mg">
            <label>Paragraph1</label>
            <asp:TextBox ID="txt_paragraph1" runat="server" CssClass="form-control" placeholder="Please Enter Your Paragraph " TextMode="MultiLine" Height="90"></asp:TextBox>
        </div>
        <div class="col-md-12">
            <label>Upload Image</label>
            <asp:FileUpload ID="Fu" CssClass="form-control" runat="server" AllowMultiple="true" />
        </div>

    </div>
    <div class="row" style="margin-top: 1%">
        <div class="col-md-8">
            <asp:Button ID="btnsubmit" runat="server" Text="Submit" CssClass="btn btn-danger" Style="height: 35px; width: 20%; color: white; background-color: #1b4971;" OnClick="btnsubmit_Click" />
            <asp:Button ID="BtnCancel" runat="server" Text="Back" CssClass="btn btn-danger" Style="height: 35px; width: 20%; color: white; background-color: #1b4971;" OnClick="BtnCancel_Click" />
        </div>

    </div>
</div>
<asp:Repeater runat="server" ID="Repeater1">
    <HeaderTemplate>
        <table cellspacing="0" rules="all" border="1">
            <tr>
                <th scope="col" style="width: 80px">Title
                </th>
                <th scope="col" style="width: 120px">Type
                </th>
                <th scope="col" style="width: 100px">P1 Title
                </th>
                <th scope="col" style="width: 100px">Paragraph
                </th>
                <th scope="col" style="width: 100px">Image
                </th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td>
                <asp:Label ID="lblTitle" runat="server" Text='<%# Eval("Title") %>' />
            </td>
            <td>
                <asp:Label ID="lblType" runat="server" Text='<%# Eval("Type") %>' />
            </td>
            <td>
                <asp:Label ID="lblP1Title" runat="server" Text='<%# Eval("P1Title") %>' />
            </td>
            <td>
                <asp:Label ID="lblParagraph" runat="server" Text='<%# Eval("Paragraph") %>' />
            </td>
            <td>
                <asp:Image ImageUrl='<%# String.Format("~/Img/{0}", Eval("ImageName"))%>' runat="server" />
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

Namespaces

C#

using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindRepeater();
    }
}

private void BindRepeater()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    string query = "SELECT * FROM tblabc";
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            cmd.Connection = con;
            SqlDataAdapter sda = new SqlDataAdapter();
            DataTable dt = new DataTable();
            sda.Fill(dt);
            Repeater1.DataSource = dt;
            Repeater1.DataBind();
        }
    }
}

protected void btnsubmit_Click(object sender, EventArgs e)
{
    HttpFileCollection imagecollection = Request.Files;
    for (int i = 0; i < imagecollection.Count; i++)
    {
        HttpPostedFile uploadimages = imagecollection[i];
        string filename = Path.GetFileName(uploadimages.FileName);
        uploadimages.SaveAs(Server.MapPath("~/Img/") + filename);
        string query = "insert into tblabc values(N'" + txt_title.Text + "',N'" + txt_paragraph1.Text + "','" + System.DateTime.Now.ToString("yyyy-MM-dd") + "','" + 1 + "','" + drptype.Text + "','" + filename + "',N'" + txttitle1.Text + "')";
        ExecuteInsertUpdateOrDelete(query);
    }
    Response.Redirect(Request.Url.AbsoluteUri);
}

private bool ExecuteInsertUpdateOrDelete(string query)
{
    int i = 0;
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            cmd.Connection = con;
            con.Open();
            i = cmd.ExecuteNonQuery();
            con.Close();
        }
    }

    return i > 0 ? true : false;
}

private void ResetValue()
{

}

protected void BtnCancel_Click(object sender, EventArgs e)
{

}