Upload-and-save-insert-multiple-files-to-database using ASP.NET

.

*.aspx

<div>

        <asp:FileUpload ID="FileUpload1" runat="server" />

        <asp:Button ID="Button1" runat="server" Text="Save" OnClick="Button1_Click" />

        <asp:GridView ID="GridView1" runat="server"></asp:GridView>

    </div>

*.cs

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

    public void BindData()
    {
        string constr = ConfigurationManager.ConnectionStrings["connecionString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "SELECT Id, Name FROM images";
                cmd.Connection = con;
                con.Open();
                GridView1.DataSource = cmd.ExecuteReader();
                GridView1.DataBind();
                con.Close();
            }
        }
    }

Button_click Event

foreach (HttpPostedFile postedFile in FileUpload1.PostedFiles)

        {
            string filename = Path.GetFileName(postedFile.FileName);
            string contentType = postedFile.ContentType;
            using (Stream fs = postedFile.InputStream)
            {
                using (BinaryReader br = new BinaryReader(fs))
                {
                    byte[] bytes = br.ReadBytes((Int32)fs.Length);
                    string constr = ConfigurationManager.ConnectionStrings["connecionString"].ConnectionString;
                    using (SqlConnection con = new SqlConnection(constr))
                    {
                        string query = "insert into images values (@Name, @Type, @Data)";
                        using (SqlCommand cmd = new SqlCommand(query))
                        {
                            cmd.Connection = con;
                            cmd.Parameters.AddWithValue("@Name", filename);
                            cmd.Parameters.AddWithValue("@Type", contentType);
                            cmd.Parameters.AddWithValue("@Data", bytes);
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                        }
                    }
                }
            }
        }
        Response.Redirect(Request.Url.AbsoluteUri);

Output:

Generate Barcode using C Sharp.

Barcode Font

First we should download the Font from the Url which is given below

Download Barcode Font

Once downloaded follow the below steps.

1. Extract the ZIP file.

2. Click and Execute INSTALL.exe file.

Output:

*.aspx

<div>

        <table class="auto-style1">

            <tr>

                <td>

                    <asp:Label ID="lblNumber" runat="server" style="text-align:right" Text="Enter Number"></asp:Label>

                </td>

                <td>

                    <asp:TextBox ID="txtNumber" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>&nbsp;</td>

                <td>

                    <asp:Button ID="btnGenerate" runat="server" Text="Generate" OnClick="btnGenerate_Click" style="height: 26px" />

                </td>

            </tr>

            <tr>

                <td>

                    <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>

                </td>

            </tr>                  

        </table>

        </div>

*.CS

using System;

using System.Collections.Generic;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace WebApplication3

{

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

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void btnGenerate_Click(object sender, EventArgs e)

        {

            string barCode = txtNumber.Text;

            System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();

            using (Bitmap bitMap = new Bitmap(barCode.Length * 40, 80))

            {

                using (Graphics graphics = Graphics.FromImage(bitMap))

                {

                    Font oFont = new Font("IDAutomationHC39M", 16);

                    PointF point = new PointF(2f, 2f);

                    SolidBrush blackBrush = new SolidBrush(Color.Black);

                    SolidBrush whiteBrush = new SolidBrush(Color.White);

                    graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height);

                    graphics.DrawString("*" + barCode + "*", oFont, blackBrush, point);

                }

                using (MemoryStream ms = new MemoryStream())

                {

                    bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

                    byte[] byteImage = ms.ToArray();

                    Convert.ToBase64String(byteImage);

                    imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);

                }

                PlaceHolder1.Controls.Add(imgBarCode);

            }

        }

    }

}

Query Shortcuts in SQL Server Management Studio

we can create shorcuts in SQL Management Studio. Some of the shortcuts are predefined,

Examples

"Alt + F1" will execute "sp_help"

"Ctrl + 1" will execute "sp_who".

You can create new shortcuts for your own queries

Go to Sql Server Management Studio

Tools --> Options ---> Environment ---> Keyboard ---> Query Shortcuts

For example, you can create a shortcut for:

Syntax

"Ctrl + 3 " : SELECT * FROM  (single space after from keyword)

Use just the  table name in new query and press "ctrl + 3" and query will executed.

What is the difference between String and string in C#?

Example :

string s = "uday";

String S = "uday";

string is an alias for System.String. So technically, there is no difference. It's like int vs. System.Int32.

string is a c sharp keyword.

It is recommended to use string any time when you're referring to an object.

e.g :  string name = "uday";

Where as use String if you need to refer specifically to the class. e.g.

string firstname= String.Format("Uday" {0}!", name);

This is the style that Microsoft tends to use in their examples

Note: You must have to include a using System when using String, otherwise you get the following error:

The type or namespace name 'String' could not be found (are you missing a using directive or an assembly reference?)

These are the aliases defined:

Alias     CLR type

string   System.String

sbyte    System.SByte

byte     System.Byte

Note:  String represents the System.String class while the string is the keyword for the System.String that we can use to create string objects.

Very Useful jQuery code examples

zoom element text on Mouse over 

Javascript Code:

<script type="text/javascript">

        $(document).ready(function () {

            var oldSize = parseFloat($("#ZOOM").css('font-size'));

            var newSize = oldSize * 2;

            $("#ZOOM").hover(

              function () {

                  $("#ZOOM").animate({ fontSize: newSize }, 200);

              },

              function () {

                  $("#ZOOM").animate({ fontSize: oldSize }, 200);

              }

           );

        });

    </script>

    <style type="text/css">

        #ZOOM

        {

        font-size:10pt;

        font-family:'Times New Roman';

        }

    </style>

Design.aspx:

Output:

zoom Image

Output:

disable spacebar

output:

to find out which key was pressed

Design:

Output: