ADO.net

1.

SqlConnection ReportSender = new SqlConnection();

ReportSender.ConnectionString = conXml.ConnStr(xmlReport);
   DataTable dt=new DataTable();//DataSet也可

    ReportSender.Open();
    SqlCommand myCommand = ReportSender.CreateCommand();
    myCommand.CommandType = CommandType.StoredProcedure;
    myCommand.CommandText ="SFA_SP_WorkLevel1_New"; //ストアドプロシージャ名前;

    myCommand.Parameters.Add("@Key",SqlDbType.Int);
    myCommand.Parameters["@Key"].Value = Key;

    SqlDataAdapter mySqldataadapter =new SqlDataAdapter();
    mySqldataadapter.SelectCommand=myCommand;
    
    mySqldataadapter.Fill(dt);

2。

SqlConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:工作项目分析 estdb.mdb;Persist Security Info=True;");
            DataSet ds = new DataSet();
            try
            {
                SqlCommand cmd = conn.CreateCommand();

              //SqlCommand aa=new SqlCommand("sqlstr",SqlConnection);
                cmd.CommandText = "select * from t_name";
                cmd.CommandType = CommandType.Text;

                SqlDataAdapter da = new OleDbDataAdapter(cmd);
                da.Fill(ds);
                return ds;
            }

3。

SqlConnection myConnection = new SqlConnection(myConnectionString);
   SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
   myConnection.Open();
   SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
   while(myReader.Read())
   {
     // Console.WriteLine(myReader.GetString(0));

    myReader .Item("CompanyName")
   }
   myReader.Close();