i get data from database

vinod jangir

try

{

if (comboBox1.SelectedIndex >= 0)

{

if (con.State == ConnectionState.Closed)

con.Open();

da = new SqlDataAdapter("select Student_Name, Father_Name from Admission where Admission_ID '" + comboBox1.SelectedValue + " '", con);

dt = new DataTable();

DataTable studentdatabase = new DataTable();

da.Fill(studentdatabase);

dataGridView1.DataSource = new BindingSource(studentdatabase, null);

con.Close();

}

else

{

MessageBox.Show("Select an Batch No");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

but following error

Incorrect syntax near 'hghgh '.

hghgh is my Admission_ID.

5 Replies

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

Bhushan Bhasme11y ago
Accepted answer
hi vinod,
Do like this
da = new SqlDataAdapter("select Student_Name, Father_Name from Admission where Admission_ID='"+ comboBox1.SelectedValue+"'" , con)
Hope this will help You
vinod jangir11y ago
Thinks I Got Its
vinod jangir11y ago
da = new SqlDataAdapter("select Student_Name, Father_Name from Admission where Admission.Admission_ID = Batch.Admission_ID and Batch_No='" + comboBox1.SelectedValue + "'", con);

i confused
Bhushan Bhasme11y ago
Hi vinod,
If You want to Get The data from both the table u need to use joins.below is example You can manipulate as per your need like..
Select ad.x as Name,ad.y as Address,ad.z as DOB,bt.batchTime as batchTime,bt.Fee as batchFee from Admission ad inner join Batch bt on ad.ID=bt.admissionId
where
ad is alias for Admission
bt is alias for Batch
bt.AdmissionId is foriegn key of AdmissionTable
Hope This Will help you
vinod jangir11y ago
hello say m i want data using foren key what can i do
i create two table one admission and second batch admission id is foren key in batch table and one batch no colum in batch table .
how can access admission table data behalf batch no in batch.