C# and database

[prokopis]

i have a small problem.
am writting a program in c# with sql server
this that i want is to take a particular row from the database and put all the fields of that row to a 2d array
example database
ID name surname
1 prokopis prokopis
2 marios marios
i have connect the program with the database but the problem is that i don't know how to insert the specific row to the array.
the code that i use until now
SqlCommand queryDiagnosis = new SqlCommand("SELECT * from [Diagnosis] WHERE [IDD] = " + rowaction[0], dataConnectionDiagnosis);
SqlDataAdapter dataAdapter = new SqlDataAdapter(queryDiagnosis);
dataAdapter.Fill(datasetDiagnosis, "[Diagnosis]");
SqlDataReader myreader = queryDiagnosis.ExecuteReader();
int[ , ] tablelist = new int[rownumber, columsize];

for exampe i want the user with id egual 2 all the data to be insert on the array tablelist.could someone help me pls???

[kenobewan]

This post may help:
ADO or ADOn't, binding data to an array?

[prokopis]

thanks you for the link that you gave me.i might even chang it to a datatable too

[balabaster]

thanks you for the link that you gave me.i might even chang it to a datatable too

VB

Dim fileName As String = "C:\MyDB.accdb"
Dim tableName As String = "MyTable"
Dim rowToExtract As Integer = 2
Dim sConStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & fileName & ";Persist Security Info=False;"
Dim oDA As New OleDbDataAdapter("Select * From " & tableName, sConStr)
Dim oDS As New DataSet("MyDataSet")
oDA.Fill(oDS, "MyTable")
Dim oDT As DataTable = oDS.Tables("MyTable")
Dim Data As Array = oDT.Rows(rowToExtract).ItemArray
 

C#

string fileName = "C:\\MyDB.accdb";
string tableName = "MyTable";
int rowToExtract = 2;
string sConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Persist Security Info=False;";
OleDbDataAdapter oDA = new OleDbDataAdapter("Select * From "+ tableName, sConStr);
DataSet oDS = new DataSet("MyDataSet");
oDA.Fill(oDS, "MyTable");
DataTable oDT = oDS.Tables["MyTable"];
Array Data = oDT.Rows[rowToExtract].ItemArray;