DataGride

[tota]

i need to create adataGride that retrieve data from the DataBase
this data is arabic , i need to align the columns & the text inside the
column
to the right ??
i used
this.DGTextBoxColumn.Alignment =
System.Windows.Forms.HorizontalAlignment.Right;
but it didnt work !

also
my select statemnet is selecting from 2 tables
this.DSFucalities = new System.Data.DataSet("Alex_Univ");
as Alex_Univ is the name of the table , how to tell the Dataset that
it shall connect to 2 tables as when i wrote
this.DSFucalities = new System.Data.DataSet("Alex_Univ","Departements");
it didnt accept it

my select statement is
string str_sel="select Alex_Uviv.F_name as 'Faculity' ,
count(Departements.Dept_no) as 'Number of Departement' from Alex_Univ
,Departements where Alex_Univ.F_no = Departements.F_no ";

where in the count(Departements.Dept_no) i need to count the
number of departements in each faculity ??
so eachtime i run that statement it give me error at this point
this.sqlDataAdapterFuculities.Fill(DSFucalities);
if this question is not related to that group plz direct me to
the correct one

Regards ;