ASP.NET

<br />
<div style="text-align: center; background-color: lightgrey;"><br />
		<br /><br />
		<br />
		<asp:checkboxlist id="chkFocusSearch" runat="server" autopostback="false" repeatdirection="Horizontal" xmlns:asp="#unknown"><br />
								DataValueField="tid" DataTextField="Type_" Width="360px" >            <br />
		</asp:checkboxlist><br />
		<br />
		<asp:button id="btnSlctAll" runat="server" onclick="btnSlctAll_Click" text="Selet All" xmlns:asp="#unknown"><br />
						Width="114px" /> <br />
						<br />
		<asp:button id="btnSlctNone" runat="server" text="Select None"><br />
						Width="114px" OnClick="btnSlctNone_Click" /> <br />
		<br />
		<asp:button id="btnRefresh" runat="server" text="Refresh View" onclick="RefreshInv" /> <br />
		<br />
		<asp:datagrid id="mysqlInvGrid" runat="server" cellpadding="4" forecolor="#333333" showfooter="True" bordercolor="Black"><br />
                          OnItemCommand="Update"<br />
                          AutoGenerateColumns ="False" BorderWidth="8px" CellSpacing="3" style="border-right: black thin solid; border-top: black thin solid; border-left: black thin solid; border-bottom: black thin solid" Height="299px" Width="360px"><br />
      			<br />
				<columns><br />
					<asp:boundcolumn datafield="prodid" visible="false" /><br />
					<asp:boundcolumn datafield="item" headertext="Item" /><br />
					<br />
					<asp:templatecolumn visible="False"><br />
						<itemtemplate><br />
							<asp:label id="aspProdID" runat="server" text="<%# DataBinder.Eval(Container.DataItem, "prodid") %>" /><br />
						</itemtemplate>	<br />
					</asp:templatecolumn><br />
					<br />
									<br />
					<asp:templatecolumn headertext="Quantity"><br />
					<br />
						<footertemplate><br />
							<asp:button id="btnUpdate" runat="server" text="Update" /><br />
						</footertemplate><br />
					<br />
						<itemtemplate><br />
							<asp:textbox id="aspAmount" runat="server" columns="5" text="<%# Container.DataItem("amount") %>" /><br />
						</itemtemplate><br />
					</asp:templatecolumn><br />
				<br />
					<asp:boundcolumn datafield="measure" headertext="Measurement" /><br />
					<br />
									<br />
				</columns><br />
</asp:datagrid></asp:button></asp:button></div>

<br />
Sub Update(ByVal Sender As Object, ByVal e As DataGridCommandEventArgs)<br />
		Dim dgI As DataGridItem<br />
		Dim strSql As String<br />
		Dim sqlCmd As New MySqlCommand<br />
		<br />
		sqlCmd = New MySqlCommand()<br />
		mysqlConn = DBConnect.Connect<br />
		sqlCmd.Connection = mysqlConn<br />
		<br />
		Try<br />
		<br />
			For Each dgI In mysqlInvGrid.Items<br />
				'get the Prod ID and the new quantity<br />
				Dim strProdID As String = CType(e.Item.FindControl("aspProdID"), Label).Text<br />
				Dim strQuantity As String = CType(e.Item.FindControl("aspAmount"), TextBox).Text<br />
				<br />
				Dim intProdID As Integer = CInt(strProdID)<br />
				Dim intQuantity As Integer = CInt(strQuantity)<br />
			<br />
				'Update the DB with the information we have gathered.<br />
			<br />
				strSql = "update Inventory set quantity = " & intQuantity & " where prodID = " & intProdID<br />
			<br />
				sqlCmd = New MySqlCommand(strSql, mysqlConn)<br />
				sqlCmd.ExecuteNonQuery()<br />
						<br />
			Next<br />
		Catch ex As MySqlException<br />
			MsgBox("Insert failed", MsgBoxStyle.Exclamation, "Insert Status")<br />
			MsgBox("Error returned was '" & ex.Message, MsgBoxStyle.Information, "Error Message")<br />
			MsgBox("SQL command was: '" & strSql)<br />
        <br />
        <br />
		Catch ex As Exception<br />
            <br />
			MsgBox("Insert failed", MsgBoxStyle.Exclamation, "Insert Status")<br />
			MsgBox("Error returned was '" & ex.Message, MsgBoxStyle.Information, "Error Message")<br />
<br />
		Finally<br />
        <br />
			mysqlConn.Close()<br />
			BindGrid()<br />
			<br />
		End Try<br />
<br />