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; }