如何使用ms访问数据库连接5个表使用内连接查询？ [英] how to join 5 tables use inner join query using ms access database?

问题描述

这是我的代码错误是语法错误是表单子句。



尝试

{

OleDbConnection conn = new OleDbConnection（）;

conn.ConnectionString = @Provider = Microsoft.ACE.OLEDB.12.0; Data Source = D：\BS（CS）-6A\BS（CS ）-6A \Database Managment System \Student Managment Project \ School_Database\ School_Managment_System.accdb;

Persist Security Info = False;;

conn.Open（ ）;

OleDbCommand cmd = new OleDbCommand（）;

cmd.Connection = conn;

// string query =select s.std_id ，s.std_name，s.std_fname，s.std_phone，s.std_address，f.fee_paid，f.balance，f.fee_month，f.fee_year来自std_info s加入std_fees f on s.std_id = f.std_id;

string query = @select * from（std_info inner std_fees on std_info.std_id = std_fees.std_id），（内部加入费用） fees.fee_id = std_fees.fee_id），（class.class_id = fees.class_id上的内连接类），class.campus_id上的内连接校园= campus.campus_id;

cmd.CommandText = query;



OleDbDataAdapter da = new OleDbDataAdapter（cmd）;

DataTable dt = new DataTable（）;

da .Fill（dt）;

dataGrid1.DataSource = dt;



conn.Close（）;

}

catch（Exception ex）{

MessageBox.Show（Error+ ex）;

}

解决方案

尝试

{

OleDbConnection conn = new OleDbConnection（）;

conn.ConnectionString = @ Provider = Microsoft.ACE.OLEDB.12.0; Data Source = D：\BS（CS）-6A\BS（CS）-6A\Database Managment System \Student Managment Project \ School_Database\ School_Managment_System.acc db;

持久安全信息=错误;;

conn.Open（）;

OleDbCommand cmd = new OleDbCommand（）;

cmd.Connection = conn;

//字符串查询=选择s.std_id，s.std_name，s.std_fname，s.std_phone，s.std_address，f.fee_paid ，f.balance，f.fee_month，f.fee_year来自std_info s std_fees f on s.std_id = f.std_id;

string query = @select * from std_info inner join std_fees on std_info .std_id = std_fees.std_id关于费用的内部加盟费用.class_id = std_fees.fee_id内部联接类class.class_id = fees.class_id内部加入校园课程.campus_id = campus.campus_id;

cmd .CommandText = query;



OleDbDataAdapter da = new OleDbDataAdapter（cmd）;

DataTable dt = new DataTable（）;

da.Fill（dt）;

dataGrid1.DataSource = dt;



conn.Close（）;

}

catch（Exception ex）{

MessageBox.Show（Error+ ex）;

}

this is my code the error is syntax error is form clause.

try
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BS(CS)-6A\BS(CS)-6A\Database Managment System\Student Managment Project\School_Database\School_Managment_System.accdb;
Persist Security Info=False;";
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
// string query = "select s.std_id, s.std_name, s.std_fname, s.std_phone, s.std_address, f.fee_paid, f.balance, f.fee_month, f.fee_year from std_info s join std_fees f on s.std_id = f.std_id";
string query = @"select *from (std_info inner join std_fees on std_info.std_id = std_fees.std_id), (inner join fees on fees.fee_id = std_fees.fee_id),(inner join class on class.class_id = fees.class_id), inner join campus on class.campus_id = campus.campus_id";
cmd.CommandText = query;

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGrid1.DataSource = dt;

conn.Close();
}
catch (Exception ex) {
MessageBox.Show("Error" + ex);
}

解决方案

try
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BS(CS)-6A\BS(CS)-6A\Database Managment System\Student Managment Project\School_Database\School_Managment_System.accdb;
Persist Security Info=False;";
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
// string query = "select s.std_id, s.std_name, s.std_fname, s.std_phone, s.std_address, f.fee_paid, f.balance, f.fee_month, f.fee_year from std_info s join std_fees f on s.std_id = f.std_id";
string query = @"select *from std_info inner join std_fees on std_info.std_id = std_fees.std_id inner join fees on fees.fee_id = std_fees.fee_id inner join class on class.class_id = fees.class_id inner join campus on class.campus_id = campus.campus_id";
cmd.CommandText = query;

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGrid1.DataSource = dt;

conn.Close();
}
catch (Exception ex) {
MessageBox.Show("Error" + ex);
}

这篇关于如何使用ms访问数据库连接5个表使用内连接查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！