Monday, April 29, 2013

How to insert data into database using LINQ?

Introduction: In this post I will explain how to insert data into database using LINQ.


Create a table name LINQ_TABLE.

Now go to Visual studio>File>New website> empty web site. Now go to Solution Explorer, right click on website>Add new item>Linq to Sql classes.

Now you see App_code folder will added to application and a dataclasses added with extension .dbml in App_code folder.
See the attached image below:

Now check the web.config file of application. It self create a connectionstring for database.

Now connect the database to server explorer. After that drag and drop the table from database.

Add a web form to application. Go to Solution Explorer, right click on website>Add new item> Web from.
        <asp:TextBox ID="txtusername" runat="server"></asp:TextBox></td></tr>
        <tr><td>First Name</td><td>
            <asp:TextBox ID="txtfirst" runat="server"></asp:TextBox></td></tr>
            <tr><td>Last Name</td><td>
                <asp:TextBox ID="txtlast" runat="server"></asp:TextBox></td></tr>
                <tr><td>Date Of Birth</td><td>
                    <asp:DropDownList ID="ddldate" runat="server">
                    <asp:DropDownList ID="ddlmonth" runat="server">
                    <asp:DropDownList ID="ddlyear" runat="server">
                    <asp:RadioButtonList ID="rblsex" runat="server">
                    <asp:TextBox ID="txtage" runat="server"></asp:TextBox></td></tr>
                        <asp:TextBox ID="txtpassword" runat="server" TextMode="Password"></asp:TextBox></td></tr>
                        <tr><td>Confirm Password</td><td>
                            <asp:TextBox ID="txtconfirm" runat="server" TextMode="Password"></asp:TextBox></td></tr>
                            <tr><td>Upload Image</td><td>
                                <asp:FileUpload ID="FileUpload1" runat="server" /></td></tr>
                                       <asp:Button ID="btnsave" runat="server" Text="Save" onclick="btnsave_Click" />

After adding control and design on .aspx , double click on button save. Make an object of Dataclasses. Firstly create a folder name “Images” to save the uploaded images.
DataClassesDataContext db = new DataClassesDataContext();
    int i;
protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            ddldate.Items.Insert(0,new ListItem("DD","DD"));
            ddlmonth.Items.Insert(0, new ListItem("MM", "MM"));
            ddlyear.Items.Insert(0, new ListItem("YY", "YY"));
            for (i = 1; i < 32; i++)
            for (i = 1; i < 13; i++)
            for (i = 1950; i < 2013; i++)
protected void btnsave_Click(object sender, EventArgs e)
        string image = Server.MapPath("~/Images/")+ Guid.NewGuid() + FileUpload1.PostedFile.FileName;
        string fl = image.Substring(image.LastIndexOf("\\"));
        string[] split = fl.Split('\\');
        string newpath = split[1];
        string imagepath = "~/Images/" + newpath;
        LINQ_TABLE tb = new LINQ_TABLE();
            if (txtpassword.Text == txtconfirm.Text)
                tb.USERNAME = txtusername.Text;
                tb.FIRST_NAME = txtfirst.Text;
                tb.LAST_NAME = txtlast.Text;
                tb.DATE_BIRTH = ddldate.Text + "/" + ddlmonth.Text + "/" + ddlyear.Text;
                tb.SEX = rblsex.SelectedValue;
                tb.AGE = txtage.Text;
                tb.PASSWORD = txtpassword.Text;
                tb.IMAGE = imagepath;


                Response.Write("Passowrd not match");
        catch (Exception ex)
            Response.Write("Error:" + ex.ToString());
private void Clear()
        txtusername.Text = string.Empty;
        txtfirst.Text = string.Empty;
        txtlast.Text = string.Empty;
        txtpassword.Text = string.Empty;
        txtconfirm.Text = string.Empty;
        ddldate.SelectedIndex = 0;
        ddlmonth.SelectedIndex = 0;
        ddlyear.SelectedIndex = 0;
        rblsex.SelectedIndex = 0;
        txtage.Text = string.Empty;

Now check out the result.

Related Articles on LINQ

Ø  What is LINQ? Its advantage, disadvantage and types

Ø  How to Bind Gridview Data Control in LINQ?

Ø  How to Bind Dropdownlist in using LINQ?

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

No comments:

Post a Comment