Krivahn Doss

Krivahn Doss

  • NA
  • 58
  • 0

SQLDependency AND DAAB Data Access Application Block

Nov 16 2007 4:56 AM
How do I add SQLDependency in an DAAB.

I get an error with this !!
//SqlDependency.Start("MyConnection");

This is my code.
public DataSet GetPercentageByID(string dispID)
        {
            //SqlDependency.Start("MyConnection");

            Database sqldb = DatabaseFactory.CreateDatabase("MyConnection");
            DataSet ds = sqldb.ExecuteDataSet("spDispAmountPercent", new object[] { dispID });
            return ds;
        }