Stored Procedure with parameter in C# with Sql Server for Insertion
Consider Table name:sampletable
field
username nvarchar(50)
mark1 int
Write it in Stored Procedure [if you create table first time, Then it automatically changed to alter]Procedure name-InsertUser
ALTER PROCEDURE [dbo].[InsertUser]
(
@username varchar(50),
@mark1 int
)
AS
INSERT INTO sampletable VALUES(@username, @mark1)
Coding in C#
protected void Button1_Click(object sender, EventArgs e)
{
string username=(TextBox1.Text);
string mark=(TextBox2.Text);
SqlConnection myConnection = new SqlConnection("user id=userid;" + "password=pwd;" + "Data source=localhost;" + "Integrated security=true;" + "database=sample;");
SqlCommand myCommand = new SqlCommand("InsertUser", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@username", SqlDbType.VarChar).Value = username;
myCommand.Parameters.Add("@mark1", SqlDbType.Int).Value = mark;
myConnection.Open();
int rows = myCommand.ExecuteNonQuery();
myConnection.Close();
}
Dotnet, DotnetCore, Azure, C#,VB.net, Sql Server, WCF, MVC ,Linq, Javascript and Jquery
Subscribe to:
Post Comments (Atom)
Consistency level in Azure cosmos db
Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
· Azure Service Fabric is Microsoft’s Platform-as-a-Service (PaaS) and is used to build and deploy microservices-based cloud applicat...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...
No comments:
Post a Comment
Comments Welcome