دوست عزیز این کد احتمالا به دردت می خوره. فقط چون وقت ندارم نمی تونم توضیح بدم. فردا امتحان اسمبلی دارم.
Imports System.Collections
Imports System.Configuration
Imports System.Data
Imports System.Linq
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.HtmlControls
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Xml.Linq
Imports System.Data.SqlClient
Public Partial Class Default2
Inherits System.Web.UI.Page
Private connect As New connect()
' Connection class contain connection string.
Protected Sub Page_Load(sender As Object, e As EventArgs)
If Not IsPostBack Then
Bindregiondata()
End If
End Sub
Private Sub Bindregiondata()
Using con As New SqlConnection(connect.Getconnection())
con.Open()
Dim db As New testLINQinfoDataContext()
Dim regioninfo = From p In db.REGIONsOrder By p.regionnameNew With { _
Key .regionid = p.regionid, _
Key .regionname = p.regionname _
}
ddlregion.DataSource = regioninfo
ddlregion.DataTextField = "regionname"
ddlregion.DataValueField = "regionid"
ddlregion.DataBind()
ddlregion.Items.Insert(0, "--Select Regioname--")
End Using
End Sub
Protected Sub ddlregion_SelectedIndexChanged(sender As Object, e As EventArgs)
Using con As New SqlConnection(connect.Getconnection())
Dim db As New testLINQinfoDataContext()
Dim employeeinfo = From p In db.EMPLOYEEINFOsJoin c In db.COUNTRies On p.countryid = c.countryidJoin r In db.REGIONs On p.regionid = r.regionidJoin d In db.CITies On p.cityid = d.cityid Where p.regionid = Convert.ToInt32(ddlregion.SelectedItem.Value)New With { _
Key .name = p.empname, _
Key .country = c.countryname, _
Key .region = r.regionname, _
Key .city = d.cityname _
}
GridView1.DataSource = employeeinfo
GridView1.DataBind()
End Using
End Sub
End Class