ASP.NET

<asp:SqlDataSource ID="FAR15DataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:Cost_ModelConnectionString %>"  
        SelectCommand="SELECT Service_Tower_Code, WBS_Code, Ownertype, Compensation_Code, Compensation_Rate, Far_East_FTE, Hawaii_FTE,Mid_Atlantic_FTE, NCR_FTE, North_Midwest_FTE, Northeast_FTE, South_FTE, Southwest_FTE
FROM fn_enterprise_positions(1)"
        UpdateCommand="UPDATE  <%=Session["TableName"]%>  SET Far_East_FTE = @Far_East_FTE, Hawaii_FTE = @Hawaii_FTE, Mid_Atlantic_FTE = @Mid_Atlantic_FTE, NCR_FTE = @NCR_FTE, North_Midwest_FTE = @North_Midwest_FTE, Northeast_FTE = @Northeast_FTE, South_FTE = @South_FTE, Southwest_FTE = @Southwest_FTE
                WHERE Service_Tower_Code = @Service_Tower_Code AND WBS_Code = @WBS_Code AND Compensation_Code = @Compensation_Code AND worker_code = @worker_code">
                <UpdateParameters>
                <asp:FormParameter Name="Service_Tower_Code" FormField="Service_Tower_Code" />
                <asp:FormParameter Name="WBS_Code" FormField="WBS_Code" />
                <asp:FormParameter Name="Compensation_Code" FormField="Compensation_Code" />
                <asp:FormParameter Name="worker_code" FormField="worker_code" />
                <asp:FormParameter Name="Compensation_Rate" FormField="Compensation_Rate" />
                <asp:FormParameter Name="Far_East_FTE" FormField="Far_East_FTE" />
                <asp:FormParameter Name="Hawaii_FTE" FormField="Hawaii_FTE" />
                <asp:FormParameter Name="Mid_Atlantic_FTE" FormField="Mid_Atlantic_FTE" />
                <asp:FormParameter Name="NCR_FTE" FormField="NCR_FTE" />
                <asp:FormParameter Name="North_Midwest_FTE" FormField="North_Midwest_FTE" />
                <asp:FormParameter Name="Northeast_FTE" FormField="Northeast_FTE" />
                <asp:FormParameter Name="South_FTE" FormField="South_FTE" />
                <asp:FormParameter Name="Southwest_FTE" FormField="Southwest_FTE" />
                </UpdateParameters>
</asp:SqlDataSource>

objConnection.Open();<br />
            string query = "Select * From goods where G#=@G#";<br />
            objDataAdapter.SelectCommand.Parameters.AddWithValue("@G",Textbox.Text);<br />
            using (reader = new SqlCommand(query, objConnection).ExecuteReader())<br />
            {<br />
                if (reader.HasRows)<br />
                {<br />
                    while (reader.Read())<br />
                    {<br />
                       // Do sth<br />
                    }<br />
                }<br />
            }