如何使用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屋!