I have a dataset that contains multiple tables in it. What I want to do is find a way to take the values(and when I say "values" I do mean the plural "values") from a column within one table of the dataset and display them in a textbox. When I try to feed the values into an arraylist the values do not display correctly in design time. (Just shows the namespace object in the preview tab of VisualStudio) When I add the values to a string, I get the last value in the column which doesn't help me but it at least means I can iterate through the column values. Any idea as to how to make this work? How to get all the values in the column and bind to a textbox value. Below is the code i'm trying to use.
-Jason
| SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=cmdiapp;Password=adiadmin"); |
| SqlCommand selectCommand; |
| connSomsys.Open(); |
| selectCommand = new SqlCommand("sprocgetProductListQuoteTotals", connSomsys); |
| selectCommand.CommandType = CommandType.StoredProcedure; |
| SqlDataAdapter adapter = new SqlDataAdapter(selectCommand); |
| DataSet dataSet = new DataSet(); |
| adapter.Fill(dataSet); |
| ArrayList myAL = new ArrayList(); |
| DataTable tbl = dataSet.Tables[1]; |
| for (int i = 0; i < tbl.Rows.Count; i++) |
| { |
| DataRow myRow = tbl.Rows[i]; |
| myAL.Add(myRow["ProductList"].ToString()); |
| } |
| textBox4.Value = myAL.ToString(); |