error to get data?

vinod jangir

Query = "(SELECT Admission.Student_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +

"(SELECT Admission.Father_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +

"Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID" + Environment.NewLine +

"FROM Batch";

followng error was found

Incorrect syntax near 'Attendance'

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted answer
Try Like below :

Query = "SELECT Admission.Student_Name, Admission.Father_Name, Attendance.Present " + Environment.NewLine +
"FROM Admission INNER JOIN Batch ON Admission.Batch_No=Batch.Batch_No " + Environment.NewLine +
"INNER JOIN Attendance ON Admission.Admission_ID=Attendance.Admission_ID";

Let me know if you are getting any error/exception.
vinod jangir11y ago
sorry but i say i want data behalf comboBox1.SelectedValue is have Batch.Batch_No
Manas Mohapatra11y ago
What you didn't find, data? If so go to SqlServer and execute the sql query -> see the result is coming. Other wise analyse data may joining with wrong column. Please cross check.
vinod jangir11y ago
Query = "SELECT Admission.Student_Name, Admission.Father_Name, Attendance.Present " + Environment.NewLine +
"FROM Admission INNER JOIN Batch ON Admission.Batch_No=Batch.Batch_No " + Environment.NewLine +
"INNER JOIN Attendance ON Admission.Admission_ID=Attendance.Admission_IDand Batch.Batch_No='" + comboBox1.SelectedValue + "'", con);

not find
Bhushan Bhasme11y ago
try out my query..
vinod jangir11y ago
i want to Student_Name, Father_Name from the Admission table
where Admission.Batch_No=Batch.Batch_No

Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID;

there are three table Admission.Batch_No is foren key in Batch.Batch_No and
Admission.Admission_ID is foren key in Attendance.Admission_ID table

i want to data behalf Batch.Batch_No

Query = "(SELECT Admission.Student_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(SELECT Admission.Father_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(select Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID)" + Environment.NewLine +
"(select * FROM Batch)";

following error

The multi-part identifier "Batch.Batch_No" could not be bound.
The multi-part identifier "Batch.Batch_No" could not be bound.
The multi-part identifier "Admission.Admission_ID" could not be bound.
Bhushan Bhasme11y ago
Hi vinod,
Try below Query and try to take the result in reader
"Select Admission.Student_Name as StudentName,Admission.Father_Name as FatherName,Attendance.Present as Attendance FROM ((Admission inner join Batch on Admission.Batch_No=Batch.Batch_No) inner join Attendance on Admission.Admission_ID=Attendance.Admission_ID) "
try to use datareader by column name

Datareader _reader=comman.ExecuteReader();
string Data="";
while(_reader.read()){
Data= _reader["StudentName"].ToString();
}

Here I have Given Sample Example...its Not Final one..You need To manipulate As Per your Need..
Try This Out..If Any Query Then Plesae Let disscuss.
Ravi Kumar11y ago
try the fallowing
Query = "(SELECT Admission.Student_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(SELECT Admission.Father_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(select Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID)" + Environment.NewLine +
" (select * FROM Batch)";
Manas Mohapatra11y ago
Your query looks like below which is syntatically incorrect:

(SELECT Admission.Student_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)
(SELECT Admission.Father_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)
Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID
FROM Batch

Please provide what do you want retrieve from two tables and what is relation between them?

Secondly Query value is assigned one time only or it is appending later or before this statement.
vinod jangir11y ago
following error

Incorrect syntax near the keyword 'FROM'.
Ravi Kumar11y ago
try the fallowing
Query = "(SELECT Admission.Student_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(SELECT Admission.Father_Name FROM Admission WHERE Admission.Batch_No=Batch.Batch_No)" + Environment.NewLine +
"(select Attendance.Present FROM Attendance WHERE Admission.Admission_ID=Attendance.Admission_ID)" + Environment.NewLine +
" FROM Batch";