public void BindHub()
{
BLLCollection <Hub_mst> col = new BLLCollection <Hub_mst>();
col = objHub.Get_All();
for (int i = 0; i < col.Count; i++)
{
for (int j = i; j < col.Count; j++)
{
if (String.Compare(col[i].Hubname, col[j].Hubname) > 0)
{
Hub_mst obj = new Hub_mst();
obj = col[i];
col[i] = col[j];
col[j] = obj;
}
}
}
drpHub.DataTextField = "HubName";
drpHub.DataValueField = "Hubid";
drpHub.DataSource = col;
drpHub.DataBind();
////////////////////////////////////////////////////// //change done by meenakshi 12 july 2102
ListItem item = new ListItem();
//item.Text = "--------------Select--------------";
item.Text = "All";
item.Value = "0";
drpHub.Items.Add(item);
drpHub.SelectedValue = "0";
//item.Value = "0";
//drpHub.Items.Add(item);
//drpHub.SelectedValue = "0";
/////////////////////////////////////////////////////////////end
}
public void BindHub()
{
BLLCollection<Hub_mst> col = new BLLCollection<Hub_mst>();
col = objHub.Get_All();
for (int i = 0; i < col.Count; i++)
{
for (int j = i; j < col.Count; j++)
{
if (String.Compare(col[i].Hubname, col[j].Hubname) > 0)
{
Hub_mst obj = new Hub_mst();
obj = col[i];
col[i] = col[j];
col[j] = obj;
}
}
}
drpHub.DataTextField = "HubName";
drpHub.DataValueField = "Hubid";
drpHub.DataSource = col;
drpHub.DataBind();
////////////////////////////////////////////////////// //change done by meenakshi 12 july 2102
ListItem item = new ListItem();
//item.Text = "--------------Select--------------";
item.Text = "All";
item.Value = "0";
drpHub.Items.Add(item);
drpHub.SelectedValue = "0";
//item.Value = "0";
//drpHub.Items.Add(item);
//drpHub.SelectedValue = "0";
/////////////////////////////////////////////////////////////end
}
//add hub lalit
public int Insert_Hub_mst(Hub_mst objHub)
{
return (int)ExecuteNonQuery(Sp_Hub_Insert, new object[] { objHub.Hubname, objHub.Hubid, objHub.Description });
}
public CollectionBase GenerateHub_mstCollection(ref IDataReader returnData)
{
BLLCollection<Hub_mst> col = new BLLCollection<Hub_mst>();
while (returnData.Read())
{
Hub_mst obj = new Hub_mst();
obj.Hubid = (int)returnData["Hubid"];
obj.Hubname = (string)returnData["Hubname"];
obj.Description = (string)returnData["Hubdescription"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
