Visual Basic

Raabi Anony wrote:

Dim StaffInfoTable As New DataTable
Try
    adapter.Fill(StaffInfoTable)
    adapter.Update(StaffInfoTable)

Raabi Anony wrote:

Do I have to include ALL the Fields in the strUpdate; which are included in cmdText string; even if most of the fields are least expected to be modified?

Dim strUpdate As String = "UPDATE StaffName SET StaffName = 'Anonymous'" &  "WHERE StaffID = 1005"

Private Sub StaffInfoAdapterUpdate()
    Dim ConxnString As String = "Data Source=Dar-e-Arqam\SQLEXPRESS; Initial Catalog=StaffReport;
                                 Integrated Security=True"
    Dim Conxn As New SqlConnection(ConxnString)
    Dim cmd As SqlCommand = Conxn.CreateCommand()
    Dim StaffInfoDS As New DataSet()
    Dim StaffInfoAdapter As New SqlDataAdapter()
    Dim cmdText As String = "SELECT StaffID, StaffName, tblCampuses.CampusName, Designation,
                DOB, Gender, NIC, DateOfJoining
        FROM tblStaffInfo
        INNER JOIN tblCampuses
        ON tblStaffInfo.CampusID = tblCampuses.CampusID"
    Dim strUpdate As String = "UPDATE StaffName " &
                                 "SET StaffName = 'Anonymous' " & "WHERE StaffID = 1005"
    '                                     "SET StaffName = @StaffName " & "WHERE StaffID = @StaffID"
    Try
        Conxn.Open()
        cmd.CommandText = strUpdate
        cmd.ExecuteNonQuery()
        MsgBox("The record updated. Really?")
    Catch ex As Exception
        MsgBox("Error: " & ex.Message)
    End Try
End Sub

Raabi Anony wrote:

Dim strUpdate As String = "UPDATE tblStaffInfo " &
"SET StaffName = 'Anonymous' " & "WHERE StaffID = 1005"
' "SET StaffName = @StaffName " & "WHERE StaffID = @StaffID"
Try

Quote:

Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.

FROM tblStaffInfo AS A 
INNER JOIN tblCampuses AS B  ON A.CampusID = B.CampusID  
INNER JOIN tblStaffEvaluation AS C 	ON C.StaffID = A.StaffID

FROM tblStaffInfo A 
INNER JOIN tblCampuses B  ON A.CampusID = B.CampusID  
INNER JOIN tblStaffEvaluation C 	ON C.StaffID = A.StaffID

SELECT A.StaffName, tblCampuses.CampusName,
	LessonPlanning, LessonPreprn, Regularity,
	((LessonPlanning + LessonPreprn + Regularity) / 3) AS AvgScore
FROM tblStaffInfo  A 
INNER JOIN tblCampuses  B  ON A.CampusID = B.CampusID  
INNER JOIN tblStaffEvaluation  C 	ON C.StaffID = A.StaffID
ORDER BY A.StaffName

Quote:

Msg 4104, Level 16, State 1, Line 24
The multi-part identifier "tblCampuses.CampusName" could not be bound.

SELECT si.StaffName, ci.CampusName, ...
FROM tblStaffInfo AS si
INNER JOIN tblCampuses AS ci
ON si.CampusID = ci.CampusID
...