Hi,
Use this.. This statement will store the data in "results" array.
DataTable docData= new DataTable();
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlDataAdapter da = new SqlDataAdapter("SELECT emp_name FROM employee", con))
{
da.Fill(docData);
}
}
string[,] results = new string[doows.Count, docData.Columns.Count];
for (int rowCount = 0; rowCount < docData.Rows.Count; rowCount++)
{
for (int colCount = 0; colCount < docData.Columns.Count; colCount++)
{
results[rowCount, colCount] = docData.Rows[rowCount][colCount].ToString();
}
}
All the best.
--Amit