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 connectionString As String = "Provider=Microsoft.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.OleDbDataAdapter(selectCommand, connectionString)
Dim commandBuilder As New OleDb.OleDbCommandBuilder(dataAdapter)


Inside a button or on frm load put:

dgvAnswer.DataSource = ""
dataSetAnswer.Clear()
selectCommand = "SELECT * FROM tblAnswer Order By Answer_Id"
dataAdapter.SelectCommand.CommandText = selectCommand
dataAdapter.Fill(dataSetAnswer, "AnswerView")
dgvAnswer.DataSource = dataSetAnswer.Tables("AnswerView")

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.