Dear Users,
(Below is my code to view datagrid1)
I have a datagrid which I use to return Dates and times from Access Database. 1) My dates come back a long Dates, but all I would like is one column for times. 2) How do I make it a read only Datagrid without the '*' to confuse users 3) How do I make it updated able, only by the user who entered the information.'I can do the query to make sure the users names match, but how do I leave the connection open ?'

Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\DATA\ACCESS\13FloorEquipment.mdb"
            Dim strSQL As String = "SELECT [ItemName], [StartDate],[EndDate],[NTID] FROM(Requests) "
            strSQL = strSQL & "WHERE (([ItemName]= '" & nItem & "')"
            strSQL = strSQL & "AND (([StartDate])"
            strSQL = strSQL & "BETWEEN #" & kStart & " 12:00:00 AM #"
            strSQL = strSQL & "AND #" & kStop & " 11:59:59 PM #));"
            'MsgBox(strSQL)

            Dim conn As OleDbConnection = New OleDbConnection(conStr)
            conn.Open()
            Dim da As OleDbDataAdapter = New OleDbDataAdapter(strSQL, conn)

            Dim ds As DataSet = New DataSet()
            da.Fill(ds, "Requests")
            Dim dv As DataView = ds.Tables("Requests").DefaultView
            DataGrid1.DataSource = dv

            conn.Close()

Dear user how do I get this code to allow me to update my database thru this Datagrid??

Dim COmpare As String
        Dim NTID As String
        Dim Dtemp As Date
        Dim FTemp As Date
        Dim z As Long

        NTID = txtNTID.Text

        Dim Direct As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\DATA\ACCESS\13FloorEquipment.mdb"
        Dim strSQL As String = "SELECT [ItemName], [StartDate],[EndDate],[NTID] FROM(Requests) "
        strSQL = strSQL & "Where(([NTID]='" & NTID & "'));"

        Dim conn As OleDbConnection = New OleDbConnection(Direct)
        conn.Open()
        Dim Xa As OleDbDataAdapter = New OleDbDataAdapter(strSQL, conn)

        Dim Xs As DataSet = New DataSet()
        Xa.Fill(Xs, "Requests")
        Dim Xv As DataView = Xs.Tables("Requests").DefaultView
        DataGrid1.DataSource = Xv

        conn.Close()
        'Next

The code I have shown only returns information in the database I query, but I would like to click on a row and delete the whole row. How is this possible?

Thank you

The datagrid class has a delete command event for when you click on a delete button in a particular row. You can have that handler call the database to delete a row based on the key field(s) in your database. It looks like NTID is a key field, so you could make that delete call using the value from the datagrid item passed into the delete handler.

Peter
------------------------------------------------------
Work smarter, not harder.

Could you help get me started on this ?

All my sources are making me Dim each datacolumn....

The Datagrid I have is being used to return several things. 1) View information from Database 2) would like to 'Delete' a highlit row, but only but the NTID. Can someone help

What kind of project is this? The DataGrid object is different between a windows forms application and a ASP.Net webforms application.

Peter
------------------------------------------------------
Work smarter, not harder.

This Form is being done in VS.net, and use OleDb connection to link to my Access Database which is on our company network. Access Dbase is not on a SQL Server, so I have to use OleDb Connector...

Thank you

"being done in VS.Net" doesn't help.
Is this a windows form or an ASP.Net web form?

I am familiar with datagrids in web forms, but not in windows forms so I might not be able to provide the answer.

Peter
------------------------------------------------------
Work smarter, not harder.

Yes it is in Window Form....