SqlCommand ExecuteNonQuery Example C# VB Asp.Net

This is Example of how to use ExecuteNonQuery Method Of SqlCommand In Asp.Net Using C# And VB.

ExecuteNonQuery() Executes a Transact-SQL statement, It returns -1 for SELECT statements and Number of Rows affected for all INSERT DELETE AND UPDATE statements.

I have also explained Other methods of SqlCommand.

C# CODE

---

show source

01protected void btnSignIn_Click(object sender, EventArgs e)

02    {

03        string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

04        string strInsert = "INSERT INTO Users (Username,Password) VALUES(@Username,@Password)";

05        SqlConnection con = new SqlConnection(strConnection);

06        SqlCommand cmd = new SqlCommand();

07        cmd.Connection = con;

08        cmd.CommandType = CommandType.Text;

09        cmd.CommandText = strInsert;

10 

11        SqlParameter username = new SqlParameter("@Username", SqlDbType.VarChar, 50);

12        username.Value = txtUserName.Text.Trim().ToString();

13        cmd.Parameters.Add(username);

14 

15        SqlParameter password = new SqlParameter("@Password", SqlDbType.VarChar, 50);

16        password.Value = txtPassword.Text.Trim().ToString();

17        cmd.Parameters.Add(password);

18 

19        con.Open();

20        int result = cmd.ExecuteNonQuery();

21 

22        con.Close();

23    }

VB.NET

---

show source

01Protected Sub btnSignIn_Click(sender As Object, e As EventArgs)

02 Dim strConnection As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString

03 Dim strInsert As String = "INSERT INTO Users (Username,Password) VALUES(@Username,@Password)"

04 Dim con As New SqlConnection(strConnection)

05 Dim cmd As New SqlCommand()

06 cmd.Connection = con

07 cmd.CommandType = CommandType.Text

08 cmd.CommandText = strInsert

09 

10 Dim username As New SqlParameter("@Username", SqlDbType.VarChar, 50)

11 username.Value = txtUserName.Text.Trim().ToString()

12 cmd.Parameters.Add(username)

13 

14 Dim password As New SqlParameter("@Password", SqlDbType.VarChar, 50)

15 password.Value = txtPassword.Text.Trim().ToString()

16 cmd.Parameters.Add(password)

17 

18 con.Open()

19 Dim result As Integer = cmd.ExecuteNonQuery()

20 

21 con.Close()

22End Sub

Hope this helps

Tweet

If you like this post than join us or share