Bonnie;

Thank you. I did use the () but forgot it in my example. :)

Tom

>Tom,
>
>I think you need to use:
>
>ScrapDB.CloseReader();
>
>~~Bonnie
>
>
>
>>Randy;
>>
>>Thank you for your time and effort to point me in the right direction.
>>
>>Randy;
>>
>>I like your idea and am attempting to implement it. Here is the latest:
>>
>>In the Form Load
>>

>>DdlUsers.DataSource = ScrapDB.GetUsers();
>>DdlUsers.DataTextField = “UsersID”;
>>DdlUsers.DataBind();
>>
>>ScrapDB.CloseReader;
>>

>>The code fires and populates ddlUsers. An error is thrown in Public static CloseReader() // Under CloseReader(), in my data class and the message is ”“Class, struct, or interface method must have a return type”.
>>
>>So I tried:
>>

>>Public void CloseReader()
>>{
>>	UsersReader.Close();
>>}
>>

>>Again ddlUsers loads and it throws an error on the form at ScrapDB.CloseReader; and the error is:
>>“An object reference is required for the nonstatic field, method or property ‘eScrap_C.
>>ScrapDB.CloseReader()”
>>
>>Do you see where I am going wrong? At least I am filling the ddl! :)
>>
>>Tom
>>
>>
>>
>>
>>
>>>Hey Thomas, the close reader will not run because it is after the return statement. you can do one of two things. store the data from the read into a variable then close the read and return the variable. Or create another method to close the reader and call it after you finish using it in your program.
>>>
>>>

>>>public class ScrapDB
>>>	{
>>>             public sqldatareader UsersReader
>>>
>>>		public static SqlConnection GetConnection()
>>>		{
>>>			string connectionString = ConfigurationSettings.AppSettings["connectionString"];
>>>		
>>>			return new SqlConnection(connectionString);
>>>	
>>>		}
>>>
>>>	public static SqlDataReader GetUsers()
>>>				{
>>>			// Use a SqlDataReader to fill ddlUsers...
>>>			SqlDataReader UsersReader = null ;
>>>				
>>>					SqlConnection UsersConnection = GetConnection() ;
>>>					
>>>					string selectStatement = "SELECT UserID "
>>>						+ "FROM UserInfo ";
>>>			
>>>					SqlCommand selectCommand = new SqlCommand(selectStatement, UsersConnection);
>>>					//SqlDataReader UsersReader;
>>>			
>>>					UsersConnection.Open();
>>>					UsersReader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection);
>>>					UsersReader.Read() ;
>>>					return UsersReader ;
>>>				
>>>				
>>>			
>>>		
>>>
>>>			}
>>>		public static CloseReader()
>>>		{
>>>		        UsersReader.Close() ;
>>>	
>>>		}
>>>
>>>}
>>>
>>>
>>>
>>>
>>>