3-Tier

[pichukakiran]

public List<clsData.clsSchedulesData> GetProvidersList()
{
List<clsData.clsSchedulesData> Listproviders = new List<clsData.clsSchedulesData>();
DataSet ds = new DataSet();
string str = "select OrderId,CustomerId,EmployeeId,ShipName,ShipAddress ,ShipCity,ShipRegion,ShipCountry from Orders";
SqlDataAdapter da = new SqlDataAdapter(str,objHelper.GetConnection());
da.Fill(ds, "Orders");
if (ds.Tables["Orders"].Rows.Count > 0)
{
foreach(DataRow dr in ds.Tables["Orders"].Rows)
{
Listproviders.Add(dr["OrderId"].ToString());
//Listproviders.Add(dr["OrderId"].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][0].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][1].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][2].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][3].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][4].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][5].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][6].ToString());
//Listproviders.Add(ds.Tables["Orders"].Rows[0][7].ToString());
}
}
return Listproviders;
}



I am getting error in this.May i know the reason?Can anybody help me

[kenobewan]

What line and error are you receiving? I don't see this.May ;).