ASP.NET

<asp:TemplateField HeaderText="Instructor">
            <EditItemTemplate>
                <asp:DropDownList ID="ddlInstructors" runat="server" AppendDataBoundItems="True" DataSourceID="SubjectDataSource"
                    DataTextField="InstructorName" DataValueField="InstructorId">
                </asp:DropDownList>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="lblInstructors" runat="server" Text='<% #Bind("InstructorName") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>

          <asp:SqlDataSource ID="sqlDataSourceloc" runat="server" 
    ConnectionString="<%$ ConnectionStrings:DBConn %>" 
    SelectCommand="SELECT locationId, Location FROM Locations order by location asc"></asp:SqlDataSource>
       <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:DBConnectionString %>" 
     UpdateCommand = "Update tblCourseInstructor Set CourseId = @CourseId where (CourseId =@CourseId) Update tblCourseInstructor set InstructorId=@InstructorId where (instructorId=@instructorId and courseId = @courseId)"
     SelectCommand="select l.locationid,c.CourseId, i.instructorId,CourseName, i.instructorname, dbo.fnFormatDate(t.trainingDates, 'MON/DD/YYYY') trainingDates, t.trainingTime,CourseDescription from Courses c, tblLocations l, TrainingDates t, Instructors i, CourseInstructor ci where l.locationid = c.locationid and c.dateId = t.dateId and i.instructorid =  ci.instructorId and c.courseid=ci.courseid and YEAR(t.trainingDates) = YEAR(getDate())"
                   FilterExpression="LocationId = '{0}'" >
<FilterParameters>
 <asp:ControlParameter ControlID="ddlLocation" Name="LocationId" PropertyName="SelectedValue" Type="Int32" />
 </FilterParameters>              
    <UpdateParameters>
        <asp:Parameter Name="CourseId" Type="Int32" />
        <asp:Parameter Name="instructorId" Type="Int32" />
    </UpdateParameters>
   </asp:SqlDataSource>
   <asp:SqlDataSource ID="SubjectDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DBConn %>"
    SelectCommand="SELECT instructorId, InstructorName FROM dbo.Instructors order by InstructorName">
   </asp:SqlDataSource>   

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles GridView1.RowUpdating
        Dim ddAssigned As DropDownList = DirectCast(GridView1.Rows(e.RowIndex).FindControl("ddlInstructors"), DropDownList)
        e.NewValues("instructorId") = ddAssigned.SelectedValue
        SubjectDataSource.DataBind()

    End Sub

function checkEmail() {

    var email = document.getElementById('txtEmail');
    var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;

    if (!filter.test(email.value)) {
    alert('Please provide a valid email address');
    email.focus;
    return false;
 }
}</script>

<input type='text' id='txtEmail'/>
<input type='submit' name='submit' onclick='Javascript:checkEmail();'/>

<asp:Button ID="BtnSubmit" runat="server" onclick="Button1_Click" Text="Register Now" />

public static class QueryExtension
{
    public static Task<IEnumerable<TResult>>; QueryAsync<TResult>(this DataServiceQuery<TResult> query)
    {
        return Task<IEnumerable<TResult>>.Factory.FromAsync(query.BeginExecute, query.EndExecute, null);
    }
}

USE [TyreSannerSQL]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[SearchResults] @Width int, @Profile int, @Diamete int, @Speed nvarchar, @CustPostcode nvarchar (50)

As
Begin

SELECT     Suppliers.SupplierID, Suppliers.SupplierName, Product.Width, Product.Profile, Product.Diamete, Product.Speed, Product.Brand, Product.TyreModel, Product.TyreType, 
                      Product.RollingResistance, Product.WetGrip, Product.NoiseEmission, Product.ProductUnitSalePrice

FROM         Product INNER JOIN
                      Suppliers ON Product.SupplierFK = Suppliers.SupplierID
                      
               WHERE  Width = @Width 
				and Product.Profile = @Profile 
				and Product.Diamete = @Diamete 
				and (Product.Speed = @Speed 
				or COALESCE(@Speed,'') = '') 
				and Suppliers.SupplierDistrict = LEFT(@CustPostcode,2)     
				ORDER BY Product.ProductUnitSalePrice ASC
                      
                      
                      
                      
 End