error to get data?

Question

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'

Manas Mohapatra · 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.

Manas Mohapatra · Answer

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 jangir · Answer

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

vinod jangir · Answer

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 Bhasme · Answer

Hi vinod Try below Query and try to take the result in reader Select Admission.Student_Name as StudentNameAdmission.Father_Name as FatherNameAttendance.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 Kumar · Answer

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 Mohapatra · Answer

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.

Ravi Kumar · Answer

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;

vinod jangir · Answer

sorry but i say i want data behalf comboBox1.SelectedValue is have Batch.Batch_No

Bhushan Bhasme · Answer

try out my query..

vinod jangir · Answer

following error Incorrect syntax near the keyword 'FROM'.