Execute stored procedure using table adapter in C#

Question

In VB.net I can simply execute a stored procedure in SQL Server 2008 using the query in image below, but in C# I got an error.

Can you help me about the proper syntax in C#?

Thanks

Show us the actual VB code, not the VB code pasted into a C# class. — mjwills, Jul 08 '17 at 04:00
textBox3.Text = this.tbl_UsersTableAdapter.getUser(textBox1.Text,textBox2.Text); — Davees John Baclay, Jul 08 '17 at 05:40
you don't need to include the field names such as username and password unlike in Vb, — Davees John Baclay, Jul 10 '17 at 00:36

score 1 · Answer 1 · answered Jul 08 '17 at 04:12

using (SqlConnection conn = new SqlConnection(your-connection-string)) {
conn.Open();

// 1.  create a command object identifying the stored procedure
SqlCommand cmd  = new SqlCommand("your-procedure-name", conn);

// 2. set the command object so it knows to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;

// 3. add parameter to command, which will be passed to the stored procedure
cmd.Parameters.Add(new SqlParameter("@Username", textBox1.Text));
cmd.Parameters.Add(new SqlParameter("@Password", textBox2.Text));

// execute the command
using (SqlDataReader result = cmd.ExecuteReader()) {
    // iterate through results, printing each to console
    while (result .Read())
    {
      // Name  and Password Should Match with your proc col name 
      var userName  = result["Name"].toString();
      var password  = result["password"].toString();

    }
}
 }

For More details Please Read this this

How to execute a stored procedure within C# program

Execute stored procedure using table adapter in C#

1 Answers1