G
Guest
I had a windows form project that had a functions module that could control
objects on the referenced main form. How would I do the same with a web
project using a web form? See my windows form example, and let me know what I
must do to get this to work on a web form.
Imports System.Data
Imports System.Data.OleDb
Imports CrystalDecisions.CrystalReports.Engine
Imports System.Windows.Forms
Module ProcessFunctions
Public loading As Boolean = True
Dim SQadapterTime As New SqlClient.SqlDataAdapter
Dim SQadapterPhase As New SqlClient.SqlDataAdapter
Dim SQadapterTask As New SqlClient.SqlDataAdapter
Dim SQadapterActivity As New SqlClient.SqlDataAdapter
Dim SQadapterCLient As New SqlClient.SqlDataAdapter
Dim SQadapterMatter As New SqlClient.SqlDataAdapter
Dim SQadApterGetTime As New SqlClient.SqlDataAdapter
Dim SQadApterGetParams As New SqlClient.SqlDataAdapter
Dim SQLTime As New SqlClient.SqlCommand
Dim SQLPhase As New SqlClient.SqlCommand
Dim SQLTask As New SqlClient.SqlCommand
Dim SQLActivity As New SqlClient.SqlCommand
Dim SQLClient As New SqlClient.SqlCommand
Dim SQLMatter As New SqlClient.SqlCommand
Dim SQLGetime As New SQLClient.SqlCommand
Dim SQLGetParams As New SQLClient.SqlCommand
'Dim dreader As SqlClient.SqlDataReader
Dim dtTime As New DataTable
Dim dtPhase As New DataTable
Dim dtTask As New DataTable
Dim dtActivity As New DataTable
Dim dtCLient As New DataTable
Dim dtMatter As New DataTable
Public Sub LoadAllFormData(ByVal MainF As FrmMain, ByVal DataLoadType As
Integer)
Dim objectDBConnect As New Exception("Unable to connect to SQL
server Rc0101.")
Select Case DataLoadType
Case 1
SQLTime.CommandText = "SELECT Timekeeper, EmpName FROM
V_LiTimekeeper UNION SELECT 'L0', '-ALL-' FROM V_LiTimekeeper ORDER BY
EmpName"
SQLPhase.CommandText = "SELECT PhaseCode, PhaseName,
PhaseCode + ' - ' + PhaseName AS PhaseComb FROM LitPhase order by phasename"
SQLTask.CommandText = "SELECT PhaseCode,TaskCode, TaskName,
TaskCode + ' - ' + TaskName AS TaskComb FROM LitTask UNION SELECT
'9999','L0','-All-', '-ALL-' FROM Littask ORDER BY taskName"
SQLActivity.CommandText = "SELECT activity_code,
activity_desc, activity_code + ' - ' + activity_desc AS ActDrp FROM
LitActivity UNION SELECT 'L0','-All-', '-ALL-' FROM Littask ORDER BY
activity_desc"
SQLClient.CommandText = "SELECT CLIENT_CODE, CLIENT_NAME,
CLIENT_NAME + ' - ' + CLIENT_CODE AS CLientDrp FROM LitClients ORDER BY
CLIENT_NAME"
SQLMatter.CommandText = "SELECT CLIENT_CODE, MATTER_CODE,
MATTER_NAME, MATTER_NAME + ' -' + MATTER_CODE AS MatterDrp FROM LitMatters
UNION SELECT '99','L0',' -ALL-',' -ALL-' FROM Littask ORDER BY MATTER_NAME"
SQLTime.Connection = LitDatabase
SQLPhase.Connection = LitDatabase
SQLTask.Connection = LitDatabase
SQLActivity.Connection = LitDatabase
SQLClient.Connection = LitDatabase
SQLMatter.Connection = LitDatabase
SQadapterTime.SelectCommand = SQLTime
SQadapterPhase.SelectCommand = SQLPhase
SQadapterTask.SelectCommand = SQLTask
SQadapterActivity.SelectCommand = SQLActivity
SQadapterCLient.SelectCommand = SQLClient
SQadapterMatter.SelectCommand = SQLMatter
Try
' Load Timekeeper Dropdowns
SQadapterTime.Fill(dtTime).ToString()
MainF.DrpTimekeeper().DataSource = dtTime
MainF.DrpTimekeeper().DisplayMember =
dtTime.Columns(1).ToString
MainF.DrpTimekeeper().ValueMember =
dtTime.Columns(0).ToString
' Load Phase Dropdowns
SQadapterPhase.Fill(dtPhase).ToString()
MainF.drpPhase().DataSource = dtPhase
MainF.drpPhase().DisplayMember =
dtPhase.Columns(2).ToString
MainF.drpPhase().ValueMember = dtPhase.Columns(0).ToString
' Load Task Dropdowns
SQadapterTask.Fill(dtTask).ToString()
dtTask.DefaultView.RowFilter = "PhaseCode = '" &
MainF.drpPhase().SelectedValue & "' OR TaskComb= '-All-'"
MainF.drpTask().DataSource = dtTask
MainF.drpTask.SelectedIndex = 0
MainF.drpTask.DisplayMember = dtTask.Columns(3).ToString
MainF.drpTask.ValueMember = dtTask.Columns(1).ToString
' Load Activity Dropdowns
SQadapterActivity.Fill(dtActivity).ToString()
MainF.drpActivity().DataSource = dtActivity
MainF.drpActivity().DisplayMember =
dtActivity.Columns(2).ToString
MainF.drpActivity().ValueMember =
dtActivity.Columns(0).ToString
' Load Client Dropdowns
SQadapterCLient.Fill(dtCLient).ToString()
MainF.drpClient.DataSource = dtCLient
MainF.drpClient.DisplayMember =
dtCLient.Columns(2).ToString
MainF.drpClient.ValueMember = dtCLient.Columns(0).ToString
' Load Matter Dropdowns
SQadapterMatter.Fill(dtMatter).ToString()
dtMatter.DefaultView.RowFilter = "Client_Code = '" &
MainF.drpClient.SelectedValue & "' OR MatterDrp= ' -All-'"
MainF.drpMatter().DataSource = dtMatter
MainF.drpMatter.SelectedIndex = 0
MainF.drpMatter.DisplayMember =
dtMatter.Columns(3).ToString
MainF.drpMatter.ValueMember = dtMatter.Columns(1).ToString
Catch objectDataFill As Exception
'Throw objectDBConnect
MsgBox(objectDataFill.Message)
End Try
loading = False
MainF.RDActivity.Checked = True
Case 2
If loading = False Then
dtTask.DefaultView.RowFilter = "PhaseCode = '" &
MainF.drpPhase().SelectedValue & "' OR TaskComb= '-All-'"
MainF.drpTask().DataSource = dtTask
MainF.drpTask.SelectedIndex = 0
MainF.drpTask.DisplayMember = dtTask.Columns(3).ToString
MainF.drpTask.ValueMember = dtTask.Columns(1).ToString
MainF.drpTask().Enabled = True
End If
Case 3
If loading = False Then
dtMatter.DefaultView.RowFilter = "Client_Code = '" &
MainF.drpClient.SelectedValue & "' OR MatterDrp= ' -All-'"
MainF.drpMatter().DataSource = dtMatter
MainF.drpMatter.SelectedIndex = 0
MainF.drpMatter.DisplayMember =
dtMatter.Columns(3).ToString
MainF.drpMatter.ValueMember = dtMatter.Columns(1).ToString
MainF.drpMatter().Enabled = True
End If
End Select
'
End Sub
objects on the referenced main form. How would I do the same with a web
project using a web form? See my windows form example, and let me know what I
must do to get this to work on a web form.
Imports System.Data
Imports System.Data.OleDb
Imports CrystalDecisions.CrystalReports.Engine
Imports System.Windows.Forms
Module ProcessFunctions
Public loading As Boolean = True
Dim SQadapterTime As New SqlClient.SqlDataAdapter
Dim SQadapterPhase As New SqlClient.SqlDataAdapter
Dim SQadapterTask As New SqlClient.SqlDataAdapter
Dim SQadapterActivity As New SqlClient.SqlDataAdapter
Dim SQadapterCLient As New SqlClient.SqlDataAdapter
Dim SQadapterMatter As New SqlClient.SqlDataAdapter
Dim SQadApterGetTime As New SqlClient.SqlDataAdapter
Dim SQadApterGetParams As New SqlClient.SqlDataAdapter
Dim SQLTime As New SqlClient.SqlCommand
Dim SQLPhase As New SqlClient.SqlCommand
Dim SQLTask As New SqlClient.SqlCommand
Dim SQLActivity As New SqlClient.SqlCommand
Dim SQLClient As New SqlClient.SqlCommand
Dim SQLMatter As New SqlClient.SqlCommand
Dim SQLGetime As New SQLClient.SqlCommand
Dim SQLGetParams As New SQLClient.SqlCommand
'Dim dreader As SqlClient.SqlDataReader
Dim dtTime As New DataTable
Dim dtPhase As New DataTable
Dim dtTask As New DataTable
Dim dtActivity As New DataTable
Dim dtCLient As New DataTable
Dim dtMatter As New DataTable
Public Sub LoadAllFormData(ByVal MainF As FrmMain, ByVal DataLoadType As
Integer)
Dim objectDBConnect As New Exception("Unable to connect to SQL
server Rc0101.")
Select Case DataLoadType
Case 1
SQLTime.CommandText = "SELECT Timekeeper, EmpName FROM
V_LiTimekeeper UNION SELECT 'L0', '-ALL-' FROM V_LiTimekeeper ORDER BY
EmpName"
SQLPhase.CommandText = "SELECT PhaseCode, PhaseName,
PhaseCode + ' - ' + PhaseName AS PhaseComb FROM LitPhase order by phasename"
SQLTask.CommandText = "SELECT PhaseCode,TaskCode, TaskName,
TaskCode + ' - ' + TaskName AS TaskComb FROM LitTask UNION SELECT
'9999','L0','-All-', '-ALL-' FROM Littask ORDER BY taskName"
SQLActivity.CommandText = "SELECT activity_code,
activity_desc, activity_code + ' - ' + activity_desc AS ActDrp FROM
LitActivity UNION SELECT 'L0','-All-', '-ALL-' FROM Littask ORDER BY
activity_desc"
SQLClient.CommandText = "SELECT CLIENT_CODE, CLIENT_NAME,
CLIENT_NAME + ' - ' + CLIENT_CODE AS CLientDrp FROM LitClients ORDER BY
CLIENT_NAME"
SQLMatter.CommandText = "SELECT CLIENT_CODE, MATTER_CODE,
MATTER_NAME, MATTER_NAME + ' -' + MATTER_CODE AS MatterDrp FROM LitMatters
UNION SELECT '99','L0',' -ALL-',' -ALL-' FROM Littask ORDER BY MATTER_NAME"
SQLTime.Connection = LitDatabase
SQLPhase.Connection = LitDatabase
SQLTask.Connection = LitDatabase
SQLActivity.Connection = LitDatabase
SQLClient.Connection = LitDatabase
SQLMatter.Connection = LitDatabase
SQadapterTime.SelectCommand = SQLTime
SQadapterPhase.SelectCommand = SQLPhase
SQadapterTask.SelectCommand = SQLTask
SQadapterActivity.SelectCommand = SQLActivity
SQadapterCLient.SelectCommand = SQLClient
SQadapterMatter.SelectCommand = SQLMatter
Try
' Load Timekeeper Dropdowns
SQadapterTime.Fill(dtTime).ToString()
MainF.DrpTimekeeper().DataSource = dtTime
MainF.DrpTimekeeper().DisplayMember =
dtTime.Columns(1).ToString
MainF.DrpTimekeeper().ValueMember =
dtTime.Columns(0).ToString
' Load Phase Dropdowns
SQadapterPhase.Fill(dtPhase).ToString()
MainF.drpPhase().DataSource = dtPhase
MainF.drpPhase().DisplayMember =
dtPhase.Columns(2).ToString
MainF.drpPhase().ValueMember = dtPhase.Columns(0).ToString
' Load Task Dropdowns
SQadapterTask.Fill(dtTask).ToString()
dtTask.DefaultView.RowFilter = "PhaseCode = '" &
MainF.drpPhase().SelectedValue & "' OR TaskComb= '-All-'"
MainF.drpTask().DataSource = dtTask
MainF.drpTask.SelectedIndex = 0
MainF.drpTask.DisplayMember = dtTask.Columns(3).ToString
MainF.drpTask.ValueMember = dtTask.Columns(1).ToString
' Load Activity Dropdowns
SQadapterActivity.Fill(dtActivity).ToString()
MainF.drpActivity().DataSource = dtActivity
MainF.drpActivity().DisplayMember =
dtActivity.Columns(2).ToString
MainF.drpActivity().ValueMember =
dtActivity.Columns(0).ToString
' Load Client Dropdowns
SQadapterCLient.Fill(dtCLient).ToString()
MainF.drpClient.DataSource = dtCLient
MainF.drpClient.DisplayMember =
dtCLient.Columns(2).ToString
MainF.drpClient.ValueMember = dtCLient.Columns(0).ToString
' Load Matter Dropdowns
SQadapterMatter.Fill(dtMatter).ToString()
dtMatter.DefaultView.RowFilter = "Client_Code = '" &
MainF.drpClient.SelectedValue & "' OR MatterDrp= ' -All-'"
MainF.drpMatter().DataSource = dtMatter
MainF.drpMatter.SelectedIndex = 0
MainF.drpMatter.DisplayMember =
dtMatter.Columns(3).ToString
MainF.drpMatter.ValueMember = dtMatter.Columns(1).ToString
Catch objectDataFill As Exception
'Throw objectDBConnect
MsgBox(objectDataFill.Message)
End Try
loading = False
MainF.RDActivity.Checked = True
Case 2
If loading = False Then
dtTask.DefaultView.RowFilter = "PhaseCode = '" &
MainF.drpPhase().SelectedValue & "' OR TaskComb= '-All-'"
MainF.drpTask().DataSource = dtTask
MainF.drpTask.SelectedIndex = 0
MainF.drpTask.DisplayMember = dtTask.Columns(3).ToString
MainF.drpTask.ValueMember = dtTask.Columns(1).ToString
MainF.drpTask().Enabled = True
End If
Case 3
If loading = False Then
dtMatter.DefaultView.RowFilter = "Client_Code = '" &
MainF.drpClient.SelectedValue & "' OR MatterDrp= ' -All-'"
MainF.drpMatter().DataSource = dtMatter
MainF.drpMatter.SelectedIndex = 0
MainF.drpMatter.DisplayMember =
dtMatter.Columns(3).ToString
MainF.drpMatter.ValueMember = dtMatter.Columns(1).ToString
MainF.drpMatter().Enabled = True
End If
End Select
'
End Sub