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();