Passing variable values in ASP.NET and Mysql

Question

Hello, I’m developing a page in Asp.net and I’m having trouble passing values from a Mysql SELECT to variables. I don’t know where to start and would appreciate examples of how to do.

Answer 1

this question is almost a How To, so there goes a link to be based, as we have no way to know the depth of your knowledge, I leave this how to basic:

Connecting C# to Mysql

I also suggest you try to learn Entity Framework!

Answer 2

            MySqlConnection con = new MySqlConnection("caminho da base de dados");
            MySqlCommand cmd = new MySqlCommand();
            cmd.Connection = con;
            con.Open();
            cmd.CommandType = CommandType.Text;
            string fu = "SELECT* FROM Tb_Banco where id=2";
            cmd.CommandText = fu;
            MySqlDataReader R;
            R = cmd.ExecuteReader();
            R.Read();

            string Conta_Banco = R["Conta"].ToString();
            string Nome_Banco = R["Banco"].ToString();