MYSQL TABLE RECORDS TO ARRAY

[KipkoechE]

am looking for a way i can loop through records in mysql table and place the records in an array ...Kindly help

[Afzaal Ahmad Zeeshan]

Continue it like this,

1. Get the records from your database, using a SELECT clause.
2. Save that response into a variable of type array (or a generic list).

Which language are you actually using? C#, Java, C++, PHP? It depends on which framework and language you're using. The language would allow you to perform such actions on the objects (or the list of the object) that is being returned. Usually results from the database are in a form of an array or list.

The shit I complain about It's like there ain't a cloud in the sky and it's raining out - Eminem ~! Firewall !~

[KipkoechE]

using Vb.net...am trying to achieve it but cant figure to do it

[KipkoechE]

kindly guide me on this

[Lost User]

..and please stop shouting the subject.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[sanket164]

public void GetDatainArr()
{
string strSQl = "";
string[] Arr = new string[50];
strSQl = "select [Id] from [tblname] ";
DataTable dt = GetDataTable(strSQl); //GetDataTable function
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Arr[i] = Convert.ToString(dt.Rows[i][0]);
}
}
}
public DataTable GetDataTable(string Sql)
{
SqlConnection conn = new SqlConnection("ConnectionString ");
conn.Open();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(Sql, conn);
SqlDataAdapter ad = new SqlDataAdapter();
ad.Fill(dt);
conn.Close();
return dt;
}

This code in C# so you can Convert this code in vb using this link http://www.developerfusion.com/tools/convert/csharp-to-vb/

Sanket Gandhi