Re: How to store the retrieved values from a coulmn of a table in an array?? - C# Discussion Boards

Pete O'Hanlon9-Aug-07 22:21

Pete O'Hanlon

9-Aug-07 22:21

Please don't cross post. If I do a search on your user am I going to find lots and lots of posts asking the same question? If so, remove the ones that have no replies attached to them.

Deja View - the feeling that you've seen this post before.

Talal Sultan9-Aug-07 22:31

9-Aug-07 22:31

Could you at least make the effort of writing in correct English please?! As far as I know, we are not limited by the number of characters in a post and NO, writing in SMS format is NOT cool!

-- If this is a post that has been helpful to you, please vote for it. Thank you!

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook

J4amieC9-Aug-07 23:14

J4amieC

9-Aug-07 23:14

Well said.

---

How to get answers to your questions[^]

mav.northwind10-Aug-07 1:18

mav.northwind

10-Aug-07 1:18

Dear Mrinal,

here are the letters that seem to be broken on your keyboard.
Please insert them in the correct places using copy&paste and then try re-posting your question, so that people are able to read it properly.

I', a, d, a, d, n, o, l, o, g, y, a, e, ., a, d, I', ., e, a, e, a, d, e, .

Regards,
mav

--
Black holes are the places where God divided by 0...

How to store the retrieved values from a coulmn of a table in an array??

Harkamal Singh12-Aug-07 6:45

Harkamal Singh

12-Aug-07 6:45

rameshbhojan9-Aug-07 21:41

Re: How to store the retrieved values from a coulmn of a table in an array??

9-Aug-07 21:41

Hi All,
PLease let me know if how can a save the values in a column from a database in an array using C# .NET Web Application (so that i could use each value in the array in my code one by one.)
For Eg.: if i have the following query:

SELECT Name FROM Details WHERE Country='India'
here "Name" and "Country" are two columns in table called "Details".

Suppose the query returns Three values: Ram, John and Sohail
i want these names to be saved in an arraay.

i could not use the "ExecuteScalar" class as it can save only one value into a variable!

please send me the few lines of code necessary to do that using the above mentioned example.

Thanks,
Ramesh

Talal Sultan9-Aug-07 21:55

Re: How to store the retrieved values from a coulmn of a table in an array??

9-Aug-07 21:55

The SELECT command will already return the values in a table format. You need a data reader to loop through the values. You have to create your own DataTable (in this case with one column) and insert the values as you loop the data reader. If you are using SQL Server, you can use the SqlDataReader class.

Assuming you have:

sql command: SqlCommand myCommand = new SqlCommand();
data table: DataTable myTable = new DataTable();

You would have to put something like this

SqlDataReader dr = myCommand.ExecuteReader();

while (dr.Read()) // reads as long as there are values 
{
  DataRow row = myTable.NewRow();
  row[0] = dr.GetString(0); // to get the Name column
  row[1] = ...... // if you have other columns
  myTable.Rows.Add(row);
}
dr.Close();

Good luck

Talal

Giorgi Dalakishvili9-Aug-07 22:03

Giorgi Dalakishvili

9-Aug-07 22:03

Instead of manually adding each row to the datatable you can use dataadapter to fetch all the values

#region signature
my articles
#endregion

Re: How to store the retrieved values from a coulmn of a table in an array??

rameshbhojan10-Aug-07 0:42

Re: How to store the retrieved values from a coulmn of a table in an array??

10-Aug-07 0:42

Thanks Talal Smile | :)

Now how do i get these values from row and save in a array variable, which i need to pass as a parameter to a method???

Talal Sultan10-Aug-07 2:10

Re: How to store the retrieved values from a coulmn of a table in an array??

10-Aug-07 2:10

Like I said in my second post here http://www.codeproject.com/script/comments/forums.asp?msg=2176578&forumid=1649#xx2176578xx[^], you need to replace the data table stuff with the array stuff. Since you only return one column from the database, you would only need column 0 of the data reader:

ArrayList myList = new ArrayList();
SqlDataReader dr = myCommand.ExecuteReader();
while (dr.Read()) // reads as long as there are values 
    myList.Add(dr.GetString(0)); // to get the Name column  
dr.Close();

If your method has an Array parameter, you can convert ArrayList into Array as follows:

Array myArray = myList.ToArray();

rameshbhojan19-Aug-07 22:58

Re: How to store the retrieved values from a coulmn of a table in an array??

19-Aug-07 22:58

Thanks talal Smile | :)

Now if i wanna display all these values in the array(or datareader) in a dropdown list.... how do i do that???????

Talal Sultan19-Aug-07 23:21

Re: How to store the retrieved values from a coulmn of a table in an array??

19-Aug-07 23:21

You need to do a databinding.

If you have your data in the datatable as I first described, you would do as follows.

Supposing DataTable myTable = new DataTable(); is your table where the values are stored and DropDownList ddlFoo; is your drop down list, you would bind like this:

ddlFoo.DataSource = myTable;
ddlFoo.DataTextField = "ColumnNameForText";
ddlFoo.DataValueField = "ColumnNameForValue";
ddlFoo.DataBind();

Remember that you can only bind 2 columns of the table, one column should contain the text to be displayed in the DDL and one column should contain the corresponding value for each entry.

If you are using the ArrayList as I described ArrayList myList = new ArrayList(); you need to make sure that the object that you added in the array has 2 fields where you would place the text and the value fields. I use System.Web.UI.WebControls.ListItem because this class has 2 properties Text and Value. You would then make the binding in the same way you would do for the data table:

ddlFoo.DataSource = myList;
ddlFoo.DataTextField = "Text";
ddlFoo.DataValueField = "Value";
ddlFoo.DataBind();

Here we put Text and Value because these are the names of the properties of the ListItem class, but if you used another class with other fields, you would put their name here.

Hope this helps.

Talal

Giorgi Dalakishvili9-Aug-07 21:56

Giorgi Dalakishvili

9-Aug-07 21:56

You can use executereader, read all the values and store them in array but in my opinion arraylist would be better as you don't know how many values you'll need to store. But why do you need it? You can store values in datatable and then access them very easily.

#region signature
my articles
#endregion

Re: How to store the retrieved values from a coulmn of a table in an array??

rameshbhojan19-Aug-07 21:19

Re: How to store the retrieved values from a coulmn of a table in an array??

19-Aug-07 21:19

Could you please give me a sample code(using my example above) to do the same as u mentioned.......

Giorgi Dalakishvili19-Aug-07 21:22

Giorgi Dalakishvili

19-Aug-07 21:22

http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp

#region signature
my articles
#endregion

Re: How to store the retrieved values from a coulmn of a table in an array??

Talal Sultan9-Aug-07 21:57