generate array

[Member_3259094]

hi every buddy i have a table with single colums named id. and i want to change is column into array please reply some one

rajeev kumar sharma vri software pvt. ltd. new delhi India

[Christian Graus]

An array is not a valid datatype for an item in a database. Or do you mean you want to turn all those values into a single array ? Which bit are you stuck on ?

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[rihdus]

Do you mean SQL Array for temp use in stored procedures etc or scripting/programming array in application? and whats your platform. for SQL Array : Read following
The ARRAY In SQL Server 2000 [^] In ASP.NET you can use dataset which will provide you the built in rows array for that column.

Any systematic work reflects its significance for a long time. So let's discuss the best...

[Member_3259094]

actualy i am working on asp.net with c# and i have generate a data table which contain the one column name id. and i want to generate an array which contains to values of that table (id)

rajeev kumar sharma vri software pvt. ltd. new delhi India

[Leyu]

DataTable dt = yourdataset.Tables[0]; List ids = new List(); foreach(DataRow row in dt.Rows) { ids.Add(((int)row[0])); } //Now you have the list of ids from the table.