how to convert a value inside a dataTable to string in asp.net c#

Question

The code below is to retrieve a category for a particular id. it will only return just one value say "Sport" to the dataTable. How to i convert the dataTable value to a string. I want to make use of this value for other things in the application

var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ToString());
                    conn.Open();
                    var da = new SqlDataAdapter("Select Product_Category from Product 
            where 
                     Product_Id =" + fo, conn);
                     da.Fill(mydata);
                     conn.Close();

Use SqlCommand.ExecuteScalar Method () msdn.microsoft.com/en-us/library/… — Sain Pradeep
– Sain Pradeep, Commented May 9, 2017 at 11:07
I can't tell if myData is a DataSet or DataTable. Here is solution : List<string> results = mydata.AsEnumerable().Select(x => x.Field<string>("Select Product_Category")).ToList(); or List<string> results = mydata.Table[0].AsEnumerable().Select(x => x.Field<string>("Select Product_Category")).ToList(); — jdweng
– jdweng, Commented May 9, 2017 at 11:16
if you have single column in datatable than you may check my answer. — Love Pandey
– Love Pandey, Commented Jun 20, 2019 at 8:08

Kevin Shah · Accepted Answer · 2017-05-09 11:21:39Z

1

you can use below code

string Product_Category = String.Empty;
if(mydata.Rows.Count>0)
{
Product_Category = mydata.Rows[0]["Product_Category"].ToString();
}

Assuming that mydata is DataTable here.

answered May 9, 2017 at 11:21

Kevin Shah

1,6122 gold badges14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mcbaloo Over a year ago

made mistake with the code. mydata is a DataTable. I will check out your answer now

Love Pandey · Accepted Answer · 2019-06-20 08:07:26Z

0

If you have a single column in datatable than it's simple to change datatable to string.

DataTable results = MyMethod.GetResults(); // i am getting data from getresult function
if(results != null && results.Rows.Count > 0)  // Check datatable is null or not
{
  List<string> lstring = new List<string>();
  foreach(DataRow dataRow in dt.Rows)
  {
     lstring.Add(Convert.ToString(dataRow["ColumnName"]));
  }
  string mainresult = string.Join(",", lstring.ToArray()); // You can Use comma(,) or anything which you want. who connect the two string. You may leave space also.
}
Console.WriteLine (mainresult);

answered Jun 20, 2019 at 8:07

Love Pandey

3302 silver badges10 bronze badges

Collectives™ on Stack Overflow

how to convert a value inside a dataTable to string in asp.net c#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related