sql function

public SqlDataReader GetReader(string connstr, string sqlstr)
        {
            SqlConnection con = new SqlConnection(connstr);
            con.Open();
            SqlCommand cmd = new SqlCommand(sqlstr, con);
            return cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }

public DataSet GetDataSet(string connstr, string sqlstr)
        {
            SqlConnection con = new SqlConnection(connstr);
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(sqlstr, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            return ds;
        }

men prøv og kig på DAAB:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp

eksempler:

http://aspnet.4guysfromrolla.com/articles/070203-1.aspx
http://aspalliance.com/688

OK ?

ja tak