hi all i'm creating a website in which i use some kind of filtering but i
failed to do it.. so help me
actually in sql server i create two table named as
DISTRICTS(DIS_CODE,DIS_NAME) and EST_DISTRICT(EST_CODE,DIS_CODE)
second table describe which establishment located in which districts
so in the main form when i clicked on some event i want some sort of
filtering ffrom above two tables
[code]
Protected Sub DRP_DEPT_SelectedIndexChanged(ByVal sender As Object, ByVal e
As System.EventArgs) Handles DRP_DEPT.SelectedIndexChanged
Dim dbcon As SqlConnection
Dim sqlcmd As SqlCommand
Dim sqlpar As SqlParameter
Dim SqlRs As SqlDataReader
Dim StrSql As String
Dim str As String
str = DRP_DEPT.SelectedIndex
'StrSql = " select * from EST_DISTRICT "
StrSql = "SELECT DIS_NAME FROM DISTRICTS WHERE DIS_CODE IN(SELECT
DIS_CODE FROM EST_DISTRICT WHERE EST_CODE = 'str')"
'StrSql = "SELECT EST_DISTRICT.EST_CODE,DISTRICTS.DIS_CODE FROM
EST_DISTRICT INNER JOIN DISTRICTS ON EST_DISTRICT.DIS_CODE='str' ORDER BY
DISTRICTS.DIS_CODE"
'StrSql = " select DISTRICTS.DIS_NAME,DISTRICTS.DIS_CODE,EST_CODE
from DISTRICTS,EST_DISTRICT WHERE EST_CODE=EST_CODE "
'StrSql = "SELECT DIS_NAME FROM DISTRICTS UNION ALL SELECT EST_CODE
FROM EST_DISTRICT WHERE EST_CODE='str'"
'StrSql=
dbcon = New
SqlConnection(ConfigurationManager.ConnectionStrings("PGConnectionString").ConnectionString)
sqlcmd = New SqlCommand(StrSql, dbcon)
sqlcmd.CommandText = StrSql
sqlcmd.CommandType = CommandType.Text
dbcon.Open()
SqlRs = sqlcmd.ExecuteReader()
DRP_DISTT.DataSource = SqlRs
DRP_DISTT.DataTextField = "DIS_NAME"
DRP_DISTT.DataValueField = "DIS_CODE"
DRP_DISTT.DataBind()
DRP_DISTT.Items.Insert(0, "ABCghtyhyt")
sqlcmd.Dispose()
dbcon.Close()
End Sub
[/code]
--
GO and LEAD from Whereever You are.
Think Big and Think Fast.
