void FillDataGrid()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Ace.OLEDB.12.0 ;Data Source=" + Application.StartupPath + "\\GymDataBase.accdb");
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand();
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.CommandText = "SELECT CodMelli,RegDate,Pic,Nam,Family,Father,[Gender],BirthCity,BirthDate,GymName,AgeTypeStudent,Weight Student,[Tell],[Mobile],[Address],[E-Mail],NameOfCollegeOrSchool,StudingLevel,[Level],AverageScore,RecentlyMounth,DateOfPay,[Money],PayID,PayAll,OntimeOrNot,HozorDate,VaziyatHozor,B eltBelt,DateOfBelt,BeltPlace,BeltCertificateNum,Da teOfMatch,MatchPlace,AgeTypeHero,WeightHero,BeltHe ro,DegreeHero,MatchCertificateNum,[Province],DegreeInProvince,[Contry],DegreeInContry,BeltAccept,HomeWorkForm,StudCoapor ation,ParentCoaporation,SchoolVerification,ParentV erification,ParentPresentation,LeisureCamp,ProCamp ,MasterScore,OtherSuccesses,[Cup] FROM PresentOrAbsent INNER JOIN (Others INNER JOIN (Knowledge INNER JOIN (Hero INNER JOIN (Tuition INNER JOIN (Belt INNER JOIN Student ON Belt.ID = Student.CodMelli) ON Tuition.ID = Student.CodMelli) ON Hero.ID = Student.CodMelli) ON Knowledge.ID = Student.CodMelli) ON Others.ID = Student.CodMelli) ON PresentOrAbsent.ID = Student.CodMelli";
try
{
conn.Open();
da.SelectCommand.Connection = conn;
da.SelectCommand.ExecuteNonQuery();
da.Fill(ds, "Table");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "Table";
conn.Close();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}