how to select specified row in mysql with asp.net core

Question

I want to select a row in the table with id. How can I do it with asp.net core? Can anyone help me?

MyCode

 [HttpGet("{id}")]
    public JsonResult Get(int id)
    {
        string query = @"
                    select id,firstname,lastname from 
                    udemydb.users where id=@UsersId
        ";

        DataTable table = new DataTable();
        string sqlDataSource = _configuration.GetConnectionString("UsersAppCon");
        MySqlDataReader myReader;
        using (MySqlConnection mycon = new MySqlConnection(sqlDataSource))
        {
            mycon.Open();
            using (MySqlCommand myCommand = new MySqlCommand(query, mycon))
            {
                myReader = myCommand.ExecuteReader();
                table.Load(myReader);

                myReader.Close();
                mycon.Close();
            }
        }

        return new JsonResult(table);
    }

Where I did go wrong in the above code?

is there an error or do you just not get any data? Does the query work on its own without c#? — eglease
– eglease, Commented Sep 14, 2021 at 15:12
For ExecuteReader, have you tried checking if it HasRows? — eglease
– eglease, Commented Sep 14, 2021 at 15:14
Side note: you're not using the id parameter in the query. — iamdlm
– iamdlm, Commented Sep 14, 2021 at 15:46

Serge · Accepted Answer · 2021-09-14 16:48:48Z

2

you have to add a cmd parameter

  using (MySqlCommand myCommand = new MySqlCommand(query, mycon))
  {
     myCommand.Parameters.AddWithValue("@UsersId", id);
    myReader = myCommand.ExecuteReader();
    ......

answered Sep 14, 2021 at 16:48

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to select specified row in mysql with asp.net core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related