We help IT Professionals succeed at work.

Can I have a different font for different columns in a datagrid in vb.net 2003

200 Views
Last Modified: 2013-11-26
I have a database with words in one language in one column and and the same word translated in the next column
I would like to display the columns in different language fonts How can I do this
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Sample of Itay...

Place this code with each column code

' Create a new CultureInfo object using the
' the locale ID for Italy.
Dim ItalyCultureInfo As Globalization.CultureInfo = New _
Globalization.CultureInfo(&H410)
' Cast a column that holds numeric values to the
' DataGridTextBoxColumn type, and set the FormatInfo
' property to the new CultureInfo object.
Dim myGridTextBoxColumn As DataGridTextBoxColumn = _
CType(MyDataGrid.TableStyles("Orders"). _
GridColumnStyles("OrderAmount"), DataGridTextBoxColumn)
myGridTextBoxColumn.FormatInfo = ItalyCultureInfo
myGridTextBoxColumn.Format = "c"

Author

Commented:
I dont know what you mean by each column code all columns are populated in one shot
with the following
DataGrid1.SetDataBinding(ds, "t1")
 
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
woah
gee thanks
this is going to take me time to digest

but at first glance I only see you setting the font property for the entire table and not for the individual columns is there anything simple like

datagrid1.column(1).font="arial"

thanks in advance for your patience
please remember I am real new at this
CERTIFIED EXPERT

Commented:
the 'Globalization.CultureInfo'  is where you get the different font languages
the font can stay the same in the table, but you can have different languages in each column.

Author

Commented:
ok I copied all your code into my project
it is not working
I dont have any squiggly lines under any of the members or objects except for Itag
the variable you did the select case on
also my table only has 2 columns in it does that make a difference
finaly do I need to set the language can't I just set the font
my language either
         actualy uses an english font wich just looks different

         or uses a unicode font
CERTIFIED EXPERT

Commented:
Can you post  your code and what font/langauage you want.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.