Insert Data to SQL-SERVER from Webform by using Stored Procedure

Step 1 : Create a Table in Sql-Server

CREATE TABLE LearningSite (
    ID Int primary key Identity(1,1),
    Topic nvarchar(max),
    Status nvarchar(max),
);




Step 2 Create Stored-Procedure :

create procedure InsertLS
@Topic nvarchar(max),
@Status nvarchar(max)
as
begin
insert into LearningSite(Topic,Status) values(@Topic,@Status)
end




Step 3 : Create a Webapplication in Visual-Studio and Add a Webform

Step 4: Give a connection string in Web.Config
  <connectionStrings>

<add name="conStr" connectionString="Data Source=Sqlservername; Initial Catalog=Company;

Integrated Security=True; MultipleActiveResultSets=True;"

providerName="System.Data.SqlClient" />

 </connectionStrings>

Company:-Database Name.

Step 5 : Write Below code in aspx page:



            <asp:TextBox ID="TextBox1" runat="server" Placeholder="Topic"></asp:TextBox><br /><br />
            <asp:TextBox ID="TextBox2" runat="server" Placeholder="Status"></asp:TextBox><br /><br />
            <asp:Button ID="Button1" runat="server" Text="Insert" OnClick="Button1_Click" />
            <asp:Label ID="Label1" runat="server"></asp:Label>

Step 6 : Code Behind :
Write a connection string by using ConfigurationManager

string constr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;

Step 7 :
write below line in Page void

ValidationSettings.UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;

Step 8 :

Write below code in Button1_Click

SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "InsertLS";
            cmd.Parameters.Add("@Topic", SqlDbType.VarChar).Value = TextBox1.Text.Trim();
            cmd.Parameters.Add("@Status", SqlDbType.VarChar).Value = TextBox2.Text.Trim();
            cmd.Connection = con;
            try
            {
                con.Open();
                cmd.ExecuteNonQuery();
                Label1.Text = "Record inserted successfully";
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
            }

Finally Execute:























Comments

Post a Comment

Popular posts from this blog

jQuery dynamic menu from database in asp.net

Step 1 : Create SQL Server table and insert menu data  Create table tblMenu (     Id int primary key identity,     MenuText nvarchar(30),     ParentId int foreign key references tblMenu(Id),     Active bit ) Go Insert into tblMenu values('USA', NULL, 1) Insert into tblMenu values('India', NULL, 1) Insert into tblMenu values('UK', NULL, 1) Insert into tblMenu values('Australia', NULL, 1) Insert into tblMenu values('Virginia', 1, 1) Insert into tblMenu values('Maryland', 1, 1) Insert into tblMenu values('AP', 2, 1) Insert into tblMenu values('MP', 2, 1) Insert into tblMenu...
Read more

Drag and Drop multiple File upload using jQuery AJAX in ASP.Net using C# and VB.Net

Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the jQuery FileDrop plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net. In this article I will explain with an example, how to upload multiple files with Drag and Drop in HTML5 supported browsers using jQuery and AJAX in ASP.Net using C# and VB.Net. Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the  jQuery FileDrop  plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net.  ...
Read more

Automatically send Birthday email using C#.Net

In order to automatically send Birthday email daily at particular time, a Windows Service will be created which will run daily at the particular time and will automatically send Birthday emails using C#.Net. In this article the Windows Service will execute a Task daily at a specific time. The Task is to fetch all records of Students who have a Birthday today. Such students will receive an email containing Birthday wishes automatically by the Windows Service. Config:- < appSettings >     < add  key  = " Mode "  value  = " Daily "  />     < add  key  = " IntervalMinutes "  value  = " 1 "  />     < add  key  = " ScheduledTime "  value  = " 17:43 "  /> </ appSettings > < connectionStrings >     < add  name = " constr "  connectionString = " Data Source=.\SQL2008R2;Initial Catalog=S...
Read more