I Am getting Error "incorrect syntax near Order"
public DataTable GetOrderId()
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ToString());
MyConnection oconnection = new MyConnection();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select OrderID from Order", connection);
for (int i = 0; i <= dt.Rows.Count; i++)
{
da.Fill(dt);
}
return dt;
}