Can you write a vb.net desktop application in visual studio which looks and works like…
- User
Can you write a vb.net desktop application in visual studio which looks and works like MS Project. So that I can add a few more functionality into the application and automate some of the processes as required. MS Access may be used as the database. Maybe later we can migrate to SQL Server for multi-user interface, but as of now lets use MS Access as database.
- Assistant
Okay, this is a fairly ambitious request, as MS Project is a very complex application. Replicating all its features would take a team of developers months or years.
However, I can provide you with a solid foundation for a VB.NET desktop application that mimics some core functionalities of MS Project:
- Task Management: Add, edit, delete tasks.
- Task Properties: Task Name, Start Date, End Date, Duration, Percentage Complete, Predecessors.
- Basic Gantt Chart View: A visual representation of tasks over time.
- MS Access Database: For persistent storage.
Project Setup and Database Design
1. Create your MS Access Database (
ProjectDB.accdb):Create a new blank Access database and save it as
ProjectDB.accdb(e.g., in your project'sbin\Debugfolder, or any accessible location).Create a table named
Taskswith the following columns:Column Name Data Type Description TaskIDAutoNumber Primary Key TaskNameShort Text Name of the task StartDateDate/Time Task start date EndDateDate/Time Task end date DurationNumber Duration in days (e.g., Single, Integer) PredecessorsShort Text Comma-separated TaskIDs (e.g., "1,2" for FS) PercentCompleteNumber Percentage complete (0-100) 2. Create a New VB.NET Windows Forms Application in Visual Studio:
- Open Visual Studio.
- Click "Create a new project".
- Select "Windows Forms App (.NET Framework)" for VB.NET.
- Name your project (e.g.,
MyProjectPlanner).
Code Structure
We'll create a few classes to keep things organized:
Task.vb: Represents a single task object.DataAccess.vb: Handles all interactions with the MS Access database.MainForm.vb: The main user interface.
Step-by-Step Implementation
1. Add a Class
Task.vbThis class will represent a single task.
- In Solution Explorer, right-click your project -> Add -> Class...
- Name it
Task.vb.
' Task.vb Public Class Task Public Property TaskID As Integer Public Property TaskName As String Public Property StartDate As Date Public Property EndDate As Date Public Property Duration As Integer ' In days Public Property Predecessors As String ' Comma-separated TaskIDs Public Property PercentComplete As Integer Public Sub New() ' Default constructor Me.TaskID = 0 ' Will be set by DB for new tasks Me.TaskName = "" Me.StartDate = Date.Today Me.EndDate = Date.Today Me.Duration = 1 Me.Predecessors = "" Me.PercentComplete = 0 End Sub Public Sub New(id As Integer, name As String, startDt As Date, endDt As Date, durationDays As Integer, preds As String, percent As Integer) Me.TaskID = id Me.TaskName = name Me.StartDate = startDt Me.EndDate = endDt Me.Duration = durationDays Me.Predecessors = preds Me.PercentComplete = percent End Sub End Class2. Add a Class
DataAccess.vbThis class will handle all database operations.
- In Solution Explorer, right-click your project -> Add -> Class...
- Name it
DataAccess.vb.
' DataAccess.vb Imports System.Data.OleDb Imports System.Windows.Forms Public Class DataAccess Private Const DB_FILE_NAME As String = "ProjectDB.accdb" Private ReadOnly ConnectionString As String Public Sub New() ' Get the path to the executable's directory Dim appPath As String = AppDomain.CurrentDomain.BaseDirectory ' Construct the full path to the database file Dim dbPath As String = System.IO.Path.Combine(appPath, DB_FILE_NAME) ' Ensure the database file exists If Not System.IO.File.Exists(dbPath) Then MessageBox.Show($"Database file not found at: {dbPath}{Environment.NewLine}Please create 'ProjectDB.accdb' with a 'Tasks' table.", "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error) Application.Exit() ' Exit if DB is not found End If Me.ConnectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={dbPath};Persist Security Info=False;" End Sub Private Function GetConnection() As OleDbConnection Return New OleDbConnection(ConnectionString) End Function Public Function LoadTasks() As List(Of Task) Dim tasks As New List(Of Task)() Dim sql As String = "SELECT TaskID, TaskName, StartDate, EndDate, Duration, Predecessors, PercentComplete FROM Tasks ORDER BY StartDate, TaskID" Using conn As OleDbConnection = GetConnection() Using cmd As New OleDbCommand(sql, conn) Try conn.Open() Using reader As OleDbDataReader = cmd.ExecuteReader() While reader.Read() Dim task As New Task( CInt(reader("TaskID")), CStr(reader("TaskName")), CDate(reader("StartDate")), CDate(reader("EndDate")), CInt(reader("Duration")), If(reader("Predecessors") Is DBNull.Value, "", CStr(reader("Predecessors"))), CInt(reader("PercentComplete")) ) tasks.Add(task) End While End Using Catch ex As Exception MessageBox.Show("Error loading tasks: " & ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End If End Using End Using Return tasks End Function Public Sub SaveTask(task As Task) Using conn As OleDbConnection = GetConnection() Dim sql As String If task.TaskID = 0 Then ' New Task sql = "INSERT INTO Tasks (TaskName, StartDate, EndDate, Duration, Predecessors, PercentComplete) VALUES (?, ?, ?, ?, ?, ?)" Else ' Existing Task sql = "UPDATE Tasks SET TaskName = ?, StartDate = ?, EndDate = ?, Duration = ?, Predecessors = ?, PercentComplete = ? WHERE TaskID = ?" End If Using cmd As New OleDbCommand(sql, conn) cmd.Parameters.AddWithValue("?", task.TaskName) cmd.Parameters.AddWithValue("?", task.StartDate) cmd.Parameters.AddWithValue("?", task.EndDate) cmd.Parameters.AddWithValue("?", task.Duration) cmd.Parameters.AddWithValue("?", task.Predecessors) cmd.Parameters.AddWithValue("?", task.PercentComplete) If task.TaskID <> 0 Then cmd.Parameters.AddWithValue("?", task.TaskID) End If Try conn.Open() cmd.ExecuteNonQuery() Catch ex As Exception MessageBox.Show("Error saving task: " & ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End Using End Using End Sub Public Sub DeleteTask(taskID As Integer) Using conn As OleDbConnection = GetConnection() Dim sql As String = "DELETE FROM Tasks WHERE TaskID = ?" Using cmd As New OleDbCommand(sql, conn) cmd.Parameters.AddWithValue("?", taskID) Try conn.Open() cmd.ExecuteNonQuery() Catch ex As Exception MessageBox.Show("Error deleting task: " & ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End Using End Using End Sub End Class3. Design
MainForm.vbDrag and drop the following controls from the Toolbox onto your
MainForm.vb:TableLayoutPanel(Main container for layout - SetDock = Fill)- Row 1: Toolbar (
ToolStriporPanelwith Buttons) - Row 2:
SplitContainer(for Task Grid and Gantt Chart)- Panel1:
DataGridView(for tasks) - Panel2:
Panel(for custom Gantt drawing)
- Panel1:
- Row 3: Task Details Panel (
Panelwith Labels, TextBoxes, DatePickers)
- Row 1: Toolbar (
Controls to add:
Control Name Properties (Key Ones) DataGridViewdgvTasksDock = Fill,ReadOnly = FalsePanelpnlGanttDock = Fill,BorderStyle = FixedSingleLabellblTaskNameText: "Task Name:" TextBoxtxtTaskNameLabellblStartDateText: "Start Date:" DateTimePickerdtpStartDateFormat = ShortLabellblEndDateText: "End Date:" DateTimePickerdtpEndDateFormat = ShortLabellblDurationText: "Duration (Days):" NumericUpDownnudDurationMinimum = 1LabellblPredecessorsText: "Predecessors (IDs):" TextBoxtxtPredecessorsLabellblPercentCompleteText: "% Complete:" NumericUpDownnudPercentCompleteMinimum = 0,Maximum = 100ButtonbtnNewTaskText: "New Task" ButtonbtnSaveTaskText: "Save Task" ButtonbtnDeleteTaskText: "Delete Task" ButtonbtnRefreshText: "Refresh" Screenshot of basic layout design:
(Imagine a typical Windows Form layout here: Top row for buttons, middle split into left for grid, right for gantt, bottom for task details input fields)
- Top: Buttons (New, Save, Delete, Refresh)
- Middle Left:
dgvTasks - Middle Right:
pnlGantt - Bottom: Task Details (labels, textboxes, datepickers, numericupdowns)
4. Code
MainForm.vb' MainForm.vb Imports System.Windows.Forms Imports System.Drawing Public Class MainForm Private dataAccess As New DataAccess() Private currentTasks As List(Of Task) Private selectedTask As Task ' Gantt Chart Drawing constants Private Const HEADER_HEIGHT As Integer = 25 Private Const ROW_HEIGHT As Integer = 25 Private Const LEFT_MARGIN As Integer = 10 Private Const TOP_MARGIN As Integer = 10 Private Const BAR_HEIGHT As Integer = 15 Private Const DATE_SCALE_UNIT_WIDTH As Integer = 20 ' Pixels per day Private Sub MainForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load InitializeDataGridView() LoadData() End Sub Private Sub InitializeDataGridView() dgvTasks.AutoGenerateColumns = False ' We'll define columns manually ' Add columns With dgvTasks.Columns .Add(New DataGridViewTextBoxColumn With {.Name = "TaskID", .DataPropertyName = "TaskID", .HeaderText = "ID", .ReadOnly = True, .Width = 40}) .Add(New DataGridViewTextBoxColumn With {.Name = "TaskName", .DataPropertyName = "TaskName", .HeaderText = "Task Name", .Width = 150}) .Add(New DataGridViewTextBoxColumn With {.Name = "StartDate", .DataPropertyName = "StartDate", .HeaderText = "Start Date", .Width = 80, .DefaultCellStyle = New DataGridViewCellStyle With {.Format = "d"}}) .Add(New DataGridViewTextBoxColumn With {.Name = "EndDate", .DataPropertyName = "EndDate", .HeaderText = "End Date", .Width = 80, .DefaultCellStyle = New DataGridViewCellStyle With {.Format = "d"}}) .Add(New DataGridViewTextBoxColumn With {.Name = "Duration", .DataPropertyName = "Duration", .HeaderText = "Duration", .Width = 60}) .Add(New DataGridViewTextBoxColumn With {.Name = "Predecessors", .DataPropertyName = "Predecessors", .HeaderText = "Predecessors", .Width = 100}) .Add(New DataGridViewTextBoxColumn With {.Name = "PercentComplete", .DataPropertyName = "PercentComplete", .HeaderText = "% Comp", .Width = 60}) End With End Sub Private Sub LoadData() currentTasks = dataAccess.LoadTasks() dgvTasks.DataSource = Nothing ' Clear previous binding dgvTasks.DataSource = currentTasks ClearTaskDetails() pnlGantt.Invalidate() ' Redraw Gantt chart End Sub Private Sub ClearTaskDetails() selectedTask = New Task() txtTaskName.Text = "" dtpStartDate.Value = Date.Today dtpEndDate.Value = Date.Today nudDuration.Value = 1 txtPredecessors.Text = "" nudPercentComplete.Value = 0 End Sub Private Sub PopulateTaskDetails(task As Task) If task Is Nothing Then ClearTaskDetails() Return End If selectedTask = task txtTaskName.Text = task.TaskName dtpStartDate.Value = task.StartDate dtpEndDate.Value = task.EndDate nudDuration.Value = task.Duration txtPredecessors.Text = task.Predecessors nudPercentComplete.Value = task.PercentComplete End Sub Private Function GetTaskFromDetails() As Task Dim task As New Task() If selectedTask IsNot Nothing Then task.TaskID = selectedTask.TaskID ' Preserve ID for updates End If task.TaskName = txtTaskName.Text task.StartDate = dtpStartDate.Value.Date task.EndDate = dtpEndDate.Value.Date task.Duration = CInt(nudDuration.Value) task.Predecessors = txtPredecessors.Text task.PercentComplete = CInt(nudPercentComplete.Value) Return task End Function Private Sub dgvTasks_SelectionChanged(sender As Object, e As EventArgs) Handles dgvTasks.SelectionChanged If dgvTasks.SelectedRows.Count > 0 Then Dim selectedRow As DataGridViewRow = dgvTasks.SelectedRows(0) Dim selectedTaskID As Integer = CInt(selectedRow.Cells("TaskID").Value) Dim task As Task = currentTasks.Find(Function(t) t.TaskID = selectedTaskID) PopulateTaskDetails(task) Else ClearTaskDetails() End If End Sub Private Sub dgvTasks_CellEndEdit(sender As Object, e As DataGridViewCellEventArgs) Handles dgvTasks.CellEndEdit ' This handles direct editing in the DataGridView If e.RowIndex >= 0 Then Dim editedTask As Task = CType(dgvTasks.Rows(e.RowIndex).DataBoundItem, Task) If editedTask IsNot Nothing Then ' Re-calculate EndDate if StartDate or Duration changed If dgvTasks.Columns(e.ColumnIndex).Name = "StartDate" OrElse dgvTasks.Columns(e.ColumnIndex).Name = "Duration" Then editedTask.EndDate = editedTask.StartDate.AddDays(editedTask.Duration - 1) ' -1 because duration of 1 day means start and end on same day dgvTasks.RefreshEdit() ' Refresh the row to show updated EndDate ElseIf dgvTasks.Columns(e.ColumnIndex).Name = "EndDate" Then editedTask.Duration = CInt((editedTask.EndDate - editedTask.StartDate).TotalDays) + 1 dgvTasks.RefreshEdit() ' Refresh the row to show updated Duration End If dataAccess.SaveTask(editedTask) pnlGantt.Invalidate() ' Redraw Gantt chart End If End If End Sub Private Sub btnNewTask_Click(sender As Object, e As EventArgs) Handles btnNewTask.Click ClearTaskDetails() dgvTasks.ClearSelection() txtTaskName.Focus() End Sub Private Sub btnSaveTask_Click(sender As Object, e As EventArgs) Handles btnSaveTask.Click Dim taskToSave As Task = GetTaskFromDetails() If String.IsNullOrWhiteSpace(taskToSave.TaskName) Then MessageBox.Show("Task Name cannot be empty.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning) Return End If If taskToSave.StartDate > taskToSave.EndDate Then MessageBox.Show("Start Date cannot be after End Date.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Warning) Return End If If taskToSave.TaskID = 0 Then ' New task dataAccess.SaveTask(taskToSave) MessageBox.Show("Task added successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information) Else ' Existing task dataAccess.SaveTask(taskToSave) MessageBox.Show("Task updated successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information) End If LoadData() ' Reload data to reflect changes and refresh Gantt chart End Sub Private Sub btnDeleteTask_Click(sender As Object, e As EventArgs) Handles btnDeleteTask.Click If dgvTasks.SelectedRows.Count > 0 Then Dim confirmResult As DialogResult = MessageBox.Show("Are you sure you want to delete this task?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) If confirmResult = DialogResult.Yes Then Dim taskToDeleteID As Integer = CInt(dgvTasks.SelectedRows(0).Cells("TaskID").Value) dataAccess.DeleteTask(taskToDeleteID) MessageBox.Show("Task deleted successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information) LoadData() End If Else MessageBox.Show("Please select a task to delete.", "No Task Selected", MessageBoxButtons.OK, MessageBoxIcon.Information) End If End Sub Private Sub btnRefresh_Click(sender As Object, e As EventArgs) Handles btnRefresh.Click LoadData() End Sub Private Sub dtpStartDate_ValueChanged(sender As Object, e As EventArgs) Handles dtpStartDate.ValueChanged ' Automatically calculate EndDate based on Duration dtpEndDate.Value = dtpStartDate.Value.AddDays(CInt(nudDuration.Value) - 1) End Sub Private Sub nudDuration_ValueChanged(sender As Object, e As EventArgs) Handles nudDuration.ValueChanged ' Automatically calculate EndDate based on StartDate and Duration dtpEndDate.Value = dtpStartDate.Value.AddDays(CInt(nudDuration.Value) - 1) End Sub Private Sub dtpEndDate_ValueChanged(sender As Object, e As EventArgs) Handles dtpEndDate.ValueChanged ' Automatically calculate Duration based on StartDate and EndDate If dtpEndDate.Value < dtpStartDate.Value Then nudDuration.Value = 1 ' Or display error Return End If nudDuration.Value = CInt((dtpEndDate.Value - dtpStartDate.Value).TotalDays) + 1 End Sub ' Gantt Chart Drawing Logic Private Sub pnlGantt_Paint(sender As Object, e As PaintEventArgs) Handles pnlGantt.Paint If currentTasks Is Nothing OrElse currentTasks.Count = 0 Then Return End If Dim g As Graphics = e.Graphics g.Clear(Me.BackColor) ' Clear panel background ' 1. Determine overall project start and end dates Dim minDate As Date = currentTasks.Min(Function(t) t.StartDate) Dim maxDate As Date = currentTasks.Max(Function(t) t.EndDate) ' Extend range for better visualization minDate = minDate.AddDays(-7) ' A week before the earliest task maxDate = maxDate.AddDays(7) ' A week after the latest task Dim totalDays As Integer = CInt((maxDate - minDate).TotalDays) + 1 If totalDays = 0 Then totalDays = 1 ' Prevent division by zero ' Calculate horizontal scale Dim drawableWidth As Integer = pnlGantt.Width - LEFT_MARGIN * 2 Dim pixelsPerDay As Single = CSng(drawableWidth) / totalDays ' Adjust pixelsPerDay if it's too small, enforce a minimum visual unit If pixelsPerDay < 1 Then pixelsPerDay = 1 ' Ensure at least 1 pixel per day DATE_SCALE_UNIT_WIDTH = 20 ' Keep fixed for drawing daily headers ElseIf pixelsPerDay * DATE_SCALE_UNIT_WIDTH > pnlGantt.Width / 5 Then ' Prevent date headers from being too sparse DATE_SCALE_UNIT_WIDTH = CInt(pnlGantt.Width / (pixelsPerDay * 5)) ' Adjust date label frequency End If ' Ensure a minimum width for readability if dates are too compressed If pixelsPerDay * totalDays < 200 Then ' If total span is very small, artificially stretch pixelsPerDay = 200.0F / totalDays End If ' 2. Draw Date Headers Dim currentDrawDate As Date = minDate Dim xOffset As Integer = LEFT_MARGIN Using font As New Font("Segoe UI", 8) Using brush As New SolidBrush(Color.Black) While currentDrawDate <= maxDate Dim x As Integer = LEFT_MARGIN + CInt((currentDrawDate - minDate).TotalDays * pixelsPerDay) ' Draw vertical line for days g.DrawLine(Pens.LightGray, x, TOP_MARGIN, x, pnlGantt.Height - TOP_MARGIN) ' Draw Week/Month markers if needed ' For simplicity, just drawing daily/weekly If pixelsPerDay * 7 > DATE_SCALE_UNIT_WIDTH * 2 Then ' If enough space for week label If currentDrawDate.DayOfWeek = DayOfWeek.Sunday Then g.DrawString(currentDrawDate.ToString("MMM dd"), font, brush, x + 2, TOP_MARGIN + 5) End If Else ' Draw individual days if very zoomed in g.DrawString(currentDrawDate.Day.ToString(), font, brush, x + 2, TOP_MARGIN + 5) End If currentDrawDate = currentDrawDate.AddDays(1) End While End Using End Using ' Draw a line separating header from tasks g.DrawLine(Pens.DarkGray, LEFT_MARGIN, TOP_MARGIN + HEADER_HEIGHT, pnlGantt.Width - LEFT_MARGIN, TOP_MARGIN + HEADER_HEIGHT) ' 3. Draw Task Bars For i As Integer = 0 To currentTasks.Count - 1 Dim task As Task = currentTasks(i) Dim taskStartX As Integer = LEFT_MARGIN + CInt((task.StartDate - minDate).TotalDays * pixelsPerDay) Dim taskEndX As Integer = LEFT_MARGIN + CInt((task.EndDate - minDate).TotalDays * pixelsPerDay) + CInt(pixelsPerDay) ' + pixelsPerDay for full day Dim taskWidth As Integer = taskEndX - taskStartX If taskWidth < 1 Then taskWidth = 1 ' Ensure minimum width for 1-day tasks Dim y As Integer = TOP_MARGIN + HEADER_HEIGHT + (i * ROW_HEIGHT) + (ROW_HEIGHT - BAR_HEIGHT) \ 2 ' Draw task bar Dim barColor As Color = Color.SteelBlue Using solidBrush As New SolidBrush(barColor) g.FillRectangle(solidBrush, taskStartX, y, taskWidth, BAR_HEIGHT) End Using g.DrawRectangle(Pens.DarkBlue, taskStartX, y, taskWidth, BAR_HEIGHT) ' Draw progress bar Dim progressWidth As Integer = CInt(taskWidth * (task.PercentComplete / 100.0F)) Using progressBrush As New SolidBrush(Color.Green) g.FillRectangle(progressBrush, taskStartX, y, progressWidth, BAR_HEIGHT) End Using ' Draw task name beside bar Using font As New Font("Segoe UI", 8) Using brush As New SolidBrush(Color.Black) g.DrawString(task.TaskName, font, brush, taskStartX + taskWidth + 5, y + (BAR_HEIGHT - font.Height) \ 2) End Using End Using Next End Sub End Class
How to Run and Use
- Place
ProjectDB.accdb: Copy theProjectDB.accdbfile you created into your Visual Studio project'sbin\Debugfolder (orbin\x86\Debugetc., depending on your project settings). When you run the application, it will look for it there. - Build and Run: Press F5 in Visual Studio.
- Add Tasks:
- Click "New Task".
- Fill in "Task Name", "Start Date", "Duration". The "End Date" will auto-calculate.
- Click "Save Task".
- Add a few more tasks.
- Edit Tasks:
- Select a row in the
DataGridView. The details will populate the bottom panel. - Modify details and click "Save Task".
- You can also directly edit cells in the
DataGridView.
- Select a row in the
- Delete Tasks: Select a row and click "Delete Task".
- Gantt Chart: The
pnlGantton the right will visually represent your tasks.- Each rectangle is a task bar.
- The green portion represents
% Complete. - Task names appear next to the bars.
- The top displays date headers.
Further Enhancements and Next Steps
This is a very basic foundation. Here's a roadmap for adding more MS Project-like functionality:
A. Core Functionality:
- Dependency Logic (Predecessors):
- Refinement: Instead of a simple text field for predecessors, create a
TaskDependenciestable in Access:DependencyID (AutoNumber),PredecessorTaskID (Number),SuccessorTaskID (Number),DependencyType (Text, e.g., "FS" for Finish-to-Start). - Calculation: Implement logic to automatically adjust successor task dates based on predecessor completion and dependency type. This is complex (critical path method, slack).
- Refinement: Instead of a simple text field for predecessors, create a
- Working Days/Calendar: Currently, duration is simple calendar days. MS Project has working calendars. You'd need to implement logic to calculate dates based on a 5-day work week, holidays, etc.
- Resources: Add a
Resourcestable and aTaskAssignmentstable to assign resources to tasks. - Milestones: Tasks with zero duration.
- Grouping/Summary Tasks: Allow tasks to be grouped under summary tasks. This adds hierarchy.
- Baselines: Save a snapshot of the project schedule for comparison.
B. UI/UX Improvements:
- Gantt Chart Interactivity:
- Zooming/Scrolling: Make the Gantt chart zoomable and horizontally scrollable for large projects.
- Drag-and-Drop: Allow users to drag task bars to change dates, or drag ends to change duration.
- Dependency Lines: Draw lines between dependent tasks on the Gantt chart.
- Sorting and Filtering: Add options to sort and filter tasks in the
DataGridView. - Context Menus: Right-click menus for tasks.
- File Operations: "Open Project", "Save Project As" (though currently, it just operates on the single DB file).
- Reporting: Generate simple reports (e.g., task list, timeline).
C. Database Migration to SQL Server:
When ready to migrate to SQL Server:
- Change Connection String: Update
DataAccess.vbto useSystem.Data.SqlClientand a SQL Server connection string. - SQL Server Tables: Recreate your
Taskstable (and any new tables) in SQL Server. - OLEDB vs. SQLClient: The
OleDbCommand,OleDbConnection,OleDbDataReaderetc., would be replaced with theirSqlClientcounterparts. TheDataAccessmethods would largely remain the same in their logic.
This initial application provides a functional base for you to build upon. Good luck!
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.