Content

• Upload Media files using asp.net C#
• Sqldatareader in C#
• Show data from SQL Database

Upload Image using asp.net C#

• To insert image/video into database - we have to save image/video in folder and we will insert the path of image/video file in database
• we can also store images in database by converting them into binary format, in that case we have to use varbinary datatype at server side

Example :

Frond-End code

<div class="form-group">
<asp:FileUpload runat="server" ID="fugallery" CssClass="form-control" Style="height:auto" AllowMultiple="true"/>
            </div>
<asp:Button runat="server" CssClass="btn btn-primary" OnClick="btnsubmit_Click" ID="btnsubmit" OnClientClick="return CheckFileExistence()"  BorderStyle="Double" Style="margin-top:20px" Text="Upload Photos" />

Back-End code

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

protected void btnsubmit_Click(object sender, EventArgs e)
{
    try
    {
        foreach (var files in fugallery.PostedFiles)
        {
            string ext = System.IO.Path.GetExtension(files.FileName);

            Guid g = Guid.NewGuid();
            string imageNameid = g.ToString().Substring(10);
            string imgName = imageNameid + ext;
            string pathimg = "Photos/" + imgName;

            files.SaveAs(Server.MapPath(pathimg));

            con.Close();
            SqlCommand cmd = new SqlCommand("insert into DBPhotos(PhotoPath,SubmitDate) values('" + pathimg + "','" + DateTime.Now + "')", con);
            con.Open();
            cmd.ExecuteNonQuery();
            
            this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Gallery Photo/Photos Uploaded,Thank you!','','success');", true);

        }
    }
    catch (Exception es)
    {

    }
    finally
    {
    con.Close();
    }
}
}

---

Sqldatareader in C#

• SqlDataReader Object provides a connection oriented data access to the SQL Server data Sources from C# applications
• The Read() method in the DataReader is used to read the rows from DataReader

---

Show data from SQL Database

Example :

Frond-End code

<div class="row">
<div class="col-lg-10" style="padding-top: 30px; padding-bottom: 30px">
    <div class="card">
        <div class="card-header"><strong>Edit Blog</strong></div>
        <div class="card-body card-block">
            <div class="form-group">
                <label for="company" class=" form-control-label">Name *</label>
                <asp:TextBox> runat="server" CssClass="form-control" ID="txtName"></asp:TextBox>
                            
            </div>
            <div class="form-group">
                <label for="company" class=" form-control-label">Contact *</label>
                <asp:TextBox> runat="server" TextMode="Number" CssClass="form-control"  ID="txtContact"></asp:TextBox>
                            
            </div>
           <div class="form-group">
                <label for="company" class=" form-control-label">Email *</label>
                <asp:TextBox> runat="server"  CssClass="form-control"  ID="txtEmail"></asp:TextBox>
                            
            </div>
            <div class="form-group">
                <label for="company" class=" form-control-label">City *</label>
                <asp:TextBox> runat="server"  CssClass="form-control"  ID="txtCity"></asp:TextBox>
                            
            </div>
           
        </div>
    </div>
</div>
</div>

Back-End code

using System;
    using System.Collections.Generic;
    using System.Configuration;
    using System.Data.SqlClient;
    using System.IO;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    
    namespace MyTaxSolutions.AdminControl
    {
        public partial class Editblog : System.Web.UI.Page
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connstr"].ConnectionString);
            protected void Page_Load(object sender, EventArgs e)
            {
               
                    getuser();
                
            }
    
            protected void getuser()
            {
                con.Close();
                SqlCommand cmd = new SqlCommand("select top 1  * from Users", con);
                con.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                if (sdr.HasRows)
                {
                    sdr.Read();
                    txtName.Text = sdr.GetValue(1).ToString();
                    txtContact.Text = sdr.GetValue(2).ToString();
                    txtEmail.Text = sdr.GetValue(3).ToString();
                    txtCity.Text = sdr.GetValue(4).ToString();
                }
            }
        }
    }