Loading

Data table to array and return array

Data table to array and return array

Dinesh Santhalingam

9y1.5kVisual Basic .NET

[System.Web.Services.WebMethod]
public void loaddata()
string sql = "SELECT Name,Time,Inuse FROM table4";
using (SqlConnection Connection = new SqlConnection((@"Data Source)))
{
using (SqlCommand myCommand = new SqlCommand(sql, Connection))
{
Connection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
DataTable dt = new DataTable();
dt.Load(myReader);
Connection.Close();
DataView dv = new DataView(dt);
dv.RowFilter = (("Name='ACVX'"));
var tableEnumerable = dv.ToTable().AsEnumerable();
var tableArray = tableEnumerable.ToArray();
return tableArray ;//Error
}
}
}
}

I Want to load my datatable into an Var Array and Return the array .suggest some ideas to do my TASK..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Accepted answer
Hi,

In your function, you need to change return type from void to Array.

public Array loaddata()
{
}
Salman Beg9y ago
Please change your method return type as Array and after that everything will be fine.
thanks.
Veena Sarda9y ago
Please mention the error message you are receiving.