C#からSELECT文を実行


using System.Data;
using System.Data.OleDb;　

string mySQL = "SELECT ProjectNo , ProjectName  FROM M_Project";

OleDbCommand myCommand = new OleDbCommand(mySQL, myConn);
myCommand.Connection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);

while (myReader.Read())
{
    string strProjectNo = myReader.GetString(0));
    string strProjectName = myReader.GetString(1));
}
myReader.Close();
myConn.Close();

using System.Data;

using System.Data.OleDb;　

string mySQL = "SELECT ProjectNo , ProjectName FROM M_Project";

OleDbCommand myCommand = new OleDbCommand(mySQL, myConn);

myCommand.Connection.Open();

OleDbDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);

while (myReader.Read())

{

string strProjectNo = myReader.GetString(0));

string strProjectName = myReader.GetString(1));

}

myReader.Close();

myConn.Close();