-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: dinesh_gr
Message 4 in Discussion
Hi Guna, U can try adding a serial number to ur grid either by using an item
template or the dataset itself returning an additional coloumn(SerialNo). Reg the
auto numbering in grid, Saravana has dropped the URL for the article. This is how u
go with Datasets... objDs = New DataSet() Dim objDt As DataTable
objDt = New DataTable("Temp") ' Creating a new Data Table as Temp
Dim objCol As DataColumn
objCol = New DataColumn("SerialNo", GetType(Integer)) 'Assigning the Coloumn (Serial
No) to the Data Table which is of ztype integer.
objCol.AutoIncrement = True
objCol.AutoIncrementSeed = 1 ' Making the Serial No to start froom No.1
objCol.Unique = True
objDt.Columns.Add(objCol) ' Adding the coloumn to the Data Table("temp")
objDs.Tables.Add(objDt) ' Adding the Data Table("Temp") to Data Set
objAdapter = New SqlDataAdapter(strSql, objConnection) ' Executing the Query over the
Adapter
objAdapter.Fill(objDs, "Temp")
So each time when arow is getting added, the serialno will be add to the (SerialNo
coloumn.)
Assign this SerialNo as bound coloumn to ur grid.
I hope it works for u...
-Dinesh.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
