|
-
Dec 16th, 2002, 10:19 AM
#1
Thread Starter
Member
Formatting a datagrid
I am creating a datagrid on the fly like this:
myQuery = "SELECT * FROM [tbl * F002 > 4 J] WHERE _
MUFLID2 =" & Chr(39) & ddlWho.SelectedItem.Text _
& Chr(39) & "ORDER BY STEPGAP DESC"
OleDbConnection1.Open()
Dim cmd As New OleDb.OleDbCommand()
cmd.Connection = OleDbConnection1
cmd.CommandText = myQuery
Dim datareader As OleDb.OleDbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dgF002.DataSource = datareader
dgF002.AutoGenerateColumns = True
dgF002.DataBind()
Apparently I cannot format individual columns using the property builder (such as a column I wish to format into currency). How can I format the grid via code? Is there a relatively simple way to do this?
Thanks in advance...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|