Add string to DataSet

Ron Aricha

7y1.9k.NET

Hello,

I want to add to the DataSet in the highlighted line a variable of type string

How to do this?

private void fillExamList()

{

string selectExamination = "SELECT ExamType.ExamTypeString, FullName, ExamDate, ExamCode FROM ExamType INNER JOIN Examination ON ExamType.ExamType = Examination.ExamType WHERE PatientID = " + txtSearchID.Text + "";

SqlDataAdapter da = new SqlDataAdapter(selectExamination, conn);

DataSet ds = new DataSet();

try

{

conn.Open();

da.Fill(ds);

ds.Tables[0].Columns.Add("ExamList", typeof(string), "FullName + ', ' + ExamTypeString");

ddlExamList.DataValueField = "ExamCode";

ddlExamList.DataTextField = "ExamList";

ddlExamList.DataSource = ds;

ddlExamList.DataBind();

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

}

catch (Exception ex)

{

ErrorHandling(ex.ToString());

}

finally

{

conn.Close();

}

4 Replies

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

Jignesh Kumar7y ago
Accepted answer
Hi Ron,

You can do it ealisy by your selecl query change. This column not require in dataset while fetching record from databse. you can write like below
string selectExamination = "SELECT FullName + ExamType.ExamTypeString As ExamList, ExamDate, ExamCode FROM ExamType INNER JOIN Examination ON ExamType.ExamType = Examination.ExamType WHERE PatientID = " + txtSearchID.Text + "";
SqlDataAdapter da = new SqlDataAdapter(selectExamination, conn);
DataSet ds = new DataSet();
try
{
conn.Open();
da.Fill(ds);

ddlExamList.DataValueField = "ExamCode";
ddlExamList.DataTextField = "ExamList";
ddlExamList.DataSource = ds;
ddlExamList.DataBind();
ddlExamList.Items.Insert(0, new ListItem("Select...", "0"));
Ron Aricha7y ago
Yes

I see it now

You mean like this

string selectExamination = "SELECT FullName + ExamType.ExamTypeString + 'My String' As ExamList, ExamDate, ExamCode FROM ExamType INNER JOIN Examination ON ExamType.ExamType = Examination.ExamType WHERE PatientID = " + txtSearchID.Text + "";

Thank you
Jignesh Kumar7y ago
Yes, you are right but you can concatinate two column and create name while writing sql qurry which one assign to your dataitemText value to display in dropdown. I modified your query in first answer which will give column ExamList from database which you can assign direct to dropdown
Ron Aricha7y ago
I need to add a string that is not part of the database