[FIXED] How To Create models Connect ODBC mySQL with Visual Studio

Issue

using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Odbc;
using System.Data.SqlClient;


namespace BroNetNew.Models
{
    public class DataConn
    {
        string MyConString = "Driver={MySQL ODBC 5.3 Unicode Driver};" +
                  "SERVER=localhost;" +
                  "DATABASE=Bee;" +
                  "UID=root;" +
                  "PASSWORD=123;" +
                  "OPTION=4";

        OdbcConnection MyConnection = new OdbcConnection(myConString);
        MyConnection.Open();
        string sql = "SELECT * from member";
        OdbcConnection conn = null;
        OdbcCommand comm = null;
        OdbcDataReader dr = null;
        conn = new OdbcConnection(MyConString);
        conn.Open();
        comm = new OdbcCommand(sql, conn);
        dr = comm.ExecuteReader();
    }
}

I don't know how to make it work and how to get data from table member(MY DB name:Bee in MyConString)

Please Help ... I First time use asp.net MVC.

Thank You...

Solution

 public class DataConn
    {
        string MyConString = "Driver={MySQL ODBC 5.3 Unicode Driver};" +
                  "SERVER=localhost;" +
                  "DATABASE=Bee;" +
                  "UID=root;" +
                  "PASSWORD=123;" +
                  "OPTION=4"; //  ODBC connection
        string Query = "SELECT * from member"; // Write Query

        using (OdbcConnection c = new OdbcConnection(myConString)) //New Connection
        {
            OdbcCommand cmd = new OdbcCommand(Query, c); 
            c.Open(); // Connection Open

            OdbcDataReader dr = cmd.ExecuteReader();
            // dr will get all data u want
            // Query better use "SELECT column[0], column[1] FROM `member`";
            // dr.GetString(0); -> for column[0]
            // dr.GetString(1); -> for column[1]
            // do something...
        }
    }

Answered By - JH Ong

Answer Checked By - Timothy Miller (PHPFixing Admin)