ASP.NET

public void BindNotes()
{
	DataSet ds = Execute_Notes();

	string check_date = "";
	string hold_date = "";
	ph_your_note.Controls.Clear();
	Panel pnl_main = new Panel();
	pnl_main.ID = "pnl_notes_main";

	int i = 0;

	while (i < ds.Tables[0].Rows.Count)
	{
/// ••••••••••••••••••••• CREATION OF ALL CONTROL ELEMENTS ••••••••••••••••••••••••••••••••
	///creates a hidden field to house the id of the interated note (i)
		HiddenField hf = new HiddenField();
		hf.Value = ds.Tables[0].Rows[i]["Note_ID"].ToString();

	///creating a unique value for each element (i)
		notes_id = hf.Value.ToString();

	///Creates new panel to place all notes of one specific date 
		Panel pnl_date = new Panel();
		pnl_date.Attributes.Add("runat", "server");
		pnl_date.ID = "pnl_date_" + hf.Value.ToString();

	///Creates new panel to hold SOMETHING
		Panel pnl_sub = new Panel();
		pnl_sub.Attributes.Add("runat", "server");
		pnl_sub.ID = "pnl_sub_" + hf.Value.ToString();
		pnl_sub.BorderWidth = Unit.Pixel(1);
		pnl_sub.BorderStyle = BorderStyle.Solid;
		pnl_sub.BorderColor = System.Drawing.ColorTranslator.FromHtml("black");

	///create new label to display the abreviated note for refernce on the main screen
		Label lbl_abbreviated = new Label();
		lbl_abbreviated.Attributes.Add("runat", "server");
		lbl_abbreviated.ID = "lbl_abbreviated" + hf.Value.ToString();
		lbl_abbreviated.CssClass = "note_abreviated";

	///creates new label to hold the date barrier header 
		Label lbl_date = new Label();
		lbl_date.Attributes.Add("runat", "server");

	///creates new label to hold a linebreak 
		Label lbl_br = new Label();
		lbl_br.Attributes.Add("runat", "server");
		lbl_br.Text = "<br>";

	///creates new label to hold the sub panel header title
		Label lbl_edit = new Label();
		lbl_edit.Attributes.Add("runat", "server");
		lbl_edit.Text = "<center>view - update - remove <br></center>";

	///creates new label to hold non-breaking spacer elements
		Label lbl_spacer = new Label();
		lbl_spacer.Attributes.Add("runat", "server");
		lbl_spacer.Text = "&nbsp;&nbsp;&nbsp;";

	/// if the note Length is longer than 22 characters, trim and display
		if (ds.Tables[0].Rows[i]["Note"].ToString().Length > 22)
		{
			lbl_abbreviated.Text = "&nbsp;&nbsp;<img id='img_show' src='images/btn_icons/note_edit_16x.png' height='11px' />  " + ds.Tables[0].Rows[i]["Note"].ToString().Substring(0, 22) + ". . .";
		}
		else
		{
			lbl_abbreviated.Text = "&nbsp;&nbsp;<img id='img_show' src='images/btn_icons/note_edit_16x.png' height='11px' />  " + ds.Tables[0].Rows[i]["Note"].ToString();
		}
		check_date = Convert.ToDateTime(ds.Tables[0].Rows[i]["DATE_ENTERED"]).ToString("MMMM d, yyyy");
		if (check_date != hold_date)
		{
			lbl_date.Text = "&nbsp;" + check_date.ToString() + "<br>";
			lbl_date.CssClass = "note_date_seperator";
		/// ADDS the Date to the PANEL DATE CONTROL 
			pnl_date.Controls.Add(lbl_date);
		}

	///Creates a new text box to display the full text content for deletion or edit
		TextBox tb = new TextBox();
		tb.Attributes.Add("runat", "server");
		tb.TextMode = TextBoxMode.MultiLine;
		tb.Width = Unit.Pixel(175);
		tb.Height = Unit.Pixel(150);
		tb.Text = ds.Tables[0].Rows[i]["Note"].ToString();
		tb.ID = "tb_note_" + hf.Value.ToString();
		tb.CssClass = "note_tb_format";

	///Creates image buttons for Edit and Delete events
			ImageButton img_btn_update_edit = new ImageButton();
		///Creates the OnClick Event Handler
			img_btn_update_edit.Click += new ImageClickEventHandler(img_btn_update_note_Click);
			img_btn_update_edit.ImageUrl = "images/btn_icons/note_accept_16x.png";
			img_btn_update_edit.Attributes.Add("runat", "server");
			img_btn_update_edit.ID = "note_" + hf.Value.ToString();
			img_btn_update_edit.CssClass = "note_panel_icons";
			img_btn_update_edit.ToolTip = hf.Value.ToString();
			
			AttributeCollection note = img_btn_update_edit.Attributes;

			ImageButton img_btn_remove = new ImageButton();
			img_btn_remove.ImageUrl = "images/btn_icons/note_remove_16x.png";
			img_btn_remove.CssClass = "note_panel_icons";

	///create hover pop up that displays sub panel with editing and removal options
		//int hover_popup = lbl_abbreviated.Text.Length;
		HoverMenuExtender hvm_note = new HoverMenuExtender();
		hvm_note.TargetControlID += lbl_abbreviated.ID.ToString();
		hvm_note.PopupControlID += pnl_sub.ID.ToString();
		hvm_note.ID = "hvm_note_" + hf.Value.ToString();
		hvm_note.OffsetX = 20;
		hvm_note.PopDelay = 500;


/// •••••••••••••••• FILL ALL CONTROLS ••••••••••••••••••••••••••••••
	/// fill DATE PANEL that show date of notes listed below (1st fill)
		pnl_date.Controls.Add(lbl_abbreviated);
		pnl_date.Controls.Add(hvm_note);

	///fill sub panel whith text and image buttons for administration. (2nd fill)
		// adds sub panel header | Textbox with Note | hard line break | Update Image Button | Delete Image Button 
		pnl_sub.Controls.Add(lbl_edit);
		pnl_sub.Controls.Add(tb);
		pnl_sub.Controls.Add(lbl_br);
		pnl_sub.Controls.Add(img_btn_update_edit);
		pnl_sub.Controls.Add(img_btn_remove);
		pnl_sub.CssClass = "note_sub_panel";

	///fill hover controls with sub panel that will be displayed (3rd fill)
		hvm_note.Controls.Add(pnl_sub);

	///fill 
		ph_your_note.Controls.Add(pnl_date);
		hold_date = check_date;
		i++;

	}
	/// fills 
	 ph_your_note.Controls.Add(pnl_main);

		}

/// THIS IS THE AREA THAT I NEED TO DETERMINE THE VALUE OF THE TEXBOX
/// code in brackets is wrong and is one of my feeble attempts to return the value
protected void img_btn_update_note_Click(object sender, ImageClickEventArgs e)
	{
		notes_cmd = "update";
		string ctrl_name = "tb_note_" + notes_id.ToString();
		if (ctrl_name != String.Empty)
		{
			
		}
		else
		{
		 lbl_create_note.Text = "failed"; 
		}
	 BindNotes();
	}

<asp:CommandField ShowEditButton="True" ValidationGroup="valGrp" CancelText="Cxl" EditText="Edit" UpdateText="Upd" />
<asp:BoundField DataField="roomID" />                       
<asp:TemplateField HeaderText="RoomName">
<EditItemTemplate>
<asp:TextBox ID="txtRoom" Columns="10" runat="server" SkinID="txtSm" Text='<%# Bind("roomname") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblRoom" runat="server" Text='<%# Bind("roomName") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="btnAdd"  runat="server" skinID="btnGo" Text="Add" CommandName="Insert" />
<asp:TextBox ID="txtRoomAdd" Columns="10" runat="server" SkinID="txtSm" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Org">
<EditItemTemplate>
<asp:DropDownList ID="orgDDL" runat="server" SkinID="ddl" DataSourceID="orgDS"
DataTextField="org" DataValueField="orgID" SelectedValue='<%# Bind("orgID") %>'>
</asp:DropDownList><asp:SqlDataSource ID="orgDS" runat="server" ConnectionString="<%$ ConnectionStrings:Str  %>"
SelectCommand="select statement"></asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblOrg" runat="server" Text='<%# Bind("org") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="orgDDLAdd" runat="server" SkinID="ddl" DataSourceID="orgAddDS2"
DataTextField="org" DataValueField="orgID">
</asp:DropDownList><asp:SqlDataSource ID="orgAddDS2" runat="server" ConnectionString="<%$ ConnectionStrings:Str  %>"
SelectCommand="select statement">
</asp:SqlDataSource>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Type">
<EditItemTemplate>
<asp:DropDownList ID="typeDDL" runat="server" SkinID="ddl" DataSourceID="typeDS"
DataTextField="roomType" DataValueField="roomTypeID" SelectedValue='<%# Bind("roomTypeID") %>'>
</asp:DropDownList><asp:SqlDataSource ID="typeDS" runat="server" ConnectionString="<%$ ConnectionStrings:Str  %>"
SelectCommand="select statement">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblroomType" runat="server" Text='<%# Bind("roomType") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="typeDDLAdd" runat="server" SkinID="ddl" DataSourceID="addDS3"
DataTextField="roomType" DataValueField="roomTypeID">
</asp:DropDownList><asp:SqlDataSource ID="addDS3" runat="server" ConnectionString="<%$ ConnectionStrings:Str  %>"
SelectCommand="select statement">
</asp:SqlDataSource>
</FooterTemplate>
</asp:TemplateField>                                    
<asp:TemplateField HeaderText="DialOut">
<EditItemTemplate><asp:CheckBox ID="chkOutEdit" runat="server" checked='<%# Bind("dialOut") %>' /></EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkOut" runat="server" checked='<%# Bind("dialOut") %>' Enabled="false" /></ItemTemplate>
<FooterTemplate><asp:CheckBox ID="chkOutAdd" runat="server" /></FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DialIn">
<EditItemTemplate><asp:CheckBox ID="chkInEdit" runat="server" checked='<%# Bind("dialIn") %>' /></EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkIn" runat="server" checked='<%# Bind("dialIn") %>' Enabled="false" /></ItemTemplate>
<FooterTemplate><asp:CheckBox ID="chkInAdd" runat="server" /></FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Webinar">
<EditItemTemplate><asp:CheckBox ID="chkWebEdit" runat="server" checked='<%# Bind("webinarCapable") %>' /></EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkWeb" runat="server" checked='<%# Bind("webinarCapable") %>' Enabled="false" /></ItemTemplate>
<FooterTemplate><asp:CheckBox ID="chkWebAdd" runat="server" /></FooterTemplate>
</asp:TemplateField>

UpdateCommand="update myTable set roomname=@roomName, orgID=@orgID, roomTypeID=@roomTypeID, dialOut=@dialout, dialIn=@dialin, webinarCapable=@web where roomID = @roomID" 
                >
                <UpdateParameters>
                    <asp:Parameter Name="roomName" Type="String" />
                    <asp:Parameter Name="orgID" Type="Int32" />
                    <asp:Parameter Name="roomTypeID" Type="Int32" />
                    <asp:Parameter Name="dialout" Type="Byte" />
                    <asp:Parameter Name="dialin" Type="Byte" />
                    <asp:Parameter Name="web" Type="Byte"  />

                </UpdateParameters>

TABLE [dbo].[myTable](
	[roomID] [int] IDENTITY(1,1) NOT NULL,
	[roomName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[orgID] [int] NULL,
	[roomTypeID] [int] NULL,
	[dialOut] [bit] NULL CONSTRAINT [DF_xTblRoom_dialOut]  DEFAULT ((0)),
	[dialIn] [bit] NULL CONSTRAINT [DF_xTblRoom_dialIn]  DEFAULT ((0)),
	[webinarCapable] [bit] NULL CONSTRAINT [DF_xTblRoom_webinarCapable]  DEFAULT ((0))

 string str = DropDownList5.SelectedItem.Value.ToString();
        string str1 = DropDownList6.SelectedItem.Value.ToString();
        string str2 = DropDownList7.SelectedItem.Value.ToString();
        string final = str1 + "-" + str + "-" + str2;

cmd.Parameters.Add("@startdate", SqlDbType.SmallDateTime.ToString()).Value = final;