自己写的链接数据库的类.txt

学习积累的代码段

public partial class sqlHelper

{	
	
public static readonly string CONN_STRING = ConfigurationSettings.AppSettings["SqlConnectionString"];
	
	
public static SqlDataReader RetrieveRowsWithDataReader(string strsql)

	
{
		
SqlConnection conn = new SqlConnection(CONN_STRING);
		conn.Open();
		
		
try
		
{
			
SqlCommand cmd = new SqlCommand(strsql, conn);
			
SqlDataReader drResult = cmd.ExecuteReader(CommandBehavior.CloseConnection);
			cmd.Parameters.Clear();
			
return drResult;
		}
	
	catch
		
{
			
conn.Close();
			
throw;
		}

	}

}