Inserting Values, pictures to the database ASP.NET

[$INeed$]

Inserting Values Pictures To The Database

Here in this section I will discuss how to insert values,pictures to the database. I have already discussed in the previous section how to create a database and tables so before going through this topic the concepts of Sql Connection, SqlCommand Object must be cleared.

I have used “Online Shopping Application” as main example.

In building such application websites we need to divide it into two perspective.

i) Admin
ii) User/customer.

Now all the items/products are inserted into the database by the admin.

In this below example I have used class application. A class always reduces complexity and its objects can be used every time without writing the same program .

How to create a class?

Step 1 - Go to Website and click Add New Item

Step 2 - Select Class and name it

Step 3 - Click Add

Example: Inserting Categories To the Database:

Class Used:

i)Category.cs

ii)Dal.cs

Category.cs Program Source Code:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>

/// Summary description for Category

/// </summary>

public class Category

{

    private int _catid;

    private String _catname;

    private String _catdesc;

    private String _catimage;

    public Category()

    {

        this._catid = -1;

        this._catname = "";

        this._catdesc = "";

        this._catimage= "";

    }

    public int CategoryID

    {

        get

        {

            return _catid;

        }

        set

        {

            _catid = value;

        }

    }

    public String CategoryName

    {

        get

        {

            return _catname;

        }

        set

        {

            _catname = value;

        }

    }

    public String CategoryDescription

    {

        get

        {

            return _catdesc;

        }

        set

        {

            _catdesc = value;

        }

    }

    public String filename

    {

        get

        {

            return _catimage;

        }

        set

        {

            _catimage = value;

        }

    }

    public int AddCategory()

    {

        int dup =0;

        int row=0;

        String query = "insert into category values('" + CategoryName + "','" + CategoryDescription + "','" + filename + "')";

        dal dal1 = new dal();

        dup =  dal1.checkDuplicate("select * from category where categoryname='" + CategoryName + "'");

        if (dup == 0)

      {

          row = dal1.InsertUpdateDelete(query);

      }

      else

          row = -1;

      return row;

  }

}

Dal.cs Program Source Code:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;



/// Summary description for dal



public class dal

{

    String mystring = System.Configuration.ConfigurationManager.ConnectionStrings["OurDatabaseConnectionString1"].ConnectionString;

    public dal()

      {

           

      }

    public int InsertUpdateDelete(String query)

    {

        int result = 0;

        using (SqlConnection con = new SqlConnection(mystring))

        {

            con.Open();

            SqlCommand com = new SqlCommand(query, con);

          

        }

        return result;

    }

    public DataSet getRecord(String query)

    {

        DataSet ds = null;

        using (SqlConnection con = new SqlConnection(mystring))

        {

            con.Open();

            SqlCommand com = new SqlCommand(query, con);

            SqlDataAdapter da = new SqlDataAdapter(com);

            ds=new DataSet();

            da.Fill(ds);

        }

        return ds;

    }

    public int checkDuplicate(String query)

    {

        int result = 0;

        using (SqlConnection con = new SqlConnection(mystring))

        {

            con.Open();

            SqlCommand com = new SqlCommand(query, con);

            SqlDataAdapter da = new SqlDataAdapter(com);

            DataSet ds = new DataSet();

            da.Fill(ds);

            result = ds.Tables[0].Rows.Count;

        }

        return result;

    }

}

Now The Database Part:

Table used

Category:

i) CategoryID- int**primary key

ii) CategoryName- varchar(50)

iii) CategoryDescription- varchar(50)

iv) CategoryImage- varchar(100)

Here in the above diagram:

There are two textboxs
i) TextBox1-CategoryName
ii) TextBox2-CategoryDescription
A FileUpload tool is used name-FileUpload1
Label-lblmsg used to display result during run time
And a Button-Button1(Add Category) Where the main program source code is written.

Source Code:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;

public partial class addcategory : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        TextBox3.Visible = false;

        if (IsPostBack == false)

        {

           

        }

    }

   

    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

    {

        String filename = "";

        if (FileUpload1.HasFile)

        {

            filename = Path.GetFileName(FileUpload1.PostedFile.FileName);

            string ext = Path.GetExtension(FileUpload1.PostedFile.FileName);

            if (ext.Equals(".jpg") || ext.Equals(".gif") || ext.Equals(".png") || ext.Equals(".bmp"))

            {

                FileUpload1.PostedFile.SaveAs(Server.MapPath("images/" + filename));

               

            }

            else

            {

                lblmsg.Text = "File Type is not supported";

                return;

            }

        }

        Category cat1 = new Category();

        cat1.CategoryName = TextBox1.Text;

        cat1.CategoryDescription = TextBox2.Text;

        cat1.filename = filename;

        int result = cat1.AddCategory();

        if (result == -1)

        {

            lblmsg.Text = "Category " + TextBox1.Text + "  already exists";

        }

        else

        {

            lblmsg.Text = "Category" + TextBox1.Text + " succesfully inserted";

        }

    }

   

}