Archive for July, 2009

DAAB – using stored Procedure

06/07/2009

Database db = DatabaseFactory.CreateDatabase();
 DbCommand cmd = db.GetStoredProcCommand(“EntLibProc”);
DataSet ds = db.ExecuteDataSet(cmd);
GridView1.DataSource = ds; GridView1.DataBind();

My webconfig setting:

<connectionStrings>
<
add name=MyFirstTest providerName=System.Data.SqlClient connectionString=Data Source=MURUGESA-B9EA7D\SQLEXPRESS;Initial Catalog=Murugesan;Integrated Security=True/>
</
connectionStrings>
<
dataConfiguration defaultDatabase=MyFirstTest/>

 

under config section of configuration tag,add this

<section name=dataConfiguration type=Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data/>