Imports
System.ComponentModelImports
System.Web.UIImports
System.Web.UI.WebControlsImports
System.DrawingImports
DBHelperNSImports
System.Data.SqlClientImports
System.Data<DefaultProperty("Text"), ToolboxData("<{0}:BES_DrDownList runat=server></{0}:BES_DrDownList>")> Public Class BES_DrDownList
Inherits System.Web.UI.WebControls.DropDownList
Dim _text As String
Private mTableName As String
Private mValueField As String
Private mTextField As String
Private mWhereString As String
Private mSelValue As String
<Bindable(True), Category("Appearance"), DefaultValue("")> Property [Text]() As String
Get
Return _text
End Get
Set(ByVal Value As String)
_text = Value
End Set
End Property
Public Property [ReadOnly]() As Boolean
Get
If ViewState("ReadOnly") Is Nothing Then Return False
Return CBool(ViewState("ReadOnly"))
End Get
Set(ByVal Value As Boolean)
ViewState("ReadOnly") = Value
End Set
End Property
Public Property WhereString() As String
Get
Return mWhereString
End Get
Set(ByVal Value As String)
mWhereString = Value
End Set
End Property
Public Property SelValue() As String
Get
Return mSelValue
End Get
Set(ByVal Value As String)
mSelValue = Value
End Set
End Property
#Region "Methods"
Protected Overrides Sub Render(ByVal writer As System.Web.UI.HtmlTextWriter)
If Me.ReadOnly = False Then
MyBase.Render(writer)
Else
If Me.SelectedItem Is Nothing Then
writer.Write(String.Empty)
Else
'Me.BorderStyle = BorderStyle.Inset
'writer.AddAttribute("color", "blue")
'Me.SelValue = Me.SelectedValue
writer.Write(Me.SelectedItem.Text)
End If
End If
End Sub
Public Function InitValues()
Dim da As New SqlDataAdapter
Dim cm As New SqlCommand
Dim CNN As New SqlConnection
Dim ds As New DataSet
Dim CommText As String
Dim dr As DataRow
CNN = pf.CreateConnection(pf.getConnectionString())
cm.CommandType = CommandType.Text
CommText = "SELECT " & Me.DataValueField & ", " & Me.DataTextField & " FROM " & Me.DataMember
If mWhereString <> "" Then
CommText = CommText & " WHERE " & WhereString
End If
cm.CommandText = CommText
cm.Connection = CNN
da.SelectCommand = cm
Try
da.Fill(ds)
Catch ex As Exception
'Stop
Exit Function
End Try
dr = ds.Tables(0).NewRow
dr(0) = 0
Select Case Me.DataMember
Case "tblListEmpType", "vwSecurityOfficer"
dr(1) = "כולם"
Case "tblWeaponShanks"
dr(1) = 0
Case Else
If mTableName <> "tblMahlaka" Then
dr(1) = " "
Else
dr(1) = 0
dr(2) = " "
End If
End Select
If mTableName <> "tblSecurityAspects" And mTableName <> "tblQualifications" Then
ds.Tables(0).Rows.Add(dr)
End If
Me.DataSource = ds.Tables(0)
Me.DataBind()
Me.SelectedValue = 0
End Function
#End Region
End Class