Multi user Application

[shers]

Hi,

I have finished coding a VB.Net application that has connection to SQL Express 2008 database. My question is, what steps do I have to take to make this a multi user application.

FYI:
There are 3 tables in the database of which two tables contain data to be viewed by the user and one table is to insert records by the user. The former two tables will be edited by the administrator only. So there is no issue of concurrency. But the one table that is used to insert records by all users has to be dealt with. Please give me suggessions as to how I should go about it.

Thanks

[Phil Weber]

How are you connecting to the database? Are you using a Dataset? A BindingSource? Or some other method?

[shers]

I have given a connection string in the application settings, so that in future I can change the location if there is any.

Thanks

[Hack]

Is your originial question resolved or do you still have open issues with this?

[Phil Weber]

I'm sorry, I didn't mean to ask how you are connecting to the database, I meant what method are you using to retrieve and insert data?

[shers]

I'm using SQL INSERT method to add records to the table and SELECT method to retrieve from the table.

Thanks

[Phil Weber]

Which .NET classes are you using to send the SQL statements? SqlDataReader or Dataset?

[shers]

This is the code I have written.

Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
        Dim cnSQL As SqlConnection
        Dim cmSQL As SqlCommand
        Dim strSQL As String
        Dim iRow As Integer
        Dim temp As Integer

        For iRow = 0 To grdDetails.Rows.Count - 1
            If Not grdDetails.Rows(iRow).IsNewRow Then
                Try
                    strSQL = "INSERT INTO Details VALUES ('" & Today() & "', '" & lblUser.Text & "', '" & _
                            Trim(cboDept.Text) & "', " & Trim(cboRFS.Text) & ", '" & Trim(cboCharge.Text) & _
                            "', '" & txtCharge.Text & "', '" & txtPurp.Text & "', '" & _
                            grdDetails.Rows(iRow).Cells("colFiles").Value & _
                            "', '" & grdDetails.Rows(iRow).Cells("colSize").Value & "', '" & _
                            grdDetails.CurrentRow.Cells("colType").Value & "', " & _
                            grdDetails.Rows(iRow).Cells("colPrints").Value & ", " & _
                            grdDetails.Rows(iRow).Cells("colTCost").Value & ", '" & _
                            grdDetails.Rows(iRow).Cells("colManual").Value & "', '" & txtCmnts.Text & "')"

                    cnSQL = New SqlConnection(My.Settings("sqlCon"))
                    cnSQL.Open()

                    cmSQL = New SqlCommand(strSQL, cnSQL)
                    cmSQL.ExecuteNonQuery()

                    cnSQL.Close()
                    cmSQL.Dispose()
                    cnSQL.Dispose()

                Catch ex As Exception
                    Throw ex
                End Try
            Else
                temp = temp + 1
            End If
        Next

        If temp > 0 Then
            iRow = iRow - temp
        End If
        MsgBox(iRow & " requests added.")

    End Sub

[eclipsed4utoo]

are users only able to INSERT into this one table, or can they edit the data of this one table also?