从数据库取得数据

来源:互联网 发布:动态桌面壁纸软件下载 编辑:程序博客网 时间:2024/05/21 14:40
DataSet ds = new DataSet();SqlConnection conn = new SqlConnection(ConnectionString);//ProcedureString sql = @"Proc_GetStudent";SqlParameter Parameter1 = new SqlParameter("ID", id);SqlParameter Parameter2 = new SqlParameter("ScoreId", scoreId);SqlParameter Parameter3 = new SqlParameter("CourseId", courseId);SqlDataAdapter adapter = new SqlDataAdapter();adapter.SelectCommand = conn.CreateCommand();adapter.SelectCommand.CommandType = CommandType.StoredProcedure;adapter.SelectCommand.Parameters.Add(Parameter1);adapter.SelectCommand.Parameters.Add(Parameter2);adapter.SelectCommand.Parameters.Add(Parameter3);adapter.SelectCommand.CommandText = sql;adapter.Fill(ds);