Visual Basic

desanti wrote:

I want that the databases to be not be visible under SQL management studio

Quote:

I want that the databases to be not be visible under SQL management studio , when my program is not open.

using (var newForm = new Form2.Form2())
{
    form2.InitializeComponent();
    form2.ShowDialog();
}

Dave Kreskowiak wrote:

I don't see any benefit that outways the complexity of doing this, so what's the point?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

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