Insert record into Sql server database using Store Procedure and Entity framework in asp.net - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

Insert record into Sql server database using Store Procedure and Entity framework in asp.net

In this article I am going to explain how to insert record into Sql server database using Store Procedure and Entity framework in asp.net

Description:

Insert record into Sql server database using Store Procedure and Entity framework in asp.netIn this tutorial I will insert the record/data into sql server database using database first approach. I have created a table Movie in database.

Implementation:
Create a Store procedure to insert data:

Create PROCEDURE Sp_InsertMovieDetail
(
@name varchar(100),
@genre varchar(100),
@cost int,
@poster varchar(max)
)
AS
BEGIN
            SET NOCOUNT ON;
Insert into Movie(Name,Genre,Cost,Poster) values(@name,@genre,@cost,@poster)
END

To set up the ADO.net entity framework project read the article How to set upADO.net Entity Framework project or website in asp.net.
After that add a webform to project/website.

HTML Markup of webform:
<fieldset style="width:450px;">
            <legend>Entity Framework Tutorial</legend>
                <table>
        <tr>
            <td>Movie Name :</td>
            <td><asp:TextBox ID="txtname" runat="server" /></td>
        </tr>
        <tr>
            <td>Genre :</td>
            <td><asp:TextBox ID="txtgenre" runat="server" /></td>
        </tr>
        <tr>
            <td>Cost :</td>
            <td><asp:TextBox ID="txtcost" runat="server" /></td>
        </tr>
        <tr>
            <td>Upload Movie banner :</td>
            <td>
                <asp:FileUpload ID="fubanner" runat="server" /></td>
        </tr>
        <tr><td></td><td>
            <asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" CausesValidation="false" /></td></tr>
    </table>
        </fieldset>

Create the object of Entity connection
C#:
DemoEntities db = new DemoEntities();

VB:
Dim db As New DemoEntities

On button click write the code to insert the record and clear the control.
C#:
protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            string filepath = Server.MapPath("~/images/") + Guid.NewGuid() + fubanner.PostedFile.FileName;
            fubanner.SaveAs(filepath);
            string fl = filepath.Substring(filepath.LastIndexOf("\\"));
            string[] split = fl.Split('\\');
            string newpath = split[1];
            string imagepath = "~/images/" + newpath;
            db.Sp_InsertMovieDetail(txtname.Text, txtgenre.Text, Convert.ToInt32(txtcost.Text), imagepath);
            Response.Write("<script>alert('Record Insert Successfully');</script>");
            Clear();
        }
        catch(Exception ex)
        { }
    }
    public void Clear()
    {
        txtname.Text = string.Empty;
        txtcost.Text = string.Empty;
        txtgenre.Text = string.Empty;
    }

VB:
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Try
            Dim filepath As String = Server.MapPath("~/images/") & Guid.NewGuid().ToString() & fubanner.PostedFile.FileName
            fubanner.SaveAs(filepath)
            Dim fl As String = filepath.Substring(filepath.LastIndexOf("\"))
            Dim split As String() = fl.Split("\"c)
            Dim newpath As String = split(1)
            Dim imagepath As String = Convert.ToString("~/images/") & newpath
            db.Sp_InsertMovieDetail(txtname.Text, txtgenre.Text, Convert.ToInt32(txtcost.Text), imagepath)
            Response.Write("<script>alert('Record Insert Successfully');</script>")
            Clear()
        Catch ex As Exception
        End Try
    End Sub
    Public Sub Clear()
        txtname.Text = String.Empty
        txtcost.Text = String.Empty
        txtgenre.Text = String.Empty
    End Sub


Build the project and run. Test the application via insert the record. 
Demo:
Insert record into Sql server database using Store Procedure and Entity framework in asp.net

  In this article we have learn to how to insert record into sql server database using Store Procedure and Entity Framework 6.0 in asp.net Visual studio 2013I hope you enjoyed this article. 

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon