adding row numbers to datagrid

[jamesd0142]

Hi again!

Please see image...

I have retrieved this information from my database, i now want to add a row number to each row that is added...

any ideas?

Cheers

[hariharanmca]

You have to do it in insert query or set a autonumber in database table.

[vishwaskothari]

Hi again!

Please see image...

I have retrieved this information from my database, i now want to add a row number to each row that is added...

any ideas?

Cheers

hi!!
can u plz tell me how you have retrieved the entries from the database in a datagrid by coding

TIA
regards
vishwas

[jamesd0142]

at the top of the form below the public class

'connect to database
Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=FAQs.mdb "
Dim selectCommand As String

'create datasets
Dim dataSetView As New DataSet
Dim dataSetQuestion As New DataSet
Dim dataSetAnswer As New DataSet


Dim dataAdapter As New OleDb.OleDbData Adapter(selectC ommand, connectionStrin g)
Dim commandBuilder As New OleDb.OleDbComm andBuilder(data Adapter)


Inside a button or on frm load put:

dgvAnswer.DataS ource = ""
dataSetAnswer.C lear()
selectCommand = "SELECT * FROM tblAnswer Order By Answer_Id"
dataAdapter.Sel ectCommand.Comm andText = selectCommand
dataAdapter.Fil l(dataSetAnswer , "AnswerView ")
dgvAnswer.DataS ource = dataSetAnswer.T ables("AnswerVi ew")

DONT FORGET TO PUT YOUR DATABASE IN YOUR PROJECT FOLDER!
I put mine in bid\debug although i have been told this is bad practice.