Bind sql data source to dropdownlist

private void fillExamList()

{

string selectExamination = "SELECT ExamCode, ExamType + ',' + ExamDate AS ExamList FROM Examination WHERE PatientID = " + txtSearchID.Text + "";

SqlDataAdapter daExamination = new SqlDataAdapter(selectExamination, conn);

string selectNTexamination = "SELECT ExamCode, N'?????? ??????, ' + ExamDate AS ExamList FROM NTexamination WHERE PatientID = " + txtSearchID.Text + "";

SqlDataAdapter daNTexamination = new SqlDataAdapter(selectNTexamination, conn);

DataSet dsExaminations = new DataSet();

try

{

conn.Open();

daExamination.Fill(dsExaminations);

daNTexamination.Fill(dsExaminations);

foreach (DataRow dr in dsExaminations.Tables["Table"].Rows)

{

string strExamList = dr["ExamList"].ToString();

string[] arrExamList = strExamList.Split(',');

if (arrExamList[0] == "0")

dr["ExamList"] = "????? ??????, " + arrExamList[1];

else if (arrExamList[0] == "1")

dr["ExamList"] = "????? ??????, " + arrExamList[1];

}

ddlExamList.DataValueField = "ExamCode";

ddlExamList.DataTextField = "ExamList";

ddlExamList.DataSource = dsExaminations;

ddlExamList.DataBind();

ddlExamList.Items.Insert(0, new ListItem("??? ?????? ?????...", "0"));

}

catch (Exception ex)

{

ErrorHandling(ex.ToString());

}

finally

{

conn.Close();

}

}

 

Thank you all for helping me.

I have learned a lot from your answers.

This is my final code.

I have managed to combine two table from my database to one DropDownList

Hi Ron,

 

Just you need to add one more column in your select statement everything looks fine.

 

Hi Ron,

 

   It seems like there is no column in the name of ExamType in your table.

 

   Can you share your table script?