ExecuteDataSet method of DbCommand will returns the multiple rows from the table.
Code Behind:
Database db = DatabaseFactory.CreateDatabase();
string sql = “SELECT * From BankDetails”;
DbCommand cmd = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(cmd);
GridView1.DataSource = ds;
GridView1.DataBind();
My web.config was:
I simply added this line between ConfigSections tag of Configuration.
<section name=”dataConfiguration” type=”Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data” />
Then connectionstring tag below
<connectionStrings>
<add name=”MyFirstTest”
providerName=”System.Data.SqlClient”
connectionString=”Data Source=(local);database=BankAccount;user id=sa;pwd=murugesan”/>
</connectionStrings>
<dataConfiguration defaultDatabase=”MyFirstTest”/>
