>oleDbAdapter = new OleDbDataAdapter(); >oleDbAdapter.SelectCommand = new OleDbCommand("MyStoredProcedureName", oleDbConnection); >oleDbAdapter.Fill(myDataset, "myTable"); >>
public class ScrapConnection { public static SqlConnection GetConnection() { string connectionString = ConfigurationSettings.AppSettings["connectionString"]; return new SqlConnection(connectionString); } } public static DataSet FindUser(string UserID) { // Return a DataSet using a Stored Procedure... SqlDataAdapter daUser = new SqlDataAdapter(); SqlParameter UserParm1 = new SqlParameter("@UserID", SqlDbType.Char,25); UserParm1.Direction = ParameterDirection.Input; UserParm1.Value = UserID; daUser.SelectCommand = new SqlCommand(); daUser.SelectCommand.Connection = ScrapConnection.GetConnection(); daUser.SelectCommand.CommandText = "GetUser"; daUser.SelectCommand.CommandType= CommandType.StoredProcedure; daUser.SelectCommand.Parameters.Add(UserParm1); DataSet dsUser = new DataSet(); daUser.Fill(dsUser,"UserID"); ScrapConnection.GetConnection().Close(); // 11-17-2004 return dsUser; }Tom